Getting Started
  • Course Structure & Outline
  • READ ME: Important Notes for New Students
  • DOWNLOAD: Course Resources
  • Getting to Know the IMDb Movie Database
  • Setting Expectations
Excel Pivot Table 101
  • Why Pivot Tables?
  • Structuring Source Data for Analysis in Excel
  • Creating Your First Pivot Table
  • IMPORTANT: Add to Data Model
  • Navigating the Pivot Table Field List
  • KNOWLEDGE CHECK: Manipulating the Pivot Table Field List
  • Exploring Pivot Table Analyze & Design Options
  • Selecting, Clearing, Moving & Copying Pivot Tables
  • Refreshing & Updating Pivot Tables
  • PRO TIP: Dealing with Growing Source Data
  • Removing & Reviving Data from the Pivot Table Cache
  • PRO TIP: How Excel Pivot Tables ACTUALLY Work
  • QUIZ: Excel Pivot Table 101
  • HOMEWORK: Excel Pivot Table 101
Formatting Data with Pivot Tables
  • Changing Pivot Table Number Formats
  • PRO TIP: Formatting Empty Pivot Table Cells
  • Configuring Pivot Table Layouts & Styles
  • PRO TIP: Using Tabular Pivot Tables to Create New Source Data
  • Customizing Pivot Table Headers & Labels
  • Applying Basic Conditional Formats to Pivot Tables
  • PRO TIP: Adding Data Bars with Invisible Text
  • Applying Advanced Conditional Formats to Pivot Tables
  • QUIZ: Excel Pivot Table Formatting
  • HOMEWORK: Excel Pivot Table Formatting
Sorting, Filtering & Grouping Data with Pivot Tables
  • Sorting Data with Pivot Tables
  • PRO TIP: Fixing Incorrect Alphabetical Sorting
  • Filtering Data with Pivot Table Label & Selection Filters
  • PRO TIP: Pivot Table Label Filters with Wildcards
  • Filtering Data with Pivot Table Value Filters
  • PRO TIP: Enabling Multiple Pivot Table Filters
  • Grouping & Segmenting Data with Pivot Tables
  • PRO TIP: Enabling & Disabling Automatic Date Grouping
  • Filtering Data with Pivot Table Slicers & Timelines
  • Breaking Out Pivot Table Report Filter Pages
  • QUIZ: Sorting, Filtering & Grouping Data with Excel Pivot Tables
  • HOMEWORK: Sorting, Filtering & Grouping Data with Excel Pivot Tables
Enriching Data with Pivot Table Calculated Values & Fields
  • Aggregating & Summarizing Data with Pivot Tables
  • PRO TIP: Avoiding the Pivot Table "Count Of" Trap
  • Defining Value Calculations with Pivot Tables
  • Calculating Pivot Table Values: % of Column/Row
  • Calculating Pivot Table Values: % of Parent
  • Calculating Pivot Table Values: Difference From
  • Calculating Pivot Table Values: Running Total
  • Calculating Pivot Table Values: Rank
  • Calculating Pivot Table Values: Index
  • KNOWLEDGE CHECK: Pivot Table Value Calculations
  • Defining Calculated Fields with Pivot Tables
  • Creating Calculated Fields in Pivot Tables vs. Source Data
  • PRO TIP: Pivot Table Calculations Using Count Columns (Part 1)
  • PRO TIP: Pivot Table Calculations Using Count Columns (Part 2)
  • Inserting Pivot Table Calculated Items (USE WITH CAUTION!)
  • Generating Solve Order & List Formulas Reports
  • QUIZ: Enriching Data with Pivot Table Calculated Values & Fields
  • HOMEWORK: Enriching Data with Pivot Table Calculated Values & Fields
Visualizing Data with Excel Pivot Charts
  • Intro to Excel Pivot Charts
  • Pivot Chart Demo: Column Chart
  • Pivot Chart Demo: Pie & Donut Charts
  • Pivot Chart Demo: Clustered Bar Chart
  • PRO TIP: Preventing Charts from Resizing with Cells
  • Changing Pivot Chart Types
  • Pivot Chart Demo: Stacked Area Chart
  • Customizing Pivot Chart Layouts & Styles
  • Moving Pivot Charts to New Excel Worksheets
  • Applying Slicers & Timelines to Multiple Pivot Charts
  • Building Dynamic Dashboards with Pivot Tables & Pivot Charts
  • QUIZ: Visualizing Data with Excel Pivot Charts
  • HOMEWORK: Visualizing Data with Excel Pivot Charts
Excel Pivot Table Case Studies
  • Setting Expectations
  • DOWNLOAD: Case Study Resources
  • Pivot Table Demo: Analyzing U.S. Voter Demographics
  • HOMEWORK: Analyzing U.S. Voter Demographics
  • Pivot Table Demo: Analyzing San Francisco Salary Data
  • HOMEWORK: Analyzing San Francisco Salary Data
  • Pivot Table Demo: Exploring Shark Attack Records
  • HOMEWORK: Exploring Shark Attack Records
  • Pivot Table Demo: Analyzing Stock Market Data
  • HOMEWORK: Analyzing Stock Market Data
  • Pivot Table Demo: Analyzing Major League Baseball Teams
  • HOMEWORK: Analyzing Major League Baseball Teams
  • Pivot Table Demo: Exploring San Diego Burrito Ratings
  • HOMEWORK: Exploring San Diego Burrito Ratings
  • Pivot Table Demo: Tracking Daily Weather Conditions
  • HOMEWORK: Tracking Daily Weather Conditions
  • Pivot Table Demo: Analyzing Spartan Race Facebook Posts
  • HOMEWORK: Analyzing Spartan Race Facebook Posts
  • Pivot Table Demo: Analyzing Apple App Store Data
  • HOMEWORK: Analyzing Apple App Store Data
  • Pivot Table Demo: Analyzing Wine Tasting Scores