Section 1 : Getting Started

Lecture 1 Course Structure & Outline 00:03:26 Duration
Lecture 2 About Certification
Lecture 3 DOWNLOAD Course Resources
Lecture 4 Getting to Know the IMDb Movie Database 00:02:21 Duration
Lecture 5 Setting Expectations 00:01:15 Duration

Section 2 : Excel Pivot Table 101

Lecture 1 Why Pivot Tables 00:04:11 Duration
Lecture 2 Structuring Source Data for Analysis in Excel 00:02:01 Duration
Lecture 3 Creating Your First Pivot Table 00:03:13 Duration
Lecture 4 IMPORTANT Add to Data Model
Lecture 5 Navigating the Pivot Table Field List 00:07:44 Duration
Lecture 6 KNOWLEDGE CHECK Manipulating the Pivot Table Field List
Lecture 7 Exploring Pivot Table Analyze & Design Options 00:01:34 Duration
Lecture 8 Selecting, Clearing, Moving & Copying Pivot Tables 00:05:15 Duration
Lecture 9 Refreshing & Updating Pivot Tables 00:07:30 Duration
Lecture 10 PRO TIP Dealing with Growing Source Data 00:06:50 Duration
Lecture 11 Removing & Reviving Data from the Pivot Table Cache 00:05:42 Duration
Lecture 12 PRO TIP How Excel Pivot Tables ACTUALLY Work 00:03:40 Duration
Lecture 13 HOMEWORK Excel Pivot Table 101

Section 3 : Formatting Data with Pivot Tables

Lecture 1 Changing Pivot Table Number Formats
Lecture 2 PRO TIP Formatting Empty Pivot Table Cells 00:01:42 Duration
Lecture 3 Configuring Pivot Table Layouts & Styles 00:05:31 Duration
Lecture 4 PRO TIP Using Tabular Pivot Tables to Create New Source Data 00:02:20 Duration
Lecture 5 Customizing Pivot Table Headers & Labels 00:01:17 Duration
Lecture 6 Applying Basic Conditional Formats to Pivot Tables 00:06:51 Duration
Lecture 7 PRO TIP Adding Data Bars with Invisible Text 00:02:13 Duration
Lecture 8 Applying Advanced Conditional Formats to Pivot Tables 00:06:51 Duration
Lecture 9 HOMEWORK Excel Pivot Table Formatting

Section 4 : Sorting, Filtering & Grouping Data with Pivot Tables

Lecture 1 Sorting Data with Pivot Tables 00:05:02 Duration
Lecture 2 PRO TIP Fixing Incorrect Alphabetical Sorting 00:02:02 Duration
Lecture 3 Filtering Data with Pivot Table Label & Selection Filters
Lecture 4 PRO TIP Pivot Table Label Filters with Wildcards 00:03:15 Duration
Lecture 5 Filtering Data with Pivot Table Value Filters 00:03:10 Duration
Lecture 6 PRO TIP Enabling Multiple Pivot Table Filters 00:02:42 Duration
Lecture 7 Grouping & Segmenting Data with Pivot Tables 00:03:23 Duration
Lecture 8 PRO TIP Enabling & Disabling Automatic Date Grouping 00:04:26 Duration
Lecture 9 Filtering Data with Pivot Table Slicers & Timelines 00:04:52 Duration
Lecture 10 Breaking Out Pivot Table Report Filter Pages 00:04:14 Duration
Lecture 11 HOMEWORK Sorting, Filtering & Grouping Data with Excel Pivot Tables

Section 5 : Enriching Data with Pivot Table Calculated Values & Fields

Lecture 1 Aggregating & Summarizing Data with Pivot Tables 00:04:46 Duration
Lecture 2 PRO TIP Avoiding the Pivot Table Count Of Trap 00:03:50 Duration
Lecture 3 Defining Value Calculations with Pivot Tables 00:03:36 Duration
Lecture 4 Calculating Pivot Table Values % of ColumnRow 00:03:47 Duration
Lecture 5 Calculating Pivot Table Values % of Parent 00:03:03 Duration
Lecture 6 Calculating Pivot Table Values Difference From 00:04:42 Duration
Lecture 7 Calculating Pivot Table Values Running Total 00:02:45 Duration
Lecture 8 Calculating Pivot Table Values Rank 00:02:36 Duration
Lecture 9 Calculating Pivot Table Values Index 00:08:07 Duration
Lecture 10 KNOWLEDGE CHECK Pivot Table Value Calculations
Lecture 11 Defining Calculated Fields with Pivot Tables 00:06:31 Duration
Lecture 12 Creating Calculated Fields in Pivot Tables vs 00:04:32 Duration
Lecture 13 PRO TIP Pivot Table Calculations Using Count Columns (Part 1) 00:07:21 Duration
Lecture 14 PRO TIP Pivot Table Calculations Using Count Columns (Part 2)
Lecture 15 Inserting Pivot Table Calculated Items (USE WITH CAUTION!) 00:06:12 Duration
Lecture 16 Generating Solve Order & List Formulas Reports 00:04:55 Duration
Lecture 17 HOMEWORK Enriching Data with Pivot Table Calculated Values & Fields

Section 6 : Visualizing Data with Excel Pivot Charts

Lecture 1 Intro to Excel Pivot Charts 00:02:27 Duration
Lecture 2 Pivot Chart Demo Column Chart 00:04:14 Duration
Lecture 3 Pivot Chart Demo Pie & Donut Charts 00:05:47 Duration
Lecture 4 Pivot Chart Demo Clustered Bar Chart 00:03:26 Duration
Lecture 5 PRO TIP Preventing Charts from Resizing with Cells 00:04:46 Duration
Lecture 6 Changing Pivot Chart Types 00:03:18 Duration
Lecture 7 Pivot Chart Demo Stacked Area Chart
Lecture 8 Customizing Pivot Chart Layouts & Styles 00:04:03 Duration
Lecture 9 Moving Pivot Charts to New Excel Worksheets 00:02:10 Duration
Lecture 10 Applying Slicers & Timelines to Multiple Pivot Charts 00:05:02 Duration
Lecture 11 Building Dynamic Dashboards with Pivot Tables & Pivot Charts 00:13:23 Duration
Lecture 12 HOMEWORK Visualizing Data with Excel Pivot Charts

Section 7 : Excel Pivot Table Case Studies

Lecture 1 Setting Expectations 00:01:46 Duration
Lecture 2 DOWNLOAD Case Study Resources
Lecture 3 Pivot Table Demo Analyzing U 00:10:33 Duration
Lecture 4 HOMEWORK Analyzing U
Lecture 5 Pivot Table Demo Analyzing San Francisco Salary Data
Lecture 6 HOMEWORK Analyzing San Francisco Salary Data
Lecture 7 Pivot Table Demo Exploring Shark Attack Records 00:10:31 Duration
Lecture 8 HOMEWORK Exploring Shark Attack Records
Lecture 9 Pivot Table Demo Analyzing Stock Market Data 00:12:26 Duration
Lecture 10 HOMEWORK Analyzing Stock Market Data
Lecture 11 Pivot Table Demo Analyzing Major League Baseball Teams 00:14:16 Duration
Lecture 12 HOMEWORK Analyzing Major League Baseball Teams
Lecture 13 Pivot Table Demo Exploring San Diego Burrito Ratings 00:16:40 Duration
Lecture 14 HOMEWORK Exploring San Diego Burrito Ratings
Lecture 15 Pivot Table Demo Tracking Daily Weather Conditions 00:12:41 Duration
Lecture 16 HOMEWORK Tracking Daily Weather Conditions
Lecture 17 Pivot Table Demo Analyzing Spartan Race Facebook Posts 00:14:37 Duration
Lecture 18 HOMEWORK Analyzing Spartan Race Facebook Posts
Lecture 19 Pivot Table Demo Analyzing Apple App Store Data 00:18:39 Duration
Lecture 20 HOMEWORK Analyzing Apple App Store Data
Lecture 21 Pivot Table Demo Analyzing Wine Tasting Scores 00:17:13 Duration
Lecture 22 HOMEWORK Analyzing Wine Tasting Scores