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 135 key techniques with Excel PivotTables and PivotCharts, including:

*

Creating a table for a PivotTable report
*

Converting a PivotTable to regular data
*

Changing the Report Filter layout
*

Formatting PivotTable cells
*

Displaying a data table with a PivotChart
*

Performing PivotTable calculations
*

Building formulas for PivotTables
*

Filtering records with Query criteria
*

Creating an OLAP cube data source
*

Learning VBA basics for PivotTables
*

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
*

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