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 | Jan 14, 2013 | Data Management, Excel Geekdom, Screencast, Tips
Tonight, I’m preparing to teach a workshop and need examples to show the students. Here’s your behind-the-scenes peek into using Excel to generate data to build useful examples. WHY GENERATE BOGUS DATA (AKA DUMMY DATA) SETS? Knowing how to generate random...
by Oz du Soleil | Jan 4, 2013 | How Tos and Q&As
QUESTION Rowka asked “how do I make this formula smaller?” =IF(AND(E11>=K7,E11<=N7,F11>=K7,F11<=N7,G11>=K7,G11<=N7),”PASS”,”FAIL”) Translation of the Formula: If tests 1 thru 3 are within acceptable ranges, then...
by Oz du Soleil | Dec 31, 2012 | Tips
Tomorrow is the first day of 2013. 10 February 2013 is the first day of the Chinese New Year, the Year of the Snake. Have you reflected in the victories and lessons of 2012, and what 2013 will bring? The Snake represents calm, prosperity and good luck. There’s...
