Merge Multiple Excel Sheets Easily with Power Query

Learn how to quickly combine multiple Excel sheets into one using Power Query. Boost your skills with our Power BI course! πŸ”₯

Merge Multiple Excel Sheets Easily with Power Query
Kenji Explains
578.0K views β€’ Jan 21, 2024
Merge Multiple Excel Sheets Easily with Power Query

About this video

Automatically combine multiple excel sheets into one using Power Query.
πŸ”₯Take our in-demand Power BI for Business Analytics course: https://www.careerprinciples.com/courses/power-bi-for-business-analytics

πŸ†“ DOWNLOAD the Free Excel file for this video: https://careerprinciples.myflodesk.com/w6uzst3n21

In Excel you often need to combine multiple excel sheets into one. For example, you might have monthly sales tabs that you need to merge into one large sheet, or multiple excel files that you need to consolidate into a master file. Yet 90% of Excel users don't know how to do it. That's why in this video I'm going to show you a simple, automated solution to this problem using Power Query that will save you hours of tedius work. You might think of copy pasting as a solution, but this doesn't update if the original dataset changes. Same thing goes for the vstack formula. Instead, using Power Query, we'll be able to do this in no time.

LEARN:
πŸ‘‰ Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
πŸ”₯Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
πŸ“ˆ The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
πŸš€ All our courses: https://www.careerprinciples.com/all-courses

SOCIALS:
πŸ“Έ Instagram - https://www.instagram.com/careerprinciples/?hl=en
🀳 TikTok - https://www.tiktok.com/@career_principles
πŸ§‘β€πŸ’» LinkedIn - https://www.linkedin.com/company/careerprinciples/

β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬

Chapters:
0:00​ -​ Using Copy & Paste
1:15​ - Using the VSTACK formula
2:30​ - Combining Multiple Excel Sheets
6:58​ - Combining Multiple Excel Files

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Video Information

Views

578.0K

Likes

8.7K

Duration

8:48

Published

Jan 21, 2024

User Reviews

4.7
(115)
Rate:

Related Trending Topics

LIVE TRENDS

Related trending topics. Click any trend to explore more videos.