Excel Dashboards & Reports For Dummies

ISBN-13: 9781119844396 / Angielski / Miękka / 2022 / 384 str.

Michael Alexander

Spis treści

Introduction 1Part 1: Getting Started with Excel Dashboards and Reports 7Chapter 1: Getting in the Dashboard State of Mind 9Chapter 2: Building a Super Model 23Chapter 3: The Pivotal Pivot Table 65Chapter 4: Using External Data for Your Dashboards and Reports 101Part 2: Building Basic Dashboard Components 119Chapter 5: Dressing Up Your Data Tables 121Chapter 6: Sparking Inspiration with Sparklines 139Chapter 7: Formatting Your Way to Visualizations 153Part 3: Adding Charts to Your Dashboards 185Chapter 8: Charts That Show Trending 187Chapter 9: Grouping and Bucketing Data 211Chapter 10: Displaying Performance against a Target 231Part 4: Advanced Reporting Techniques 247Chapter 11: Giving Users an Interactive Interface 249Chapter 12: Adding Interactivity with Pivot Slicers 283Chapter 13: Sharing Your Workbook with the Outside World 303Part 5: The Part of Tens 323Chapter 14: Ten Chart Design Principles 325Chapter 15: Ten Questions to Ask Before Distributing Your Dashboard 339Index 345

O autorze

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years' experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.