Excel 2019 Bible (Paperback)

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