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 | Dec 12, 2012 | How Tos and Q&As
#4 in the List of Top 5 Functions: IFERROR Q: What do an acrobat and Excel’s IFERROR function have in common? A: An acrobat and an Excel user who employs IFERROR are both expressing: it’s risky but I know what I’m doing and I do it with elegance...
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,...
by Oz du Soleil | Nov 12, 2012 | How Tos and Q&As
QUESTION Nicole wanted to clean up a spreadsheet. She already had an answer to the math: Problem: She was doing it in more than one step and was sure things could be more tidy. Yes. This has a fairly easy solution but small things like this can irritate an Excel user...
by Oz du Soleil | Nov 9, 2012 | How Tos and Q&As
QUESTION Here’s an example an example of Data Parsing in Excel. Phil sent in this challenge. He receives a report and it’s not useful the way it is. Often, these reports are generated for an executive to read. That same report gets turned over to an...