Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Pivot Table: Grouping, Calcs, Slicer, Sparklines
Self Assessment Quiz
Pre-Course Assessment
Excel Pivot Case Studies- Please download for practice
Excel Pivot Case Studies- Please download for practice
Pivot Table Zen Handbook
Pivot Table Zen Handbook
Pivot Table All in One
1001 Pivot Table - Why should you learn (3:57)
1002 Pivot Table - Pre-requisites (2:24)
1003 Pivot Table - How to create one (2:39)
1004 Pivot Table - Exploring Pivot Table grid (Fields) (3:20)
1005 Pivot Table - Value Field Settings - Summarize Values By - Sum, Average, Count, Max etc. (5:04)
1006 Pivot Table - Value Field Settings - Show Values As - Percentage (%) of Grand Total (2:21)
1007 Pivot Table - Value Field Settings - Show Values As - Percentage (%) of ColumnRow Total (4:48)
1008 Pivot Table - Grouping - Numbers (3:37)
1009 Pivot Table - Grouping - Dates [Years, Months etc.] (4:07)
1010 Pivot Table - Grouping - Text (3:35)
1011 Pivot Table - Refresh vs. Refresh All, Change Data Source and creating Dynamic Table Data Source (6:17)
1012 Pivot Table - Auto Refresh (0:40)
1013 Pivot Table - Pivot Chart Shortcut and Sparklines (2:11)
1014 Pivot Table - Drill Down option (0:59)
1015 Pivot Table - Report Filter - Generating 100s of reports in few seconds (3:38)
1016 Pivot Table - Slicer vs. Report Filter (2:32)
1017 Pivot Table - Practice - Sales Data Analysis - 1 of 2I (%, Grouping, Chart, Report Filter Pages) (7:57)
1018 Pivot Table - Practice - Sales Data Analysis - 2 of 2 (Slicer) (3:08)
1019 Pivot Table - Practice - Closing Stock Analysis (6:58)
Post-Course Assessment
1007 Pivot Table - Value Field Settings - Show Values As - Percentage (%) of ColumnRow Total
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock