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