This video will show you how to get a list of all file names in a given folder and all it's subfolders using Excel's Power Query (Get & Transform in Excel 2016).
We use the From Folder query to quickly get an inventory of all files in the folder with just a few clicks!
Check out my full courses and ebooks here
DOWNLOAD the example workbook here
SUBSCRIBE & get my 3 FREE eBooks
CONNECT with me on social
Facebook:
Twitter:
LinkedIn:
Thanks for all your support!