Setting Expectations

Getting to Know the IMDb Movie Database

Course Structure & Outline

Why Pivot Tables

Exploring Pivot Table Analyze & Design Options

Navigating the Pivot Table Field List

Creating Your First Pivot Table

Structuring Source Data for Analysis in Excel

Selecting, Clearing, Moving & Copying Pivot Tables

Removing & Reviving Data from the Pivot Table Cache

PRO TIP How Excel Pivot Tables ACTUALLY Work

Refreshing & Updating Pivot Tables

PRO TIP Dealing with Growing Source Data

PRO TIP Formatting Empty Pivot Table Cells

Changing Pivot Table Number Formats

Configuring Pivot Table Layouts & Styles

PRO TIP Using Tabular Pivot Tables to Create New Source Data

Customizing Pivot Table Headers & Labels

PRO TIP Adding Data Bars with Invisible Text

Applying Advanced Conditional Formats to Pivot Tables

Applying Basic Conditional Formats to Pivot Tables

PRO TIP Fixing Incorrect Alphabetical Sorting

Sorting Data with Pivot Tables

PRO TIP Pivot Table Label Filters with Wildcards

Filtering Data with Pivot Table Value Filters

Filtering Data with Pivot Table Label & Selection 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

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 ColumnRow

Calculating Pivot Table Values Running Total

Calculating Pivot Table Values Difference From

Calculating Pivot Table Values % of Parent

Calculating Pivot Table Values Rank

Creating Calculated Fields in Pivot Tables vs. Source Data

Defining Calculated Fields with Pivot Tables

Calculating Pivot Table Values Index

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

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

Inserting Pivot Table Calculated Items (USE WITH CAUTION!)

Generating Solve Order & List Formulas Reports

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

Customizing Pivot Chart Layouts & Styles

Moving Pivot Charts to New Excel Worksheets

Pivot Chart Demo Stacked Area Chart

Applying Slicers & Timelines to Multiple Pivot Charts

Building Dynamic Dashboards with Pivot Tables & Pivot Charts

Setting Expectations

Pivot Table Demo Analyzing U.S. Voter Demographics

Pivot Table Demo Analyzing San Francisco Salary Data

Pivot Table Demo Exploring Shark Attack Records

Pivot Table Demo Analyzing Stock Market Data

Pivot Table Demo Analyzing Major League Baseball Teams

Pivot Table Demo Tracking Daily Weather Conditions

Pivot Table Demo Analyzing Spartan Race Facebook Posts

Pivot Table Demo Exploring San Diego Burrito Ratings

Pivot Table Demo Analyzing Apple App Store Data

Pivot Table Demo Analyzing Wine Tasting Scores