Table of Contents
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
