Read more
Your essential guide to Excel expertise Almost every job and profession requires digging into an Excel spreadsheet from time to time. You can spend hours of trial and error figuring out how to make Excel work for you, or jump right to the answers you need with the help of this book. This collection of Excel insight walks you through the basics of spreadsheet creation and dives into creating next-level formulas, data visualizations, and analysis. It's the roadmap to unleashing the Excel guru inside of you!
8 Books Inside... - Getting Started with Excel
- Writing Formulas and Functions
- Going Farther with Functions
- Analyzing Data
- Summarizing and Visualizing Data
- Reporting and Querying Data
- Creating Dashboards and Reports
- Automating Excel
List of contents
Introduction 1
Book 1: Getting Started with Excel 5 Chapter 1: Getting Started with Spreadsheets 7
Chapter 2: Carrying Out Basic Calculations 31
Chapter 3: Formatting Cells and Worksheets 53
Chapter 4: Organizing Data and Creating Tables 79
Chapter 5: Navigating Worksheets and Workbooks 113
Book 2: Working with Formulas and Functions 129 Chapter 1: Tapping Into Formula and Function Fundamentals 131
Chapter 2: Saving Time with Function Tools 161
Chapter 3: Building Array Formulas and Functions 177
Chapter 4: Fixing Errors in Formulas 191
Book 3: Going Farther with Functions 207 Chapter 1: Calculating Loans, Interest, and Depreciation 209
Chapter 2: Performing Functional Math. 241
Chapter 3: Working with Date and Time Functions 271
Chapter 4: Manipulating Text with Functions 291
Book 4: Analyzing Data 317 Chapter 1: Using Basic Data Analysis Techniques 319
Chapter 2: Working with Data Analysis Tools 343
Chapter 3: Analyzing Table Data with Functions 365
Book 5: Summarizing, Visualizing, and Illustrating Data 377 Chapter 1: Creating Charts 379
Chapter 2: Creating and Using PivotTables 391
Chapter 3: Performing PivotTable Calculations 413
Chapter 4: Building PivotCharts 435
Book 6: Reporting and Querying Data 455 Chapter 1: Introducing Power Pivot 457
Chapter 2: Advanced Moves with PivotTables 469
Chapter 3: Working Directly with the Internal Data Model 499
Chapter 4: Adding Formulas to Power Pivot 513
Chapter 5: Meeting Power Query and Its Connection Types 531
Book 7: Creating Dashboards and Reports 559 Chapter 1: Getting in the Dashboard State of Mind 561
Chapter 2: Building a Super Model 575
Chapter 3: Dressing Up Your Data Tables 619
Chapter 4: Formatting Your Way to Visualizations 635
Chapter 5: Displaying Performance against a Target 663
Book 8: Automating Excel with Macros and VBA 679 Chapter 1: Macro Fundamentals 681
Chapter 2: Getting Cozy with the Visual Basic Editor 701
Chapter 3: The Anatomy of Macros 715
Chapter 4: Working with Workbooks 729
Index 753
About the author
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).
