Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622)

Download Start Excel File:
Download Finished Excel File:
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.

Excel,Highline College,Mike Girvin,excelisfun,excel is fun,EMT,EMT 1621,Excel Magic Trick 1621,Excel.CurrentWorkbook Function,Power Query,Append Tables,Import Multiple Excel Worksheet Tables into Single Table,Load Multiple Tables for PivotTable,How to get multiple sheets into PivotTable,Multiple Tables for PivotTable,Multiple Worksheets into PivotTable,Data from multiple sheets into PivotTable,Bring Tables from Different Sheets into PivotTable,