by Oz du Soleil | Jul 30, 2015 | Excel Geekdom, Spreadsheet Development, Tips
Months ago, my friend Michael asked, “is Excel for the common man?” That question has stirred my attention and imagination like I’ve just turned 21 years old again. Excel can be used for so many things and it’s been fun to come up with uses for...
by Oz du Soleil | Jan 4, 2015 | Spreadsheet Development, Spreadsheet Tidiness
My friend Mike asked, “is Excel for the common man?” The answer is yes, but I had to find a good example for someone who’s recently retired and has no workplace need for Excel. But, wherever there’s data, there’s opportunity to use Excel....
by Oz du Soleil | Sep 24, 2014 | Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness
Mynda Treacy’s recent blogpost at MyOnlineTrainingHub is a hot one! Excel Custom Validation to Limit Entries poses a fun and excellent solution that Santa probably deals with every year: How does Santa set up Excel to allow a kid to request no more than 3...
by Oz du Soleil | May 8, 2014 | Spreadsheet Development
Chandoo recently posted about Modular Spreadsheet Development (MDS). Like it was for him, this is a new concept for me but it made sense. The idea of Modular Spreadsheet Development is efficiency. If you’re developing certain spreadsheet elements over and over...
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 | 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...