How To Combine Excel Tables And Worksheets With Power Query

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
In this video, I explain how to combine multiple Excel Tables or Worksheets with Power Query. You will learn how to fully automate this process to save you a ton of time with this common Excel task.

The video covers:
The prerequisites for the data and column structure.
How to setup the connection queries in Power Query, plus a macro to make this faster.
How to append or combine the queries to stack the data.
The update and refresh process when the data changes or you get new data.
How to add new tables to the append query.

You can download the example file on the following page:

https://www.excelcampus.com/powerquer...

Additional Videos & Resources:

Excel Tables for Beginners:    • Excel Tables Tutorial: Beginners Guid...  

Power Query Overview:    • How To Automate Data Tasks In Excel U...  

How to Install Power Query:https://www.excelcampus.com/install-p...

Introduction to Pivot Tables & Dashboards Video Series:    • How to Create a Dashboard Using Pivot...  

Free Webinar on The Modern Excel Power Tools:

If you are new to Power Query and/or not sure how it fits into other features like Power Pivot, Power BI, pivot tables, or macros & VBA, then check out my free training webinar. It’s called the Modern Excel Blueprint and it’s running right now for a limited time.

https://excelcampus.com/blueprint-web...
00:00 Introduction
01:58 Power Query Setup
06:58 Updating and Refreshing Data