Completed
) Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Introduction to Power Query & Power Pivot Data Model in Excel 2016
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016
- 3 ) Example #1: Clean Data and create Excel PivotTable Report, then add new data and refresh report!
- 4 ) Example #2: Transform Cross Tabulated Table into Proper Data Set
- 5 ) Example #3: Import 1.2 Million Rows of Data from Text Files into Power Pivot and create a Data Model PivotTable, then add new data and refresh our report.
- 6 ) Diagram to understand Data Model and Power Pivot
- 7 ) Unhanded Exception Error.
- 8 ) Summary