List all the Files in a folder and Subfolders using Power Query

In this video, we list all the files from a folder including subfolder using Power Query. Previously we would rely on VBA to achieve such a task, but Power Query makes it so easy. Learn more about Power Query and tons more in the Ultimate Excel Course - https://bit.ly/UltimateExcel The video does not stop there. Listing the files takes just a few clicks, but we go on to explore some fantastic transformations in Power Query to get the list exactly how we want it. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us!