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
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
Introduction
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock