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