Download Start Excel File: https://excelisfun.net/files/EMT1622-Start.xlsx
Download Finished Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1622-Finished.xlsx
Learn how to use Excel.CurrentWorkbook Function in Power Query to Import Multiple Excel Worksheet Tables into Single Table for PivotTable Report.
1. (00:01) Introduction.
2. (00:22) Look at Table Setup.
3. (00:59) Name Excel Tables.
4. (01:55) Bring Tables from Different Sheets into PivotTable using Excel.CurrentWorkbook Function in Power Query.
5. (05:52) Load Single Table to the PivotTable Cache.
6. (06:40) Build Allocation PivotTable Report.
7. (07:30 Refresh PivotTable and Query.
8. (07:52) Create second PivotTable Usage Report by connecting to “Connection Only Power Query Query”.
9. (08:30) Create Calculated Field in PivotTable for % Usage Formula.
10. (09:05) Summary.