Description:
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