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/d/13DOBw6Zi-qP4SMx_FeXAdtKU17Xcdrej/edit?usp=sharing&ouid=104968505004400136199&rtpof=true&sd=true 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
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/d/13DOBw6Zi-qP4SMx_FeXAdtKU17Xcdrej/edit?usp=sharing&ouid=104968505004400136199&rtpof=true&sd=true 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