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
Excel quick reference guide
Excel Quick Reference sheet.pdf
Download
Excel Quick Reference sheet.pdf
Complete and Continue
Discussion
0
comments
Load more
0 comments