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 | Feb 17, 2014 | How Tos and Q&As
Q: Why does a knight have a lance, armor and a solid horse? A: All of those pieces make it a helluva lot easier to succeed inside the reality of knocking another person off of their horse. The task of unhorsing is fairly simple in concept. But problems arise quickly...
by Oz du Soleil | Jan 20, 2014 | Case Studies, Screencast, Spreadsheet Development
Today, we look at a basic need and take it a few steps further. The result is a mini app for randomizing meals. We won’t get into the dirty how-to of formulas. Instead, we’ll think through what’s needed to make something really work for a repeated...
by Oz du Soleil | Jan 14, 2014 | Data Management, Guest Blogger
Here we are at the final day of a 6-day tour that started with a question: where are Excel and Google spreadsheet headed? We’ve gone on a fascinating journey across a vivid landscape in this world of spreadsheets, particularly Excel, the #1 BI tool around the...
by Oz du Soleil | Jan 13, 2014 | Case Studies, Data Integrity, Data Management, Excel Geekdom
We’re almost at the end, good people. Part 1: The Introduction Part 2: Bill Jelen & Hiran de Silva Part 3: Craig Hatmaker & Rob Collie 1 Part 4: Craig Hatmaker & Rob Collie 2 Part 5: Jordan Goldmeier & Carl Arriaza Part 6: Szilvia Juhasz &...