Introduction xli Part I: Getting Started with Excel 1 Chapter 1: Introducing Excel 3 Chapter 2: Entering and Editing Worksheet Data 29 Chapter 3: Performing Basic Worksheet Operations 51 Chapter 4: Working with Excel Ranges and Tables 71 Chapter 5: Formatting Worksheets 117 Chapter 6: Understanding Excel Files and Templates 153 Chapter 7: Printing Your Work 173 Chapter 8: Customizing the Excel User Interface 195 Part II: Working with Formulas and Functions 205 Chapter 9: Introducing Formulas and Functions 207 Chapter 10: Using Formulas for Common Mathematical Operations 239 Chapter 11: Using Formulas to Manipulate Text 253 Chapter 12: Using Formulas with Dates and Times 269 Chapter 13: Using Formulas for Conditional Analysis 295 Chapter 14: Using Formulas for Matching and Lookups 315 Chapter 15: Using Formulas for Financial Analysis 333 Chapter 16: Using Formulas for Statistical Analysis 365 Chapter 17: Using Formulas with Tables and Conditional Formatting 385 Chapter 18: Understanding and Using Array Formulas 399 Chapter 19: Making Your Formulas Error-Free 423 Part III: Creating Charts and Other Visualizations 443 Chapter 20: Getting Started with Excel Charts 445 Chapter 21: Using Advanced Charting Techniques 489 Chapter 22: Creating Sparkline Graphics 523 Chapter 23: Visualizing with Custom Number Formats and Shapes 537 Chapter 24: Implementing Excel Dashboarding Best Practices 567 Part IV: Managing and Analyzing Data 577 Chapter 25: Importing and Cleaning Data 579 Chapter 26: Using Data Validation 613 Chapter 27: Creating and Using Worksheet Outlines 627 Chapter 28: Linking and Consolidating Worksheets 637 Chapter 29: Introducing PivotTables. 655 Chapter 30: Analyzing Data with PivotTables 679 Chapter 31: Performing Spreadsheet What-If Analysis 715 Chapter 32: Analyzing Data Using Goal Seeking and Solver r 733 Chapter 33: Analyzing Data with the Analysis ToolPak 755 Chapter 34: Protecting Your Work 769 Part V: Understanding Power Pivot and Power Query 781 Chapter 35: Introducing Power Pivot 783 Chapter 36: Working Directly with the Internal Data Model 807 Chapter 37: Adding Formulas to Power Pivot 817 Chapter 38: Introducing Power Query. y 835 Chapter 39: Transforming Data with Power Query. 859 Chapter 40: Making Queries Work Together r 887 Chapter 41: Enhancing Power Query Productivity 903 Part VI: Automating Excel 915 Chapter 42: Introducing Visual Basic for Applications 917 Chapter 43: Creating Custom Worksheet Functions 947 Chapter 44: Creating UserForms 961 Chapter 45: Using UserForm Controls in a Worksheet 983 Chapter 46: Working with Excel Events 997 Chapter 47: Seeing Some VBA Examples 1011 Chapter 48: Creating Custom Excel Add-Ins 1027 Index x 1037