Ultimate Excel Course #11 - Master PivotTables for Powerful Analysis and Reporting

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
14 Lessons (1h 8m)
    • 1. Introduction

      3:20
    • 2. Creating a PivotTable

      8:09
    • 3. Changing the Values Function

      3:19
    • 4. Formatting Values the Efficient Way

      2:19
    • 5. Creating a PivotTable Style

      5:10
    • 6. Sorting PivotTable Fields

      2:36
    • 7. Grouping Data in a PivotTable

      4:55
    • 8. Show Values as Percentage, Difference and Ranking

      5:10
    • 9. Conditional Formatting with PivotTables

      3:41
    • 10. Filtering PivotTable Data

      3:59
    • 11. Refreshing a PivotTable

      4:48
    • 12. Creating a PivotChart

      5:22
    • 13. Using Slicers for Interactive PivotTables

      11:55
    • 14. Using the Timeline Slicer

      2:54