[eBook Code] Excel 2016 Bible (eBook Code, 1st)

Acknowledgments ix

Introduction xli

Part I: Getting Started with Excel 1

Chapter 1: Introducing Excel 3

Chapter 2: Entering and Editing Worksheet Data 9

Chapter 3: Essential Worksheet Operations 51

Chapter 4: Working with Cells and Ranges 73

Chapter 5: Introducing Tables 109

Chapter 6: Worksheet Formatting 129

Chapter 7: Understanding Excel Files 157

Chapter 8: Using and Creating Templates 171

Chapter 9: Printing Your Work 181

Part II: Working with Formulas and Functions 205

Chapter 10: Introducing Formulas and Functions 207

Chapter 11: Creating Formulas That Manipulate Text 243

Chapter 12: Working with Dates and Times 263

Chapter 13: Creating Formulas That Count and Sum 297

Chapter 14: Creating Formulas That Look Up Values 327

Chapter 15: Creating Formulas for Financial Applications 349

Chapter 16: Miscellaneous Calculations 381

Chapter 17: Introducing Array Formulas 395

Chapter 18: Performing Magic with Array Formulas 421

Part III: Creating Charts and Graphics 445

Chapter 19: Getting Started Making Charts 447

Chapter 20: Learning Advanced Charting 491

Chapter 21: Visualizing Data Using Conditional Formatting 539

Chapter 22: Creating Sparkline Graphics 563

Chapter 23: Enhancing Your Work with Pictures and Drawings 579

Part IV: Using Advanced Excel Features 601

Chapter 24: Customizing the Excel User Interface 603

Chapter 25: Using Custom Number Formats 613

Chapter 26: Using Data Validation 633

Chapter 27: Creating and Using Worksheet Outlines 647

Chapter 28: Linking and Consolidating Worksheets 657

Chapter 29: Excel and the Internet 677

Chapter 30: Protecting Your Work 689

Chapter 31: Making Your Worksheets Error Free 701

Part V: Analyzing Data with Excel 731

Chapter 32: Importing and Cleaning Data 733

Chapter 33: Introducing Pivot Tables 763

Chapter 34: Analyzing Data with Pivot Tables 785

Chapter 35: Performing Spreadsheet What-If Analysis 823

Chapter 36: Analyzing Data Using Goal Seeking and Solver 841

Chapter 37: Analyzing Data with the Analysis ToolPak 863

Chapter 38: Working with Get & Transform 877

Part VI: Programming Excel with VBA 907

Chapter 39: Introducing Visual Basic for Applications 909

Chapter 40: Creating Custom Worksheet Functions 939

Chapter 41: Creating UserForms 955

Chapter 42: Using UserForm Controls in a Worksheet 977

Chapter 43: Working with Excel Events 993

Chapter 44: VBA Examples 1005

Chapter 45: Creating Custom Excel Add-Ins 1021

Part VII: Appendixes 1031

Appendix A: Worksheet Function Reference 1033

Appendix B: Excel Shortcut Keys 1053

Index 1061