Excel Magic Trick 1468

Introduction to Power Query & Power Pivot Data Model in Excel 2016

DESCRIPTION

Learn about how
Topics:
(00:16) Introduction
(00:51) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016
(03:51) Example #1: Clean Data and create Excel PivotTable Report, then add new data and refresh report!
(17:06) Example #2: Transform Cross Tabulated Table into Proper Data Set
(21:50) 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.
(22:34) Diagram to understand Data Model and Power Pivot
(46:46) Unhanded Exception Error.
(48:02) Summary Two COUNTIFS Functions Formula

WORKBOOKS

Download “Excel Magic Trick 1468” Excel-Magic-Trick-1468.zip – Downloaded 20 times – 24 MB







Be the first to comment

Leave a Reply