Course content

8 sections • 90 lectures • 6h 51m total length

Collapse all sections

Getting Started5 lectures • 10min

• Course Structure & Outline

 Important Notes for New Students

• Getting to Know the IMDb Movie Database

Setting Expectations

Excel Pivot Table 10113 lectures • 50min

• Why Pivot Tables?

04:10

• Structuring Source Data for Analysis in Excel

02:00

• Creating Your First Pivot Table

03:13

• IMPORTANT: Add to Data Model

00:29

• Navigating the Pivot Table Field List

07:43

• KNOWLEDGE CHECK: Manipulating the Pivot Table Field List

00:28

• Exploring Pivot Table Analyze & Design Options

01:33

• Selecting, Clearing, Moving & Copying Pivot Tables

05:14

• Refreshing & Updating Pivot Tables

07:30

• PRO TIP: Dealing with Growing Source Data

06:49

• Removing & Reviving Data from the Pivot Table Cache

PRO TIP: How Excel Pivot Tables ACTUALLY Work

03:39

• QUIZ: Excel Pivot Table 101

5 questions

• HOMEWORK: Excel Pivot Table 101

01:08

Formatting Data with Pivot Tables9 lectures • 30min

• Changing Pivot Table Number Formats

02:12

• PRO TIP: Formatting Empty Pivot Table Cells

01:41

• Configuring Pivot Table Layouts & Styles

05:30

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

02:20

• Customizing Pivot Table Headers & Labels

01:16

• Applying Basic Conditional Formats to Pivot Tables

06:51

• PRO TIP: Adding Data Bars with Invisible Text

02:13

• Applying Advanced Conditional Formats to Pivot Tables

• QUIZ: Excel Pivot Table Formatting

4 questions

• HOMEWORK: Excel Pivot Table Formatting

00:51

Sorting, Filtering & Grouping Data with Pivot Tables11 lectures • 42min

• Sorting Data with Pivot Tables

05:01

• PRO TIP: Fixing Incorrect Alphabetical Sorting

02:01

• Filtering Data with Pivot Table Label & Selection Filters

08:15

• PRO TIP: Pivot Table Label Filters with Wildcards

03:15

• Filtering Data with Pivot Table Value Filters

03:10

• PRO TIP: Enabling Multiple Pivot Table Filters

Grouping & Segmenting Data with Pivot Tables

03:23

• PRO TIP: Enabling & Disabling Automatic Date Grouping

04:25

• Filtering Data with Pivot Table Slicers & Timelines

04:51

• Breaking Out Pivot Table Report Filter Pages

04:13

• QUIZ: Sorting, Filtering & Grouping Data with Excel Pivot Tables

6 questions

• HOMEWORK: Sorting, Filtering & Grouping Data with Excel Pivot Tables

00:56

Enriching Data with Pivot Table Calculated Values & Fields17 lectures • 1hr 13min

• Aggregating & Summarizing Data with Pivot Tables

04:45

• PRO TIP: Avoiding the Pivot Table “Count Of” Trap

03:49

• Defining Value Calculations with Pivot Tables

03:35

• Calculating Pivot Table Values: % of Column/Row

03:47

• Calculating Pivot Table Values: % of Parent

03:02

• Calculating Pivot Table Values: Difference From

04:42

• Calculating Pivot Table Values: Running Total

02:44

• Calculating Pivot Table Values: Rank

02:36

• Calculating Pivot Table Values: Index

08:06

• KNOWLEDGE CHECK: Pivot Table Value Calculations

00:20

• Defining Calculated Fields with Pivot Tables

06:30

• Creating Calculated Fields in Pivot Tables vs. Source Data

04:32

• PRO TIP: Pivot Table Calculations Using Count Columns (Part 1)

07:20

• PRO TIP: Pivot Table Calculations Using Count Columns (Part 2)

04:19

• Inserting Pivot Table Calculated Items (USE WITH CAUTION!)

06:11

• Generating Solve Order & List Formulas Reports

04:54

• QUIZ: Enriching Data with Pivot Table Calculated Values & Fields

7 questions

• HOMEWORK: Enriching Data with Pivot Table Calculated Values & Fields

01:19

Visualizing Data with Excel Pivot Charts12 lectures • 55min

• Intro to Excel Pivot Charts

02:26

• Pivot Chart Demo: Column Chart

04:13

• Pivot Chart Demo: Pie & Donut Charts

05:46

• Pivot Chart Demo: Clustered Bar Chart

03:25

• PRO TIP: Preventing Charts from Resizing with Cells

04:45

• Changing Pivot Chart Types

03:18

• Pivot Chart Demo: Stacked Area Chart

05:46

• Customizing Pivot Chart Layouts & Styles

04:03

• Moving Pivot Charts to New Excel Worksheets

02:09

• Applying Slicers & Timelines to Multiple Pivot Charts

05:01

Building Dynamic Dashboards with Pivot Tables & Pivot Charts

QUIZ: Visualizing Data with Excel Pivot Charts

6 questions

• HOMEWORK: Visualizing Data with Excel Pivot Charts

01:05

Excel Pivot Table Case Studies22 lectures • 2hr 31min

• Setting Expectations

01:45

• DOWNLOAD: Case Study Resources

00:10

• Pivot Table Demo: Analyzing U.S. Voter Demographics

10:33

• HOMEWORK: Analyzing U.S. Voter Demographics

00:43

• Pivot Table Demo: Analyzing San Francisco Salary Data

13:06

• HOMEWORK: Analyzing San Francisco Salary Data

00:40

• Pivot Table Demo: Exploring Shark Attack Records

10:31

• HOMEWORK: Exploring Shark Attack Records

00:54

Pivot Table Demo: Analyzing Stock Market Data

HOMEWORK: Analyzing Stock Market Data

00:34

• Pivot Table Demo: Analyzing Major League Baseball Teams

14:16

• HOMEWORK: Analyzing Major League Baseball Teams

00:55

• Pivot Table Demo: Exploring San Diego Burrito Ratings

16:40

• HOMEWORK: Exploring San Diego Burrito Ratings

00:43

• Pivot Table Demo: Tracking Daily Weather Conditions

12:41

• HOMEWORK: Tracking Daily Weather Conditions

00:40

• Pivot Table Demo: Analyzing Spartan Race Facebook Posts

14:37

• HOMEWORK: Analyzing Spartan Race Facebook Posts

00:39

• Pivot Table Demo: Analyzing Apple App Store Data

18:39

• HOMEWORK: Analyzing Apple App Store Data

01:17

Pivot Table Demo: Analyzing Wine Tasting Scores

HOMEWORK: Analyzing Wine Tasting Scores

01:02