Download files: https://people.highline.edu/mgirvin/A... Pdf notes to read online: https://people.highline.edu/mgirvin/A...
Alternative link for zipped folder: https://excelisfun.net/files/Video03F...
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.

This video teaches you all the tricks for a PivotTable. It shows examples of when the PivotTable is the best tool as compared to worksheet formulas, Power Query, Power Pivot and Power BI..

Topics:
1. (00:00) Introduction
2. (00:26) Free PivotTable Cheat Sheet in workbook file or pdf notes
3. (00:39) Toy sales Data Set
4. (01:21) Why use PivotTables?
5. (01:58) Basics of PivotTables
6. (02:35) PivotTable Cache
7. (04:02) Change Default PivotTable Layout
8. (04:40) PT Calculations: Summarize Values By, Show Values As and Calculated Fields
9. (05:53) Cross Tabulated Tables and the AND Logical Test
10. (06:23) What a Filter or Sliver does to PT calculations
11. (07:45) Name PivotTable
12. (09:00) Connect 2 PT to 1 Slicer
13. (09:15) Calculated Field
14. (11:07) Sort PT by Values
15. (11:30) Extract records from a PT cell
16. (12:06) Create PivotTable Styles
17. (13:37) What happens if you copy a PT?
18. (14:45) Group By Inconsistent Data Error
19. (15:38) Fix Text Dates with Hack in worksheet
20. (17:07) Group By Feature for 1) Integers Numbers or 2) Decimal Numbers
21. (20:56) Grouping persists in the PivotTable Cache
22. (21:27) Create New Grouping in new PivotTable Cache using 3-step PivotTable Wizard
23. (23:21) Modify PivotTable Styles
24. (23:42) Show Values As Calculations: % of Column Total, % of Parent Total, % of Row Parent Total
25. (26:05) Show Values As Calculations: Difference From and % Difference From
26. (27:18) Show Values As Calculations: Running Total, % Running Total
27. (29:00) Summarize Survey Data
28. (29:41) Create Cross Tabulated Report and Visual
29. (31:20) Create and Use a Joint Probability Table
30. (34:42) Load 7 million rows of data to PivotTable Cache to make simple Pivot Report
31. (37:01) Append csv files into PivotTable Cache using From Folder and the C
32. (42:22) Create 5 reports with a single click: Show Report Filter Pages feature
33. (43:17) Summary
34. (44:11) Conclusion