Excel Dashboards & Reports for Dummies, 2ed

Part I: Getting Started with Excel Dashboards and Reports

Chapter 1: Getting in the Dashboard State of Mind

Chapter 2: Building a Super Model

Data Modeling Best Practices

Part II: Building Basic Dashboard Components  

Chapter 3: Dressing Up Your Data Tables

Chapter 4: Sparking Inspiration with Sparklines  

Chapter 5: Formatting Your Way to Visualizations

Chapter 6: The Pivotal Pivot Table

Part III: Building Advanced Dashboard Components  

Chapter 7: Charts That Show Trending  

Chapter 8: Grouping and Bucketing Data

Part IV: Advanced Reporting Techniques  

Chapter 10: Macro-Charged Dashboarding

Chapter 11: Giving Users an Interactive Interface

Chapter 12: Adding Interactivity with Pivot Slicers  

Part V: Working with the Outside World  

Chapter 13: Using External Data for Your Dashboards and Reports  

Chapter 14: Sharing Your Workbook with the Outside World      

Part VI: The Part of Tens  

Chapter 15: Ten Chart Design Principles

Chapter 16: Ten Questions to Ask Before Distributing Your Dashboard