In this video, I will show you how to combine all the Excel files in a folder using Power Query.
One great benefit of doing this is that in future in any of the workbook data gets updted or if you add more files to the folder, you can quickly get the combines data with a single click
✅ Power Query Course Download files: https://trumpexcel.com/course-downloa...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #PowerQuery #ExcelTips
Watch video 13 - Combine All the Excel Files in a folder Using Power Query online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 02 April 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 141,989 once and liked it 1.7 thousand people.