http://bit.do/dbL4V DBSchema secret sale page.
Download file: http://people.highline.edu/mgirvin/excelisfun.htm 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.
Niciun comentariu:
Trimiteți un comentariu