Loading...

Highline Excel 2016 Class 20: Power Query Import Multiple Excel Files & PivotTable Show Values As

16,343 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 8, 2016

Download Files: https://people.highline.edu/mgirvin/A...
In this video learn about:
1. (00:15) Overview: Clean & Transform & Import Multiple Excel Files with 1 Sheet Each & Create PivotTable Report
2. (03:00) Step 1: Import Multiple Excel Files, 1 Sheet Each, including Power Query (M Language) Excel.Workbook function.
3. (11:45) Step 2: Load to Data Model and create DAX Measure for Total Sales, Edit Power Query
4. (15:19) Step 3: Create PivotTable based on Data Model and Group Dates by Month and Year.
5. (16:50) Step 5: Use Show Values As feature in a PivotTable: % of Grand Total, Difference From, % Difference From, Running Total, and % Running Total.
6. (19:48) Step 4: Add Slicers for City and Year
7. (20:40) Step 6: Finalize Report
8. (21:40) Step 7: We Get New Files in Folder, After we Refresh: Everything Updates!

Loading...

Advertisement

to add this to Watch Later

Add to

Loading playlists...