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