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 55 Chapter 4: Working with Excel Ranges and Tables 75 Chapter 5: Formatting Worksheets 125 Chapter 6: Understanding Excel Files and Templates 161 Chapter 7: Printing Your Work 181 Chapter 8: Customizing the Excel User Interface 203 Part II: Working with Formulas and Functions 213 Chapter 9: Introducing Formulas and Functions 215 Chapter 10: Understanding and Using Array Formulas 251 Chapter 11: Using Common Formulas for Math and Dates 273 Chapter 12: Using Formulas to Manipulate Text 311 Chapter 13: Using Formulas for Conditional Analysis 331 Chapter 14: Using Formulas for Matching and Lookups 347 Chapter 15: Using Formulas with Conditional Formatting 365 Chapter 16: Making Your Formulas Error-Free 379 Part III: Creating Charts and Other Visualizations 399 Chapter 17: Getting Started with Excel Charts 401 Chapter 18: Using Advanced Charting Techniques 439 Chapter 19: Creating Sparkline Graphics 473 Chapter 20: Visualizing with Custom Number Formats and Shapes 487 Part IV: Managing and Analyzing Data 519 Chapter 21: Importing and Cleaning Data 521 Chapter 22: Using Data Validation 553 Chapter 23: Creating and Using Worksheet Outlines 567 Chapter 24: Linking and Consolidating Worksheets 577 Chapter 25: Introducing Pivot Tables 597 Chapter 26: Analyzing Data with Pivot Tables 619 Chapter 27: Performing Spreadsheet What-If Analysis 653 Chapter 28: Analyzing Data Using Goal Seeking and Solver 675 Chapter 29: Analyzing Data with the Analysis ToolPak 695 Chapter 30: Protecting Your Work 707 Part V: Understanding Power Pivot and Power Query 721 Chapter 31: Introducing Power Pivot 723 Chapter 32: Working Directly with the Internal Data Model 747 Chapter 33: Adding Formulas to Power Pivot 757 Chapter 34: Introducing Power Query 787 Chapter 35: Transforming Data with Power Query 813 Chapter 36: Making Queries Work Together 845 Chapter 37: Enhancing Power Query Productivity 861 Part VI: Automating Excel 873 Chapter 38: Introducing Visual Basic for Applications 875 Chapter 39: Creating Custom Worksheet Functions 903 Chapter 40: Creating UserForms 917 Chapter 41: Using UserForm Controls in a Worksheet 939 Chapter 42: Working with Excel Events 953 Chapter 43: Creating Custom Excel Add-Ins 967 Chapter 44: Office Scripts for Excel 977 Index 1009.