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