Autorentext

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

Klappentext

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

Inhalt

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