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
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!