Excel PivotTables Part 1: PivotTables 101 | Chris Dutton | Skillshare

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
46 students are watching this class

Project Description

Download the attached files, and use them to follow along throughout the course!

  • IMDb Movie Database (Excel file used for demos throughout the course)
  • 2016_Movies (Excel file used for Lecture #12)
  • Excel_PivotTable_Slides (helpful PDF reference guides to keep on hand)
  • Pivot Homework Exercises (Part 1) (bonus homework activities)

Student Projects