Excel 2007 PivotTables and PivotCharts: Your visual blueprint for interpreting and presenting Excel data

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 130 key techniques for working with PivotTables and PivotCharts, including:

* Building PivotTables from Excel ranges

*

Customizing PivotTable field lists

*

Converting PivotTables to regular data

*

Grouping numeric, text, or date/time values

*

Developing various summary calculations

*

Turning a PivotTable into a PivotChart

*

Displaying data tables with a PivotChart

*

Creating an OLAP cube data source

*

Exporting Access(r) PivotTable(r) forms to Excel

*

Using Microsoft Query with PivotTables

EXTRA Apply It

*

"Apply It" and "Extra" sidebars highlight useful tips

*

High-resolution screen shots demonstrate each task

*

Succinct explanations walk you through step by step

*

Two-page lessons break big topics into bite-sized modules