by Oz du Soleil | Sep 27, 2013 | Data Management
Today Chandoo posted an interesting blogpost on “The Best Excel Interview Questions.” This is interesting for many reasons. For one, in Excel forums this question comes up a lot in very different variations: Someone says they’re an Excel expert, how...
by Oz du Soleil | Nov 27, 2012 | How Tos and Q&As
#2 of my Top 5 Excel Functions: VLOOKUP If VLOOKUP was a song, this would be it, I Like it Like That! VLOOKUP can turn a 2-day ordeal into a 5-minute task. Reasons to use VLOOKUP List of 400 addresses each needing to be assigned one of 9 Regions Master list of the 9...