PivotTables for Quick and Easy Reports - 34 Advanced Techniques

Dive into a comprehensive 44-minute video tutorial on mastering PivotTables for quick and easy report creation in Excel. Learn 34 amazing PivotTable tricks from Excel MVP and Highline College Professor Mike Girvin. Explore topics ranging from basic PivotTable concepts to advanced techniques like handling large datasets, creating custom styles, and utilizing Show Values As calculations. Discover how to efficiently summarize data, create cross-tabulated reports, and leverage PowerQuery for data transformation. Download accompanying files and access PDF notes to enhance your learning experience. By the end of this tutorial, gain the skills to manipulate millions of rows of data and generate multiple reports with a single click, revolutionizing your data analysis capabilities in Excel.

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