COMBINE Excel Files (Single Tab & Multiple Tabs)
In this video you will learn how to use Power Query to easily combine Excel Files. We will cover the solution for Excel files with a single worksheet, and also files with multiple worksheets.
►COURSES
My courses to advance your professional career ►https://www.the-excel-team.com/
20% off any course – use code YOUTUBE
►VIDEO RESOURCES
Download the excel workbook from this video: https://www.the-excel-team.com/course...
►Timestamps:
00:00 Combine Excel files
00:41 Combine Excel files with a single worksheet
04:06 Adding additional files to an existing query
04:41 Reorder week numbers (TextPadWith)
07:49 Combine Excel files with multiple worksheets
12:32 Combine files with multiple worksheets
►THE GEAR I USE
Camera: https://amzn.to/3SGHZqe
Lens: https://amzn.to/3A9EH7s
Camera + Lens Kit: https://amzn.to/3p6M74Z
Shotgun Mic A: https://amzn.to/3JEX1sn
Shotgun Mic B: https://amzn.to/3BPimgM
Desktop Mic: https://amzn.to/3A96rJl
Mouse: https://amzn.to/3A97R6J
Keyboard: https://amzn.to/3pbD16Y
Monitors: https://amzn.to/3p3XquP
Chair: https://amzn.to/3QiWX48
All products I use/recommend: https://www.amazon.com/shop/the.excel...
►CONNECT WITH ME
Contact me - Email: [email protected]
Website: https://www.the-excel-team.com/
Instagram: https://www.instagram.com/the.excel.t...
Tiktok: / the.excel.team
Note: The description of this video contains affiliate links. If you would like to support the channel and are already interested in one of the mentioned products, please consider using the links. The channel will receive a small monetary commission at no extra cost to you, but will help to bring more videos like this to you in the future.
Thank you for your support!