Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Introduction to Pivot Tables in Excel

Chris Dutton, Founder, Excel Maven

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

      3:26
    • Getting to Know the IMBD Dataset

      2:21
    • Setting Expectations

      1:14
    • Why Pivot Tables?

      4:10
    • Structuring Your Source Data

      2:00
    • Inserting Your First Pivot Table

      3:13
    • Navigating the Field List

      7:43
    • Pivot Table Options: Analyze and Design

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

      5:14
    • Refreshing & Updating Pivots

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

      6:49
    • How Pivot Tables Actually Work

      3:39
    • Number Formatting

      2:12
    • PRO TIP: Automatically Formatting Empty Cells

      1:41
    • Table Layouts & Styles

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

      2:20
    • Customizing Headers & Labels

      1:16
    • Conditional Formatting

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

      2:13
    • Sorting Options

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

      2:01
    • Label Filters & Manual Selections

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

      3:15
    • Value Filters

      3:10
    • PRO Tip: Enabling Multiple Filters

      2:42
    • Grouping Data

      3:23
    • PRO TIP: Automatic Date Grouping

      4:25
    • Using Slicers & Timelines to Filter Data

      4:51
    • Breaking Out Report Filter Pages

      4:13
    • "Summarize Values By" Options

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

      3:49
    • "Show Value As" Calculations

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

      3:47
    • Show Values As: % of Parent

      3:02
    • Show Values As: Difference From

      4:42
    • Show Values As: Running Total

      2:44
    • Show Values As: Rank

      2:36
    • Show Values As: Index

      8:06
    • Inserting Calculated Fields

      6:30
    • Calculations in Pivots vs. Raw Data

      4:32
    • PRO TIP: Calculating Using Counts

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

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

      6:11
    • The Solve Order & List Formulas Tools

      4:54