Excel 2007 Dashboards and Reports For Dummies
In this book, I show you how to leverage Excel functionality to build and manage better reporting mechanisms. Each chapter in this book provides a comprehensive review of the technical and analytical concepts that help you create better components that can be used for both dashboards and reports.   After reading this book, you will be able to:

* Analyze large amounts of data and report their data in a meaningful way
* Get better visibility into data from different perspectives
* Quickly slice data into various views on the fly
* Automate redundant reporting and analyses
* Create eye-catching visualizations
* Create impressive dashboards and What-If analyses

• Chapter 1:  Getting in the Dashboard State of Mind

• Chapter 2:  Building a Super Model

• 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

• Chapter 7:  Components that Show Trending

• Chapter 8:  Components that Group and Bucket Data

• Chapter 9:  Components that Display Performance against a Target

• Chapter 10:  Macro Charged Reporting

• Chapter 11:  Giving Users an Interactive Interface

• Chapter 12:  Using External Data in your Dashboards and Reports

• Chapter 13:  Sharing Your Work with the Outside World

• Chapter 14:  Ten Chart Design Principles

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