Excel PivotTables: from Zero to Expert in half an hour + Dashboards! Part 1

Hello everyone! In this video I'm going to convince you that pivot tables are an extremely handy tool that everyone should be able to use. I guarantee that after watching this video, you will have the most important knowledge and skills that will allow even an absolute beginner to create awesome pivot tables.

Here is the file from the video, so that you can practice creating your first pivot table while watching the video:
https://docs.google.com/spreadsheets/...

And here are the timestamps so you can easily jump to the right part of the video later:
0:00 - Intro
0:55 - Practice file
1:52 - Why Do We Need PivotTables?
4:36 - Let’s Create Our First PivotTable
5:55 - Data Tables as Data Source for PivotTables
11:44 - How to Structure PivotTables
14:24 - PivotTable Formatting
19:41 - PivotTable Layout and Style
23:36 - Conditional Formatting
26:37 - How To Sort PivotTables
28:33 - How To Filter Values in PivotTables
32:39 - PivotTable Calculation Types
36:23 - PivotTable Slicers
37:22 - Working with Dates in PivotTables
38:28 - Refreshing PivotTables

• #
• #excel
• #pivottable
• #pivot_table
• #dashboard
• #slicers
• #calculation_types
• #tutorial
• #for_beginners
• #for_advanced