Microsoft Excel 365 Bible

Introduction xxxix

Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data 27
Chapter 3: Performing Basic Worksheet Operations 53
Chapter 4: Working with Excel Ranges and Tables 73
Chapter 5: Formatting Worksheets 121
Chapter 6: Understanding Excel Files and Templates 157
Chapter 7: Printing Your Work 177
Chapter 8: Customizing the Excel User Interface 199

Part II: Working with Formulas and Functions 209
Chapter 9: Introducing Formulas and Functions 211
Chapter 10: Understanding and Using Array Formulas 247
Chapter 11: Using Formulas for Common Mathematical Operations 271
Chapter 12: Using Formulas to Manipulate Text 285
Chapter 13: Using Formulas with Dates and Times 301
Chapter 14: Using Formulas for Conditional Analysis 329
Chapter 15: Using Formulas for Matching and Lookups 347
Chapter 16: Using Formulas with Tables and Conditional Formatting 365
Chapter 17: Making Your Formulas Error-Free 379

Part III: Creating Charts and Other Visualizations 399
Chapter 18: Getting Started with Excel Charts 401
Chapter 19: Using Advanced Charting Techniques 441
Chapter 20: Creating Sparkline Graphics 475
Chapter 21: Visualizing with Custom Number Formats and Shapes 489

Part IV: Managing and Analyzing Data 519
Chapter 22: Importing and Cleaning Data 521
Chapter 23: Using Data Validation 553
Chapter 24: Creating and Using Worksheet Outlines 567
Chapter 25: Linking and Consolidating Worksheets 577
Chapter 26: Introducing PivotTables 595
Chapter 27: Analyzing Data with PivotTables 617
Chapter 28: Performing Spreadsheet What-If Analysis 651
Chapter 29: Analyzing Data Using Goal Seeking and Solver 675
Chapter 30: Analyzing Data with the Analysis ToolPak 697
Chapter 31: Protecting Your Work 709

Part V: Understanding Power Pivot and Power Query 721
Chapter 32: Introducing Power Pivot 723
Chapter 33: Working Directly with the Internal Data Model 747
Chapter 34: Adding Formulas to Power Pivot 757
Chapter 35: Introducing Power Query 777
Chapter 36: Transforming Data with Power Query 805
Chapter 37: Making Queries Work Together 837
Chapter 38: Enhancing Power Query Productivity 855

Part VI: Automating Excel 867
Chapter 39: Introducing Visual Basic for Applications 869
Chapter 40: Creating Custom Worksheet Functions 899
Chapter 41: Creating UserForms 913
Chapter 42: Using UserForm Controls in a Worksheet 935
Chapter 43: Working with Excel Events 949
Chapter 44: Seeing Some VBA Examples 963
Chapter 45: Creating Custom Excel Add-Ins 979

Index 989