What you’ll learn
Learn how to create Pivot Tables in Microsoft Excel
Create PivotCharts to let your data speak
Get to know many tips & tricks around Pivot Tables
Create a reporting dashboard to perform data analysis
Test your skills by analyzing a data set and answering several questions (including solution guide)
Performing data cleanups
“Introduction
What to expect from this course
Download Course Summary
What is a pivot table?
“My first Pivot Table
Introduction: My first Pivot Table
Download work file
Data Requirements
Data Cleanup
Create Pivot Table
First simple analyses
Perform Analyses
Basic Formatting
Download edited work file
“Menus and Options of a Pivot Table
Find your way
Download work file
The PivotTable Anaylze Tab
The Design Tab
Grouping Data
Slicers and Timelines
Create PivotCharts
Customize Field List View
Context Menu
Show Values As
PivotTable Options
Download edited work file
“Calculated Fields and Items
Understanding Fields and items
Download work file
Calculated Fields
Calculated Items
Pitfalls
Download edited work file
“Dashboards with Pivot Tables
What is a dashboard?
Download work file
Define Requirements
Implement Requirements
Insert Slicers
Finetuning
Working with the Dashboard
Download finished dashboard
“Pivot Table Excercise
Test your skills
Download Excercise file
Solution Guide
What’s your result?
“Tips and Tricks
Manage Raw data
Download work file
Recommended Pivot Tables
Double Click on Cell values
Advanced Filtering
Timelines
Data Clean-up: Converting Text
Conditional Formatting
Manage Calculated Fields and Items
Optimize File Size
Create independent PivotTables
Automatic Date Grouping
Download edited work file
Thank You!