Course curriculum

  1. 1

    • Introduction To The Course

    • Workbook for Module 1

    • 1. Introduction to Pivot Tables

    • 2. Pivot Cache

    • 3. Altering the Data Source

    • 4. Unpivot Data To A Long Boring List

    • 5. Moving Row And Column

    • 6. Expand And Collapse Field
  2. 2

    • Workbook for Module 2

    • 7. Format Error and Empty cells

    • 8. Change The Layout Of Your Pivot Table

    • 9. Place Pivot Table

    • 10. Pivot Table Styles

    • 11. Format Content In Pivot
  3. 3

    • Module 3 Workbook

    • 12. Summarise Value By

    • 13. Multiple Subtotal

    • 14. Percentage Of Column Total

    • 15. Difference From Value As Percentage

    • 16. Double Click For Detail

    • 17. Running Total

    • 18. Grouping Year Month Quarter

    • 19. Sorting
  4. 4

    • Workbook for Module 4

    • 20. Filtering - Part 1

    • 21. Filtering - Part 2

    • 22. Slicer - Insert Style Property

    • 23. One Slicer Connected To Multiple Pivots

    • 24. Timeline Slicer
  5. 5

    • Workbook for Module 5

    • 25. Calculated Field

    • 26. Link Multiple Tables Into One Pivot - Part 1

    • 27. Link Multiple Tables Into One Pivot - Part 2

    • 28. Calculated Field With IF Statement
  6. 6

    • Module 6 Workbook

    • 29. Conditional Formatting In Pivot - Part 1

    • 30. Conditional Formatting In Pivot - Part 2

    • 31. Pivotcharts Part 1

    • 32. Pivotcharts Part 2 - Linking And Slicers

    • 33. Pivotcharts Part 3 - Formatting

    • 34. Dashboard 1 - What We Will Build

    • 35. Dashboard 2 - Our Dataset

    • 36. Dashboard 3 - Pie Chart

    • 37. Dashboard 4 - Line Chart

    • 38. Dashboard 5 - Bar Chart

    • 39. Dashboard 6 - Map Chart

    • 40. Dashboard 7 - Putting It All Together

    • Outro