Excel Pivot Tables

1.Introduction to Excel Pivot Tables
Introduction 
Creating a PivotTable
Exploring Data with PivotTable
Updating a PivotTable
PivotTable Reports

2.Pivot Tables - Creation
Using PivotTables to answer questions
To create a PivotTable
Pivoting data
Adding Fields to the PivotTable

3.Fields
PivotTable Fields Task Pane
PivotTable Fields

4.Areas
ROWS
COLUMNS
VALUES
FILTERS

5.Sorting Data
Sorting on Fields
Sorting on Subtotals
More Sort Options
Sorting Data Manually

6.Filtering Data
Filtering using Slicers.
Filtering using Report Filters.
Filtering data manually.
Filtering using Label Filters.
Filtering using Value Filters.
Filtering using Date Filters.
Filtering using Top 10 Filter.
Filtering using Timeline.

7.Pivot Chart in Excel
Limitations of Pivot Charts
Insert Pivot Chart
Filter Pivot Chart
Change the Pivot Chart Type in Microsoft Excel

1.Introduction to Excel Pivot Tables
Introduction 
Creating a PivotTable
Exploring Data with PivotTable
Updating a PivotTable
PivotTable Reports

2.Pivot Tables - Creation
Using PivotTables to answer questions
To create a PivotTable
Pivoting data
Adding Fields to the PivotTable

3.Fields
PivotTable Fields Task Pane
PivotTable Fields

4.Areas
ROWS
COLUMNS
VALUES
FILTERS

5.Sorting Data
Sorting on Fields
Sorting on Subtotals
More Sort Options
Sorting Data Manually

6.Filtering Data
Filtering using Slicers.
Filtering using Report Filters.
Filtering data manually.
Filtering using Label Filters.
Filtering using Value Filters.
Filtering using Date Filters.
Filtering using Top 10 Filter.
Filtering using Timeline.

7.Pivot Chart in Excel
Limitations of Pivot Charts
Insert Pivot Chart
Filter Pivot Chart
Change the Pivot Chart Type in Microsoft Excel