Dynamic Filtering Based On Value Fields

The Ultimate Guide to Data Analysis with Pivot Tables

Downloads

Introduction

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

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

Step 6: Extending Your Analysis With Calculated Fields & Calculated Items

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

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

Case Study: Titanic Survivor Data

Pivot Table Webinar

Lesson content locked

If you're already enrolled, you'll need to login.