Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MASTERING EXCEL PIVOTTABLES
INTRODUCTION
Welcome (2:21)
SECTION 01: GETTING STARTED
Basics (5:24)
Data Preparation (4:24)
Creating (1:51)
Recommended (1:26)
Pivoting (3:36)
Tools (4:32)
Data Sources (1:41)
Management (4:13)
Section Quiz
SECTION 02: TOTALS, FILTERS AND FORMULAS
Subtotals and Grand Totals (2:00)
Summary Calculations (3:46)
Multi-field Calculations (2:49)
Calculated Fields (2:15)
Formula Data (2:55)
Data Drill Down (1:58)
Section Quiz
SECTION 03: SORT, FILTER AND SLICE
Sorting (2:53)
Filters (3:19)
Filter By Rule (2:45)
Filter By Search (2:44)
Slicers (2:24)
Formatting Slicers (3:47)
Filter By Field (1:54)
Section Quiz
SECTION 04: FORMATTING
Introduction (1:59)
Numbers (3:53)
Rules (3:12)
Top 10 (3:30)
Data Bars (3:07)
Color Scales (1:44)
Icons (3:46)
Managing Rules (2:25)
Multiple Rules (4:46)
Section Quiz
SECTION 05: PIVOTCHARTS
Creating (4:20)
Filtering (2:59)
Formatting (4:30)
Styles (2:57)
Types and Trends (6:31)
Section Quiz
SECTION 06: PRINTING
Variations (1:57)
Options (3:09)
Section Quiz
CONCLUSION
Course Review and What's Next? (1:57)
FINAL EXAM
Feedback
Data Preparation
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock