Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Pivot table Advanced Course
Pivot tables
Overview of the pivot table environment
Data files for pivot table practice
Preparing data for Pivot tables
Data manipulation (8:15)
Flash fill (14:23)
Text to Columns (13:06)
Creating pivot table reports
Creating a basic pivot table (14:40)
Adding and refreshing data to a pivot table (5:00)
Filtering data in a pivot tables (6:51)
Creating pivot charts
Creating a pivot chart (2:26)
Power Query
Power Query - Unpivot Data (6:18)
Power Query - Split Columns (9:05)
Quick Reference Guides
Excel quick reference guide
Formulas
vLookup (6:25)
Teach online with
Overview of the pivot table environment
This section identifies the pivot table environment, panes, and the pivot table ribbons.
Pivot Table Student Guide.pdf
Download
Pivot Table Student Guide.pdf
Complete and Continue
Discussion
0
comments
Load more
0 comments