by Oz du Soleil | May 13, 2013 | Excel Geekdom
This is so exciting, I almost put a cuss word in the subject line! This deserves a cigar so, please join me. For the past few months I’ve explored possibilities with Excel and the internet. I even took a PHP/MySQL course and what I discovered is that being in...
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...