Get the data from the most recent file in a folder with Power Query

This video how you can connect an Excel file to a folder with Power Query and bring the data of the most recent file in that folder into Excel. The particular situation used in this video also includes an example of how you can apply a left outer join to consolidate your data.

(Example based on a case presented on a previous video)

About the Author: Celia Alves

Celia Alves is an awarded Microsoft MVP and Certified Excel Expert, specializing in building highly complex solutions combining VBA, Power Query, and Power Pivot to automate Excel reporting procedures. By combining her experience as an Excel Consultant and two decades as a Mathematics teacher, Celia created a training program to pass on her knowledge and techniques to those who want to stop wasting time in Excel with repetitive and meaningless tasks. Celia is also the founder and leader of the MS Excel meetup group in Toronto, with over 3,000 members worldwide.