Power Query: Connect to Files in a List | Excel Off The Grid

Video Description

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Check out the blog post★ https://exceloffthegrid.com/power-query-files-from-list/ ★ About this video ★ Power Query has a really powerful feature that lets us combine all the files in a folder. However, sometimes the files are not contained in a single folder. Sometimes they are spread out in multiple places. How can we deal with that? That's what we are looking at in this video. How to combine files based on a list. 0:00 Introduction 0:31 Connect the files in a list 5:13 Conclusion ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel