Introduction 1 Book 1: Getting Started with Excel 5 Chapter 1: Getting Started with Spreadsheets 7 Chapter 2: Carrying Out Basic Calculations 31 Chapter 3: Formatting Cells and Worksheets 53 Chapter 4: Organizing Data and Creating Tables 79 Chapter 5: Navigating Worksheets and Workbooks 113 Book 2: Working with Formulas and Functions 129 Chapter 1: Tapping Into Formula and Function Fundamentals 131 Chapter 2: Saving Time with Function Tools 161 Chapter 3: Building Array Formulas and Functions 177 Chapter 4: Fixing Errors in Formulas 191 Book 3: Going Farther with Functions 207 Chapter 1: Calculating Loans, Interest, and Depreciation 209 Chapter 2: Performing Functional Math. 241 Chapter 3: Working with Date and Time Functions 271 Chapter 4: Manipulating Text with Functions 291 Book 4: Analyzing Data 317 Chapter 1: Using Basic Data Analysis Techniques 319 Chapter 2: Working with Data Analysis Tools 343 Chapter 3: Analyzing Table Data with Functions 365 Book 5: Summarizing, Visualizing, and Illustrating Data 377 Chapter 1: Creating Charts 379 Chapter 2: Creating and Using PivotTables 391 Chapter 3: Performing PivotTable Calculations 413 Chapter 4: Building PivotCharts 435 Book 6: Reporting and Querying Data 455 Chapter 1: Introducing Power Pivot 457 Chapter 2: Advanced Moves with PivotTables 469 Chapter 3: Working Directly with the Internal Data Model 499 Chapter 4: Adding Formulas to Power Pivot 513 Chapter 5: Meeting Power Query and Its Connection Types 531 Book 7: Creating Dashboards and Reports 559 Chapter 1: Getting in the Dashboard State of Mind 561 Chapter 2: Building a Super Model 575 Chapter 3: Dressing Up Your Data Tables 619 Chapter 4: Formatting Your Way to Visualizations 635 Chapter 5: Displaying Performance against a Target 663 Book 8: Automating Excel with Macros and VBA 679 Chapter 1: Macro Fundamentals 681 Chapter 2: Getting Cozy with the Visual Basic Editor 701 Chapter 3: The Anatomy of Macros 715 Chapter 4: Working with Workbooks 729 Index 753.