Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.

Posted on by Annie D

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
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 the beauty and simplicity of PowerQuery yo get, transform, abd load the data to the location that you want/.

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 inti 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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunFri, April 26, 2024 2:10am