Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model

Download file: http://people.highline.edu/mgirvin/excelisfun.htm

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.
1. (00:10 minute mark) Problem Setup
2. (01:03 minute mark) Import Excel workbook files from Folder.
3. (01:40 minute mark) Add new column using Excel.Workbook
4. (02:36 minute mark) Add new column using Table.PromoteHeaders
5. (04:00 minute mark) Edit Query after it is loaded. Change Data Types for columns.
6. (04:37 minute mark) Create PivotTable with Slicer
7. (05:30 minute mark) Add new files to folder.
8. (05:45 minute mark) Refresh to see that new file data is included in PivotTable.
9. ( minute mark)
10. ( minute mark)

Miguel Escobar and Ken Puls are doing online workshops on Power Query www.powerquery.training . This training is not by excelisfun.

Видео Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model канала ExcelIsFun