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...
by Oz du Soleil | Jan 28, 2013 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness, Tips
The image below is an Excel Dashboard section generated from 847 rows and 11 columns of data related to classroom and book sales. In the range D1:N5 we summarize Monthly Sales Totals by Sales Rep. So much easier to look at this instead of scrolling around in the...
by Oz du Soleil | Jan 25, 2013 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness
In preparation for teaching a workshop on Excel Dashboards & Reports, I’m thinking about what needs to be covered. Several months ago, Mynda Treacy of My Online Training Hub provided an excellent guest post on Excel reporting. (Going forward, I use...
by Oz du Soleil | Dec 29, 2012 | Data Integrity, Data Management, Spreadsheet Development, Spreadsheet Tidiness
Krampus torments a business owner who ran a business on crap data in 2012 high bounce rates on e-newsletters vital data sprinkled across multiple sources commission payments were wrong mail sent to out-of-state clients for local events unable to follow-up with major...