Morning

Pivot Tables

Creating a Pivot Table from scratch

Using the Field List

Choosing what Data to Display and Hide

Creating Totals and Subtotals

Creating Averages, Counts, etc.

Pivot Table Formulas

Refreshing Data

Changing the Layout of a Pivot Table

Rearranging Fields

Move a Pivot Table

Creating Groups

Formatting a Pivot Table

Using AutoFormat

Selecting Elements within a Pivot Table

Field Options

Pivot Table Options

Basic Pivot Table Formatting

Selecting Shortcuts

Pivot Table Styles

Creating Groups

Creating Groups Based on Dates

Collapse & Expand Fields

Calculations

Creating Totals and Subtotals

Creating Averages, Counts, etc.

Creating Calculated Fields

Creating Calculated Items

Pivot Table Summaries

Creating Drill-Downs

Show Report Filter Pages

Filtering Pivot Table Fields

Pivot Table Slicers (2010/2013)

Using Slicers

Slicer Connections

Slicer Styles & Other Slicer Settings

Creating Pivot Tables from External Data

Creating Pivot Tables from Multiple Consolidation Ranges

Creating Pivot Tables from Other Pivot Tables

Creating Pivot Charts

Working with Pivot Charts

Formatting Pivot Charts

Afternoon

Advanced Filter

Setting Up the Ranges

Setting Up the Criteria Range

Performing the Filter
Copy Unique Records to Another Location

Creating Database Functions

Using DSUM, DAVERAGE, DCOUNT, etc.

Creating Criteria Ranges

Editing Criteria to Change Formula Results

Using Range Names in Database Functions

Grouping Rows/Columns on a Sheet

Showing/Hiding Details in an Outline

Display/Hide Outline Symbols

Using Subtotals

Adding Automatic Subtotals

Adding Other Automatic Analysis (Average, Count, etc)

Removing Subtotals