excelisfun | DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks. @excelisfun | Uploaded 4 months ago | Updated 1 day ago
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/Video03Files.zip Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/03-DAMEMPT.pdf
Alternative link for zipped folder: https://excelisfun.net/files/Video03Files.zip
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
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/Video03Files.zip Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/03-DAMEMPT.pdf
Alternative link for zipped folder: https://excelisfun.net/files/Video03Files.zip
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
