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 | Sep 15, 2014 | Data Integrity, Data Management
Hey! ‘Sexy’ isn’t my word. It’s used twice in the New York Times article, For Big-Data Scientists, ‘Janitor Work’ Is Key Hurdle to Insights. ‘Sexy’ is used once each by Data Scientists Michael Cavaretta and Matt...
by Oz du Soleil | Jul 30, 2014 | Excel Geekdom
After Mike “ExcelIsFun” Girvin’s appearance on ExcelTV, it was clearly time to embrace array formulas. Up until that episode, array formulas just freaked me out. I would go onto forums and ask for help, and sometimes the solution would be an array...
by Oz du Soleil | Jul 23, 2014 | Excel Geekdom
It’s been quiet around here for the past few months. Why? I’ve been writing an Excel book. Actually, I wrote an Excel book with Mr Excel, Bill Jelen. It was turned in to the publisher on 1JUL14. And what does any self-respecting guerrilla analyst/author do...
by Oz du Soleil | Jul 10, 2014 | Data Management
On Episode 12 of Excel TV I said a little about a trainee who started crying as I was teaching her the details of her new job. This story comes up in conversations around the challenges of working with data. This particular challenge was a complete data...