Microsoft 365 Excel All-In-One for Dummies

Biographical Note:

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).

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

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

Get into the nitty gritty of Excel, the all-important spreadsheet tool

Microsoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organizing data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply advanced formulas and functions, create stunning data visualizations, build dashboards and reports, and automate your spreadsheets. You'll also get a glimpse into how AI tools can boost your work. Eight mini-books come together in this expanded Excel reference. With Microsoft 365 Excel All-in-One For Dummies, you'll soon be the go-to Excel guru in your office or school.

• Learn the basics of Excel--organizing data, performing calculations, and formatting your spreadsheet.
• Use functions to handle advanced math and financial analysis.
• Create data visualizations and summaries to help tell your story
• Apply basic programming skills using VBA

This book is perfect for professionals or students who need to up their Excel game with insight from pros who know the classic spreadsheet app inside and out.