Course Outline

Microsoft Excel Mastering Pivot Tables
Introduction to Pivot Tables
Creating a Pivot Table
Moving Row Fields
Moving Column Fields
Moving Page Fields

The Pivot Table Toolbar

Refreshing Pivot Table Data

Pivot Table Formatting
Formatting Row & Column Fields
Formatting the Data

Manipulating the Pivot Table Fields
Subtotal Calculations
Hiding Fields
Hiding Items
Sorting
View top N Values

Grouping, Collapsing and Expanding Row & Column Detail		 Generating Page field Sheets

Using Drill Down to get Detail

Pivot Table Options
Adding or removing grand total fields
Refresh Options
Preserving Formatting

Connecting to External Data Sources
Connecting to MS Access as a data source
Connecting to SQL, Oracle or ODBC databases
Other Excel files using ODBC

Using Pivot Table data Outside the Pivot Table

Creating Calculated Field in the Pivot Table

Creating Pivot Charts
Prerequisites:  Excel Level Two or equivalent experience.
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600