Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Creating PivotTables in Excel with Jet Reports
Introduction
Course Outline and Goals
Jet Professional vs Jet Enterprise
How this eLearning Course Works
Examples and Exercises
Building a Basic PivotTable
General PivotTable Information
Creating a PivotTable from a Jet Enterprise Cube
Creating a PivotTable from a non-cube data source (3:38)
Introductory Concepts
Components of a PivotTable
PivotTable Example (pt 1) (3:34)
PivotTable Example (pt 2) (3:36)
Filtering Data
PivotTable Example (pt 3) (5:23)
PivotTable Student Exercise (pt 1)
PivotTable Student Exercise Solution (pt 1) (4:26)
PivotTable Layouts
PivotTable Example (pt 4) (3:20)
Formatting PivotTables
Renaming Column Headers
Sorting PivotTable Data
PivotTable Example (pt 5) (5:02)
PivotTable Student Exercise (pt 2)
PivotTable Student Exercise Solution (pt 2) (3:16)
Advanced PivotTables
Advanced PivotTables Introduction
Show Values As (3:30)
Show Properties in Report (3:33)
Value and Label Filters
Conditional Formatting and Example (4:09)
PivotTable Example (pt 6) (7:02)
PivotTable Student Exercise (pt 3)
PivotTable Student Exercise Solution (pt 3) (5:03)
Additional PivotTable Information
Introduction
Refreshing PivotTables
Drill Through
Defer PivotTable Updates
Convert to Formulas
Common Questions
Quick Survey
Creating a PivotTable from a non-cube data source
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in the Course to Unlock