This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Ultimate Guide to Data Analysis with Pivot Tables
Downloads
101 Amazing Pivot Table Tips and Tricks (eBook Bonus)
51 Excel Functions You Need To Know (eBook Bonus)
Course Data Workbook
Pivot Table Quick Start Guide (PDF)
Introduction
About The Course
Why Pivot Tables?
About The Data (1:59)
Step 1: The Pivot Table Basics
Inserting A Pivot Table (13:08)
Meet The Pivot Table Tools Tab & Field List (6:51)
Building Your First Pivot Table (10:31)
What Is A Pivot Table Actually Doing? (4:37)
Refreshing Your Pivot Table Data (6:24)
Changing Your Source Data (7:01)
Selecting, Moving And Clearing Pivot Tables (5:25)
Field Settings And Value Field Settings (11:51)
Step 2: The Secrets To Making Your Pivot Tables Look Amazing
Formatting The Numbers In Your Pivot Tables (2:58)
Changing The Report Layouts (4:13)
Adding SubTotals And Grand Totals (3:35)
Making Your Pivot Table Look Stylish (5:28)
Get Extra Fancy With Conditional Formatting (13:52)
Step 3: The Easy Tricks to Sorting Data the Way You Want
The A To Z Of Sorting Your Data (12:17)
Step 4: Filtering to Focus on Only the Data You Want to See
Manually Pick And Choose What Data You Want (11:20)
Dynamic Filtering Based On Text Fields (9:15)
Dynamic Filtering Based On Value Fields (7:43)
Create More Flexible And Powerful Filters With Wildcards (5:02)
Massive Time Saving Trick To Create Multiple Pivot Tables (4:08)
Step 5: Grouping Data Together to Find Hidden Trends
Grouping Text Fields (5:02)
Grouping Date Fields (4:32)
Grouping Numeric Fields (4:03)
Step 6: Extending Your Analysis With Calculated Fields & Calculated Items
Calculated Fields (6:12)
What Calculated Fields Are Actually Doing (6:55)
Calculated Items (6:17)
Step 7: Discovering The Power Of Show Values As
An Introduction To Show Values As (2:31)
Show Values As Percent Of Column Or Row Totals (4:04)
Show Values As Percent Of Grand Total (2:31)
Show Values As Percent Of Parent (3:16)
Show Values As Difference From And Percent Difference From (6:02)
Show Values As Running Total And Percent Running Total (3:29)
Show Values As Rank (1:46)
Step 8: Creating Visuals With Your Data Using Dynamic Pivot Charts
Introduction To PivotCharts (2:14)
Creating Your First Pivot Chart (4:01)
Creating A Second Independent Pivot Chart (2:34)
Exploring The Available Options In The Design Tab (4:56)
Exploring The Available Options In The Format Tab (3:09)
Step 9: Adding Impressive And Interactive Slicers & Timelines
Inserting Your First Slicers And Timelines (6:57)
Slicer And Timeline Tools Options Tab (4:27)
Connecting A Slicer Or Timeline To Multiple Pivot Tables (4:52)
Step 10: Putting It All Together And Building A Beautiful Dashboard Your Boss Will Love
Dashboard Preview (2:38)
Adding KPI Data Cards (16:01)
The Reasons To Use GetPivotData (2:19)
Adding A Map Chart (5:38)
Adding A Pie Chart (4:39)
Adding A Top Ten Bar Chart (3:39)
Adding A Line Chart (3:14)
Adding Slicers And Timelines (5:14)
Arranging And Aligning The Object In Your Dashboard (6:33)
Protecting The Dashboard (5:53)
Adding New Data Into The Dashboard (2:11)
Extras: Additional Tips And Tricks To Do Even More With Pivot Tables
About This Section
Unpivot Data Using The Pivot Table Wizard (4:38)
Replace Blank Cells In Your Pivot Table (1:49)
Show Items With No Data (1:26)
Get All Possible Combinations Of Items Using A Pivot Table (4:17)
Show Multiple Subtotals (1:43)
Defer Layout Update Option (0:53)
Allow Multiple Filters Per Field (2:01)
Turn Off Autofit Column Width On Update (1:09)
Dynamically Link Pivot Charts To PowerPoint (1:33)
Remove Old Items From The Pivot Table Data Cache (2:05)
Pivot Table Keyboard Shortcuts (7:26)
Remove The Pivot Table Tooltip (0:49)
Adjust Indent Level In Compact Form (1:21)
Using A Helper Column (5:08)
Rounding Numbers In A Pivot Table (5:34)
Create Sheets From A List (3:44)
Case Study: Chicago City Employee Salaries
Chicago City Employee Salary Data
Quiz: Chicago City Salary Data
Solutions: Chicago City Salary Data (12:04)
Case Study: Titanic Survivor Data
Titanic Survivor Data
Quiz: Titanic Survivor Data
Solutions: Titanic Survivor Data (8:33)
Pivot Table Webinar
Pivot Table Webinar (53:19)
Dynamic Filtering Based On Text Fields
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock