Excel Power Query #04: Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically

Опубликовано: 28 Ноябрь 2014
на канале: excelisfun

103,854

454

Download file: http://people.highline.edu/mgirvin/ex...

See how to import multiple CSV files from a folder and refresh Query and PivotTable when new files are in folder:
1. (00:11 minute mark) Problem Setup
2. (00:52 minute mark) Power Query Import From Folder
3. (01:15 minute mark) Edit Query and look at code that is written
4. (04:53 minute mark) Build PivotTable with Slicer
5. (06:12 minute mark) Add New Files to Folder
6. (06:17 minute mark) Automatically update with Refresh

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