Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel: Data Analysis with Excel Pivot Tables
Getting Started
Course Structure & Outline (3:26)
Getting to Know the IMDb Movie Database (2:21)
Setting Expectations (1:14)
PivotTable 101
Why PivotTables? (4:10)
Structuring the Source Data (2:00)
Inserting Your First PivotTable (3:13)
Navigating the Field List (7:43)
Analyze & Design Options (1:33)
Selecting, Clearing, Moving & Copying Pivots (5:14)
Refreshing & Updating Pivots (7:30)
PRO TIP: Dealing with Growing Source Data (6:49)
How PivotTables ACTUALLY Work (3:39)
QUIZ: PivotTable 101
HOMEWORK: PivotTable 101
PivotTable Formatting
Number Formatting (2:12)
PRO TIP: Formatting Empty Cells (1:41)
Table Layouts & Styles (5:30)
PRO TIP: Using Tabular Layouts to Create New Tables (2:20)
Customizing Headers & Labels (1:16)
Adding Conditional Formats (6:51)
PRO TIP: Data Bars with Invisible Text (2:13)
QUIZ: PivotTable Formatting
HOMEWORK: PivotTable Formatting
Sorting, Filtering & Grouping
Basic Sorting Options (5:01)
PRO TIP: Incorrect Alphabetical Sorting (2:01)
Label Filters & Manual Selections (8:15)
PRO TIP: Label Filters with Wildcards (3:15)
Value Filters (3:10)
PRO TIP: Enabling Multiple Filters (2:42)
Grouping Data (3:23)
Automatic Date Grouping (4:25)
Filtering with Slicers & Timelines (4:51)
Breaking Out Report Filter Pages (4:13)
QUIZ: Sorting, Filtering & Grouping
HOMEWORK: Sorting, Filtering & Grouping
Calculated Values & Fields
Summarizing Values (4:45)
PRO TIP: Avoiding the "Count Of" Trap (3:49)
"Show Values As" Calculations (3:35)
Show Values As: % of Column/Row (3:47)
Show Values As: % of Parent (3:02)
Show Values As: Difference From (4:41)
Show Values As: Running Total (2:44)
Show Values As: Rank (2:36)
Show Values As: Index (8:06)
Inserting Calculated Fields (6:30)
Calculations in Pivots vs. Raw Data (4:32)
Calculating Using Counts (Part 1) (7:20)
Calculating Using Counts (Part 2) (4:19)
Calculated Items (NOT RECOMMENDED) (6:11)
Solve Order & List Formula Tools (4:54)
QUIZ: Calculated Values & Fields
HOMEWORK: Calculated Values & Fields
PivotCharts
Intro to PivotCharts (2:26)
DEMO: Column Chart (4:13)
DEMO: Pie & Donut Charts (5:46)
DEMO: Clustered Bar Chart (3:25)
PRO TIP: Prevent Charts from Resizing with Cells (4:45)
Changing Chart Types on the Fly (3:18)
DEMO: Stacked Area Chart (5:46)
PivotChart Layouts & Styles (4:03)
Moving PivotCharts to New Sheets (2:09)
Applying Slicers & Timelines to Multiple Charts (5:01)
DEMO: Building a Dynamic Dashboard (13:22)
QUIZ: PivotCharts
HOMEWORK: PivotCharts
PivotTable Case Studies
Setting Expectations (1:45)
U.S. Voters (2012) (10:33)
HOMEWORK: U.S. Voters (2012)
San Francisco Salaries (13:06)
HOMEWORK: San Francisco Salaries
Shark Attack Records (10:31)
HOMEWORK: Shark Attack Records
Stock Market Data (12:25)
HOMEWORK: Stock Market Data
Baseball Team Statistics (14:16)
HOMEWORK: Baseball Team Statistics
San Diego Burrito Ratings (16:40)
HOMEWORK: San Diego Burrito Ratings
Daily Weather Conditions (12:41)
HOMEWORK: Daily Weather Conditions
Spartan Race Facebook Posts (14:37)
HOMEWORK: Spartan Race Facebook Posts
Wrapping Up
Resources & Next Steps (2:27)
PRO TIP: Label Filters with Wildcards
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock