See how to use Power Query to import multiple Excel Files into an Excel Table or Data Model. Then see how easy it is to update the Table when new files are dropped into the Folder.
(00:10) Problem Setup
(01:03) Import Excel workbook files from Folder.
(01:40) Add new column using Excel.Workbook
(02:36) Add new column using Table.PromoteHeaders
(04:00) Edit Query after it is loaded. Change Data Types for columns.
(04:37) Create PivotTable with Slicer
(05:30) Add new files to folder.
(05:45) Refresh to see that new file data is included in PivotTable.