Curt begins with a primer on using PivotTables—one of the most powerful data analysis tools in Excel. He also shares how to define conditional formats and summarize your data with sparklines and charts. Plus, he shows how to set up your dashboard worksheet, link data to cells and shapes, maximize your screen space by hiding rows, and modify the Excel program window to meet your needs.

Topics include:
* Managing data using Excel tables
* Managing PivotTables and PivotCharts
* Summarizing table and PivotTable data
* Defining conditional formats
* Creating sparklines
* Sketching your dashboard layout
* Creating and managing cell links
* Linking cell contents to a shape
* Linking to a PivotTable cell
* Extending your dashboard using hidden rows