Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets

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

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