This book collects bestselling Excel content from the For Dummies series, including selections from Microsoft 365 Excel For Dummies (David H. Ringstrom), Microsoft Excel Dashboards & Reports (Michael Alexander), Microsoft 365 Excel Formulas & Functions For Dummies (Ken Bluttman), Microsoft Excel Power Pivot & Power Query For Dummies (Michael Alexander), Microsoft Excel Data Analysis For Dummies (Paul McFedries), Excel Macros For Dummies (Dick Kusleika).

Select Guide Rating

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

This book collects bestselling Excel content from the For Dummies series, including selections from Microsoft 365 Excel For Dummies (David H. Ringstrom), Microsoft Excel Dashboards & Reports (Michael Alexander), Microsoft 365 Excel Formulas & Functions For Dummies (Ken Bluttman), Microsoft Excel Power Pivot & Power Query For Dummies (Michael Alexander), Microsoft Excel Data Analysis For Dummies (Paul McFedries), Excel Macros For Dummies (Dick Kusleika).

Select Guide Rating

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

This book collects bestselling Excel content from the For Dummies series, including selections from Microsoft 365 Excel For Dummies (David H. Ringstrom), Microsoft Excel Dashboards & Reports (Michael Alexander), Microsoft 365 Excel Formulas & Functions For Dummies (Ken Bluttman), Microsoft Excel Power Pivot & Power Query For Dummies (Michael Alexander), Microsoft Excel Data Analysis For Dummies (Paul McFedries), Excel Macros For Dummies (Dick Kusleika).

Select Guide Rating

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