Pivot Tables Crash Course

Hi, welcome to our new crash course on pivot table. In this video we will learn about pivot tables from basic to advance. We will cover following topics:

Pivot table fundamentals.
Slicers and Timelines
Filters and sorting
Customizing pivot tables
Layout setting
Calculated fields and calculated items
Grouping data
Pivot charts
Dashboards with pivot tables

Timestamps:

00:00 - Intro
01:10 - Why use pivot tables
02:15 - Pivot Table fundamentals
05:40 - Filters and Slicers
07:30 - Connecting and disconnecting slicers
11:49 - Timelines
12:27 - Data source changes
14:50 - Customizing pivot tables
20:57 - Summarizing data
25:20 - Data Grouping
30:00 - Calculated Fields and calculated Items
35:30 - Pivot Charts
36:45 - Dashboard with pivot table
39:46 - Outro

Instagram:   / skillnator0  
Excel Dashboard in 5 simple steps:    • Create interactive excel dashboard in...  

#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros #pivotchart #pivottable #excelcourse #exceltutorial #masterpivottable