Introduction

 

 Introduction to Pivot Tables

 

 Introduction to the Course

 

 Training Data

 

 Correctly Structure Data

 

 Using Tables as a Data Source

 

Creating Excel Pivot Tables

 

 Introduction to Creating your First Pivot Table

 

 Create a Pivot Table

 

 Create PivotTable with More Than One Dimension

 

 More than One Measure

 

 Change Number Formats

 

 Changing the Custom Number Format

 

 Change Region and Language

 

Pivot Table Menu Options

 

 Introduction to Pivot Table Menu Options

 

 Pivot Table Menu Options

 

 Pivot Table Design

 

Changing the Method of Aggregation

 

 Changing the Method of Aggregation

 

 Method of Aggregation

 

 Sorting Data in a Pivot Table

 

Trend – Time Analysis with Pivot Tables

 

 Introduction to Time Analysis

 

 Time Analysis with Pivot Tables

 

 Create Management Reports

 

 Custom Time Formulas

 

 Using Sparklines to Analyse trends

 

Filtering Pivot Tables

 

 Introduction to Filtering Data

 

 Filter Text Fields

 

 Top  Analysis

 

 Using the Report Filter

 

 Using Slicers to Filter Data

 

 Using Slicers to Filter Multiple Pivot Tables

 

Show Value As Calculations

 

 The Show Value As Calculations

 

 Percentage Calculation

 

 Show Value As Percentage of Parent Row Total

 

 Difference From and Ranking

 

 Pareto Analysis

 

 Percentage of Calculation

 

Frequency Analysis

 

 Introduction to Frequency Analysis

 

 Employee Master

 

 Frequency Analysis

 

Custom Calculations

 

 Creating Custom Calculations

 

 Create a Custom Calculation

 

 Conclusion