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 | Aug 27, 2013 | Spreadsheet Development
BFTBY: Blogging From The Backyard This weekend a friend asked me to take a look at her spreadsheet for a bit of manicure and polish. When I received the document, it was beautiful. So, the polish that I had was easy to apply. I can’t share the data with you...
by Oz du Soleil | Dec 21, 2012 | News
21DEC12: Excel Workshop: It was great! On Wednesday 19DEC12 12 students met at Chicago’s Holiday Club to learn about Excel formulas. We had a good time! The Holiday Club provides a great venue in their back room. Their waitress, Emma has been our assistant both...
by Oz du Soleil | Sep 4, 2012 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Tidiness
What Are Pivot Tables Used For? What Are Pivot Tables Good For? Many of you have heard of Pivot Tables and aren’t sure what they are. I’ll leave you to Google how to mechanically get one working but if you’re like me, teaching the mechanics...
by Oz du Soleil | Aug 7, 2012 | Data Management, Excel Geekdom, Spreadsheet Development, Tips
There are plenty of tutorials about working inside spreadsheet cells: creating formulae, finding ways to extract elusive data, etc. However, some of the best Data Management attention is spent outside of the spreadsheet cells: development of the overall file. So...