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

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

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