by Oz du Soleil | Dec 12, 2012 | Case Studies, Data Management, Spreadsheet Development
I just couldn’t resist. This is an unplanned blog post but Chris Penn posted something that was just too juicy to keep to myself! In Chris’ post Avoid Magic for Magicians, Marketing for Marketers, he warns that experts can spend so much time around...
by PhilT | Oct 24, 2012 | Data Management, Guest Blogger, Spreadsheet Development
Guest blog by Mynda Treacy of My Online Training Hub. If you spend hours updating Excel reports each week or month then I’m sorry, but you’re doing it wrong. It shouldn’t take that long. All you need are a few key rules for setting up your workbooks and in most cases...
by Oz du Soleil | Oct 2, 2012 | Excel Geekdom, Spreadsheet Development
Live Data For Your Exploration of Excel Interactive View Hop in and Let’s Go! The table below is random Data for 66 people whom I created with a Data Generator to display Excel Interactive View (click here for Excel Interactive View Part 1). With Excel...
by Oz du Soleil | Sep 7, 2012 | Data Integrity, Excel Geekdom, Spreadsheet Development, Tips
Crossfooting is the Word of the Day. I woke up today and read a forum post about spreadsheet errors. Smart spreadsheet users include crossfooting to check the integrity of their spreadsheets and results. So: what is crossfooting? Crossfooting: calculating a...
by Oz du Soleil | Sep 6, 2012 | Data Management, Spreadsheet Development, Tips
What Are Pivot Tables Used For? What Are Pivot Tables Good For? My last post described spreadsheet Pivot Tables and tonight I was talking with my good friend Patrick Richards. He commented that he wasn’t left with a clear sense of what a Pivot Table is....
by Oz du Soleil | Aug 7, 2012 | Data Management, Excel Geekdom, Spreadsheet Development, Tips
There are plenty of tutorials about working inside spreadsheet cells: creating formulae, finding ways to extract elusive data, etc. However, some of the best Data Management attention is spent outside of the spreadsheet cells: development of the overall file. So...