A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
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.
Let us know in the comments.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide