Alexander Michael. Excel 2007 Dashboards & Reports for Dummies

Wiley, 2008. – 336 p. – ISBN: 0470228148, 9780470228142Excel 2007 Dashboards & Reports for Dummies fills the gap between handling data and synthesizing data into meaningful reports. This title shows readers how to think about their data in ways other than columns and rows.
What are the most meaningful ways to show trending? How do you show relationships in data? When is showing variances more valuable than showing actual data values? How do you deal with outliers? How do you bucket data in the most meaningful way. How do you show impossible amounts of data without inundating your audience? In Excel 2007 Dashboards & Reports for Dummies, readers get answers to all these questions.Making the Move to Dashboards.
Getting in the Dashboard State of Mind.
Building a Super Model.
Building Basic Dashboard Components.
The Pivotal Pivot Table.
Excel Charts for the Uninitiated.
The New World of Conditional Formatting.
The Art of Dynamic Labeling.
Building Advanced Dashboard Components.
Components That Show Trending.
Components That Group and Bucket Data.
Components That Display Performance against a Target.
Advanced Reporting Techniques.
Macro-Charged Reporting.
Giving Users an Interactive Interface.
Working with the Outside World.
Using External Data for Your Dashboards and Reports.
Sharing Your Work with the Outside World.
The Part of Tens.
Ten Chart Design Principles.
Ten Questions to Ask Before Distributing Your Dashboard.