Using Power Query to Connect Tables for Reporting | Excel.TV, Episode 55 - Excel TV

Using Power Query to Connect Tables for Reporting | Excel.TV, Episode 55

An Excel Joke to Start Off...

Did you hear about the database developer that walked into a bar? They saw two tables and tried to join them. 

And that's what we're doing this week! Last week, as you might recall, I posted an overly complicated solution to this problem based on formulas.  

This week, I've simplified it all using a left outer join. This is a really cool feature that lets you treat Excel like a database. You can a very similar use of joins in Szilvia's video, by clicking here.

Watch the entire video to see how I join two different tables using name as the primary key! 

Get the Download File

Get the file by clicking this link.

What do you think? How do you connect tables?

Let us know in the comments.

Sign up to excel your life with tips, career advice, and more!

>

Get the FREE Excel Power User Guide