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 | 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 | 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 &...
by Oz du Soleil | Jan 10, 2014 | Data Management, Excel Geekdom
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 & Closing Comments The conversation continues...
by Oz du Soleil | Jan 9, 2014 | Data Management, Excel Geekdom
Continuing the conversation 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 & Closing Comments...
