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.
Get the Download File
What do you think? How do you connect tables?
Let us know in the comments.