Excel 2007 Dashboards and Reports For Dummies

Part I: Making the Move to Dashboards.

Chapter 1: Getting in the Dashboard State of Mind.

Chapter 2: Building a Super Model.

Part II: Building Basic Dashboard Components.

Chapter 3: The Pivotal Pivot Table.

Chapter 4: Excel Charts for the Uninitiated.

Chapter 5: The New World of Conditional Formatting.

Chapter 6: The Art of Dynamic Labeling.

Part III: Building Advanced Dashboard Components.

Chapter 7: Components That Show Trending.

Chapter 8: Components That Group and Bucket Data.

Chapter 9: Components That Display Performance against a Target.

Part IV: Advanced Reporting Techniques.

Chapter 10: Macro-Charged Reporting.

Chapter 11: Giving Users an Interactive Interface.

Part V: Working with the Outside World.

Chapter 12: Using External Data for Your Dashboards and Reports.

Chapter 13: Sharing Your Work with the Outside World.

Part VI: The Part of Tens.

Chapter 14: Ten Chart Design Principles.

Chapter 15: Ten Questions to Ask Before Distributing Your Dashboard.

Index.