Index Match Tutorial: Analytics in Excel series

Joins in Excel The closest thing you can get in Excel to a SQL join is the Index Match function.  Vlookup is similar, and more popular, but worse in every way.  Index Match is easier, faster, and less prone to errors when you adjust your worksheet. Index Match Tutorial Check out the below video for […]

Read More

We’re Back!!!!

Welcome back to the Analytics Dude! Sorry for the delay in content, but never fear we are back and up and running.  Unfortunately all of the old posts were lost in the site update, but that gives us the chance to update our old material and highlight some new things. Stand by for new content […]

Read More