by Oz du Soleil | Nov 10, 2014 | Excel Geekdom, Tips
The anti-VLOOKUP people are at it again, and let’s blame Sumit Bansal at TrumpExcel.com (of course, I’m joking). VLOOKUP Vs. INDEX/MATCH – The Debate Ends Here! is a blogpost that’s quite thoughtful in how it addresses something in the Excel...
by Oz du Soleil | Mar 3, 2014 | Data Integrity, Spreadsheet Development, Tips
A while ago I wrote a blogpost that attracted some hostility. One commenter even called it “stupid.” 6 Reasons Not To Use VBA (Or Be Careful) was meant to be a fun warning and an invitation to BE CAREFUL. Ah! But a few folks took it as a swearing off of...
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...
by Oz du Soleil | Nov 17, 2012 | How Tos and Q&As
Here’s the answer to a question about THE Excel Functions To Know. The request was for the top 10 but 10 is too many. After 3 or 4 functions, they get difficult to rank because they fall into areas of infrequent use or exclusive use. Things like INDIRECT, INDEX,...