Ultimate Pivot Tables (Non Downloadable)
Master Pivot Tables in just 2 hours!
Course curriculum
-
1
-
Introduction To The Course
FREE PREVIEW -
Workbook for Module 1
FREE PREVIEW -
1. Introduction to Pivot Tables
FREE PREVIEW -
2. Pivot Cache
FREE PREVIEW -
3. Altering the Data Source
FREE PREVIEW -
4. Unpivot Data To A Long Boring List
FREE PREVIEW -
5. Moving Row And Column
-
6. Expand And Collapse Field
-
-
2
-
Workbook for Module 2
-
7. Format Error and Empty cells
FREE PREVIEW -
8. Change The Layout Of Your Pivot Table
FREE PREVIEW -
9. Place Pivot Table
-
10. Pivot Table Styles
-
11. Format Content In Pivot
-
-
3
-
Module 3 Workbook
-
12. Summarise Value By
FREE PREVIEW -
13. Multiple Subtotal
FREE PREVIEW -
14. Percentage Of Column Total
FREE PREVIEW -
15. Difference From Value As Percentage
-
16. Double Click For Detail
-
17. Running Total
-
18. Grouping Year Month Quarter
-
19. Sorting
-
-
4
-
Workbook for Module 4
-
20. Filtering - Part 1
FREE PREVIEW -
21. Filtering - Part 2
-
22. Slicer - Insert Style Property
-
23. One Slicer Connected To Multiple Pivots
-
24. Timeline Slicer
-
-
5
-
Workbook for Module 5
-
25. Calculated Field
FREE PREVIEW -
26. Link Multiple Tables Into One Pivot - Part 1
-
27. Link Multiple Tables Into One Pivot - Part 2 2
-
28. Calculated Field With IF Statement
-
-
6
-
Module 6 Workbook
-
29. Conditional Formatting In Pivot - Part 1
FREE PREVIEW -
30. Conditional Formatting In Pivot - Part 2
-
31. Pivotcharts Part 1
-
32. Pivotcharts Part 2 - Linking And Slicers
-
33. Pivotcharts Part 3 - Formatting
-
34. Dashboard 1 - What We Will Build
-
35. Dashboard 2 - Our Dataset
-
36. Dashboard 3 - Pie Chart
-
37. Dashboard 4 - Line Chart
-
38. Dashboard 5 - Bar Chart
-
39. Dashboard 6 - Map Chart
-
40. Dashboard 7 - Putting It All Together
-
Outro
-