Section 1 : Getting Started

Lecture 1 Course Structure & Outline 3:26
Lecture 2 About Certification Pdf
Lecture 3 DOWNLOAD Course Resources Text
Lecture 4 Getting to Know the IMDb Movie Database 2:21
Lecture 5 Setting Expectations 1:15

Section 2 : Excel Pivot Table 101

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

Section 3 : Formatting Data with Pivot Tables

Lecture 19 Changing Pivot Table Number Formats
Lecture 20 PRO TIP Formatting Empty Pivot Table Cells 1:42
Lecture 21 Configuring Pivot Table Layouts & Styles 5:31
Lecture 22 PRO TIP Using Tabular Pivot Tables to Create New Source Data 2:20
Lecture 23 Customizing Pivot Table Headers & Labels 1:17
Lecture 24 Applying Basic Conditional Formats to Pivot Tables 6:51
Lecture 25 PRO TIP Adding Data Bars with Invisible Text 2:13
Lecture 26 Applying Advanced Conditional Formats to Pivot Tables 6:51
Lecture 27 HOMEWORK Excel Pivot Table Formatting Text

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

Lecture 28 Sorting Data with Pivot Tables 5:2
Lecture 29 PRO TIP Fixing Incorrect Alphabetical Sorting 2:2
Lecture 30 Filtering Data with Pivot Table Label & Selection Filters
Lecture 31 PRO TIP Pivot Table Label Filters with Wildcards 3:15
Lecture 32 Filtering Data with Pivot Table Value Filters 3:10
Lecture 33 PRO TIP Enabling Multiple Pivot Table Filters 2:42
Lecture 34 Grouping & Segmenting Data with Pivot Tables 3:23
Lecture 35 PRO TIP Enabling & Disabling Automatic Date Grouping 4:26
Lecture 36 Filtering Data with Pivot Table Slicers & Timelines 4:52
Lecture 37 Breaking Out Pivot Table Report Filter Pages 4:14
Lecture 38 HOMEWORK Sorting, Filtering & Grouping Data with Excel Pivot Tables Text

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

Lecture 39 Aggregating & Summarizing Data with Pivot Tables 4:46
Lecture 40 PRO TIP Avoiding the Pivot Table Count Of Trap 3:50
Lecture 41 Defining Value Calculations with Pivot Tables 3:36
Lecture 42 Calculating Pivot Table Values % of ColumnRow 3:47
Lecture 43 Calculating Pivot Table Values % of Parent 3:3
Lecture 44 Calculating Pivot Table Values Difference From 4:42
Lecture 45 Calculating Pivot Table Values Running Total 2:45
Lecture 46 Calculating Pivot Table Values Rank 2:36
Lecture 47 Calculating Pivot Table Values Index 8:7
Lecture 48 KNOWLEDGE CHECK Pivot Table Value Calculations Text
Lecture 49 Defining Calculated Fields with Pivot Tables 6:31
Lecture 50 Creating Calculated Fields in Pivot Tables vs 4:32
Lecture 51 PRO TIP Pivot Table Calculations Using Count Columns (Part 1) 7:21
Lecture 52 PRO TIP Pivot Table Calculations Using Count Columns (Part 2)
Lecture 53 Inserting Pivot Table Calculated Items (USE WITH CAUTION!) 6:12
Lecture 54 Generating Solve Order & List Formulas Reports 4:55
Lecture 55 HOMEWORK Enriching Data with Pivot Table Calculated Values & Fields Text

Section 6 : Visualizing Data with Excel Pivot Charts

Lecture 56 Intro to Excel Pivot Charts 2:27
Lecture 57 Pivot Chart Demo Column Chart 4:14
Lecture 58 Pivot Chart Demo Pie & Donut Charts 5:47
Lecture 59 Pivot Chart Demo Clustered Bar Chart 3:26
Lecture 60 PRO TIP Preventing Charts from Resizing with Cells 4:46
Lecture 61 Changing Pivot Chart Types 3:18
Lecture 62 Pivot Chart Demo Stacked Area Chart
Lecture 63 Customizing Pivot Chart Layouts & Styles 4:3
Lecture 64 Moving Pivot Charts to New Excel Worksheets 2:10
Lecture 65 Applying Slicers & Timelines to Multiple Pivot Charts 5:2
Lecture 66 Building Dynamic Dashboards with Pivot Tables & Pivot Charts 13:23
Lecture 67 HOMEWORK Visualizing Data with Excel Pivot Charts Text

Section 7 : Excel Pivot Table Case Studies

Lecture 68 Setting Expectations 1:46
Lecture 69 DOWNLOAD Case Study Resources Text
Lecture 70 Pivot Table Demo Analyzing U 10:33
Lecture 71 HOMEWORK Analyzing U Text
Lecture 72 Pivot Table Demo Analyzing San Francisco Salary Data
Lecture 73 HOMEWORK Analyzing San Francisco Salary Data Text
Lecture 74 Pivot Table Demo Exploring Shark Attack Records 10:31
Lecture 75 HOMEWORK Exploring Shark Attack Records Text
Lecture 76 Pivot Table Demo Analyzing Stock Market Data 12:26
Lecture 77 HOMEWORK Analyzing Stock Market Data Text
Lecture 78 Pivot Table Demo Analyzing Major League Baseball Teams 14:16
Lecture 79 HOMEWORK Analyzing Major League Baseball Teams Text
Lecture 80 Pivot Table Demo Exploring San Diego Burrito Ratings 16:40
Lecture 81 HOMEWORK Exploring San Diego Burrito Ratings Text
Lecture 82 Pivot Table Demo Tracking Daily Weather Conditions 12:41
Lecture 83 HOMEWORK Tracking Daily Weather Conditions Text
Lecture 84 Pivot Table Demo Analyzing Spartan Race Facebook Posts 14:37
Lecture 85 HOMEWORK Analyzing Spartan Race Facebook Posts Text
Lecture 86 Pivot Table Demo Analyzing Apple App Store Data 18:39
Lecture 87 HOMEWORK Analyzing Apple App Store Data Text
Lecture 88 Pivot Table Demo Analyzing Wine Tasting Scores 17:13
Lecture 89 HOMEWORK Analyzing Wine Tasting Scores Text