Excel PivotTables Part 1: PivotTables 101

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
44 Lessons (3h 3m)
    • 1. Class Materials and Outline

      3:26
    • 2. Getting to Know the IMBD Dataset

      2:21
    • 3. Setting Expectations

      1:14
    • 4. Why Pivot Tables?

      4:10
    • 5. Structuring Your Source Data

      2:00
    • 6. Inserting Your First Pivot Table

      3:13
    • 7. Navigating the Field List

      7:43
    • 8. Pivot Table Options: Analyze and Design

      1:33
    • 9. Selecting, Clearing, Moving & Copying Pivots

      5:14
    • 10. Refreshing & Updating Pivots

      7:30
    • 11. PRO TIP: Dealing with Growing Source Data

      6:49
    • 12. How Pivot Tables Actually Work

      3:39
    • 13. Number Formatting

      2:12
    • 14. PRO TIP: Automatically Formatting Empty Cells

      1:41
    • 15. Table Layouts & Styles

      5:30
    • 16. PRO TIP: Using Tabular Tables to Create New Source Data

      2:20
    • 17. Customizing Headers & Labels

      1:16
    • 18. Conditional Formatting

      6:51
    • 19. PRO TIP: Data Bars with Invisible Text

      2:13
    • 20. Sorting Options

      5:01
    • 21. PRO TIP: Why is my Alphabetical Sorting Wrong?

      2:01
    • 22. Label Filters & Manual Selections

      8:15
    • 23. PRO TIP: Using Label Filters with Wildcards

      3:15
    • 24. Value Filters

      3:10
    • 25. PRO Tip: Enabling Multiple Filters

      2:42
    • 26. Grouping Data

      3:23
    • 27. PRO TIP: Automatic Date Grouping

      4:25
    • 28. Using Slicers & Timelines to Filter Data

      4:51
    • 29. Breaking Out Report Filter Pages

      4:13
    • 30. "Summarize Values By" Options

      4:45
    • 31. PRO TIP: Avoiding the "Count Of" Trap

      3:49
    • 32. "Show Value As" Calculations

      3:35
    • 33. Show Values As: % of Column/Row

      3:47
    • 34. Show Values As: % of Parent

      3:02
    • 35. Show Values As: Difference From

      4:42
    • 36. Show Values As: Running Total

      2:44
    • 37. Show Values As: Rank

      2:36
    • 38. Show Values As: Index

      8:06
    • 39. Inserting Calculated Fields

      6:30
    • 40. Calculations in Pivots vs. Raw Data

      4:32
    • 41. PRO TIP: Calculating Using Counts

      7:20
    • 42. PRO TIP: Calculating Using Counts (part 2)

      4:19
    • 43. Inserting a Calculated Item (not recommended!)

      6:11
    • 44. The Solve Order & List Formulas Tools

      4:54
45 students are watching this class
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!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

26 of 26 students recommend this class