How to connect two tables in Excel - With Example Workbook

When I was working as a HR data analyst, one task I would do every week is combine data in two different tables. In this video, let's look at two ways to solve the problem. One using formulas and another with Power Query ⚡. Both methods are really simple to set up and will save you TONS of time in the long run.

⏱Video topics 👇
==============
0:00 - Combining two tables in Excel - the problem
1:15 - Using lookup formulas to combine tables (with XLOOKUP)
2:18 - Using VLOOKUP to combine tables
3:04 - Using Power Query to join two tables (merge queries)
6:25 - Loading merged data to Excel

📗 Sample workbook:
==================

Grab the sample file from this link if you want to follow along or practice.
https://chandoo.org/wp/wp-content/upl...


👨‍🎓 Learn more 💻:
===============

📺 YOUTUBE VIDEOS:

on Power Query (complete tutorial, 80 mins, 260k views) -    • Power Query Tutorial - What is it, ho...  
on XLOOKUP (intro, 10 mins, 280k views) -    • I don't use VLOOKUP anymore. I use th...  
on combining data from Excel files -    • Powerful trick to combine all Excel f...  

👩‍💻 COURSES:

Power Query mini-course (2 hours, full PQ with many practical examples) - https://chandoo.org/wp/power-query-po...
Lookups mini-course (1 hour, 13 lessons) - https://chandoo.org/wp/lookups-for-da...
FULL Excel (24+ hours, 100s of examples) - https://chandoo.org/wp/excel-school-p...

~

More Power to You ⚡😀

PS: Scene from The Dark Knight at 0:33

#Excel #powerquery