Excel 2019 Bible

Michael Alexander is a Microsoft MVP and author of several books on advanced business analysis. He shares his wisdom from more than fifteen years consulting and developing reporting solutions for a variety of industries as the principle contributor at DataPigTechnologies.com, where he offers free video tutorials with the Microsoft Excel and Access communities.

Dick Kusleika is a twelve-time Microsoft Excel MVP and principle contributor at the Daily Dose of Excel blog.

John Walkenbach, principal of J-Walk and Associates, Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books including all previous editions of the Excel Bible.

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