by Oz du Soleil | Mar 26, 2013 | Data Integrity, Screencast
WHY SO MUCH ATTENTION ON VALIDATION? Embarrassment is what got me thinking about Excel data validation and general data quality. Let me describe 2 situations from years ago when I first started working with data: #1 My boss regularly had me run reports, and he’d...
by Oz du Soleil | Mar 9, 2013 | Data Integrity, Data Management, Spreadsheet Development
There was a steel smelter in my hometown. He was a tall, solid block of quiet energy. When asked about his occupation he’d hiss with deliberate bravado: “I work with fire” The way he emphasized “fire” conveyed his passion...
by Oz du Soleil | Feb 14, 2013 | Data Management, Spreadsheet Development
Fantastic article today from Forbes and author Tim Worstall. Microsoft’s Excel Might Be The Most Dangerous Software On The Planet The author points to aspects of the financial markets that would have been impossible without Excel. However, because it’s the...
by Oz du Soleil | Feb 6, 2013 | Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness
Quick & dirty update! AWW WOW! Excel 2013 allows the addition of a timeline into Pivot Charts! (not included with Excel for Mac) Let’s say you have a lot of dates and want to see graphic summaries grouped by month or year. Before 2013, that called for a...
by Oz du Soleil | Feb 3, 2013 | Excel Geekdom, Spreadsheet Development
I’m going to clean up a mess I started. I’ve complained about Excel not being easy to integrate into the internet or replicate its complete functionality in the almighty cloud. As I research further it’s clear that bringing anything into the cloud is...
