Microsoft Excel 2007/2010 Pivot Table Workshop – Level 3 / Advanced

$250

Prerequisites

Previous experience with Office 2007 or 2010 and Intermediate Excel skills.

Pivoting Data

a. Getting Started with PivotTables 
What is a PivotTable?
Creating a PivotTable
Using the PivotTable Tools Tabs
Adding and Removing Data with the Field List
Changing the Field List Layout
Pivoting Data
Step-By-Step
Skill Sharpener

b. Working with PivotTable Data 
Expanding and Collapsing Data
Filtering Data
Sorting Data
Grouping Data
Refreshing Data
Editing the Data Source
Step-By-Step
Skill Sharpener

c. Formatting a PivotTable 
Modifying Fields and Labels
Modifying Values
Using the Layout Group on the Design Tab
Applying a Style to a PivotTable
Changing PivotTable Style Options
Manually Formatting a PivotTable
Using the PivotTable Options Dialog
Step-By-Step
Skill Sharpener

d. Using the Classic PivotTable Layout 
Creating an Empty (Classic) PivotTable Frame
Switching an Existing PivotTable to a Classic Layout
Adding Data
Pivoting Data
Step-By-Step
Skill Sharpener

Advanced PivotTable Tasks 

a. Creating a PivotTable Based on External Data 
Refreshing External Data
Creating a Slicer
Using the Slicer Tools Tab
Step-By-Step
Skill Sharpener

b. Using PowerPivot 
System Requirements
Downloading and Installing PowerPivot
Importing Access Data
Importing Excel Data
Integrating Data with Relationships
Creating a PivotTable with PowerPivot Data
Step-By-Step
Skill Sharpener
Session 1 - Case Study
Session 2 - Review Questions

c. Charting Pivoted Data 
Getting Started with PivotCharts
Creating a PivotChart from Scratch
Creating a PivotChart from Existing Data
Adding Data to your Chart
Pivoting Data
Step-By-Step
Skill Sharpener

d. Using the PivotChart Tools Tabs 
Using the Design Tab
Using the Layout Tab
Using the Format Tab
Using the Analyze Tab
Step-By-Step
Skill Sharpener

e. Formatting a PivotChart 
Renaming Fields
Changing the Chart Type
Applying a Chart Style
Manually Formatting Chart Elements
Changing the Layout of Chart Elements
Step-By-Step
Skill Sharpener

f. Advanced PivotChart Tasks 
Creating a PivotChart Based on External Data
Creating a Slicer
Creating a PivotTable and PivotChart from a Scenario
Creating PivotCharts with PowerPivot Data
Step-By-Step
Skill Sharpener
Session 3 - Case Study
Session 4 - Review Questions

Additional Tools for Managing Large Amounts of Data

a. Getting the Most from Your Data
Outlining and Grouping Data
Using Automatic Outlining
Displaying and Collapsing Levels
Grouping Data Manually
Creating Subtotals
Step-By-Step
Skill Sharpener

Please note that certain topics may apply to Excel 2010 only.