by Oz du Soleil | Oct 9, 2012 | Data Management, Excel Geekdom
UPDATE (2DEC13): ExcelWebApp continues to improve. They’ve added key validation features that didn’t exist when I originally published this blogpost in October 2012. See: App Development in Excel and Break-Even Calculator ♦♦♦ This was an unplanned blog...
by Oz du Soleil | Oct 2, 2012 | Data Management, Excel Geekdom
When Mr. Excel, Bill Jelen, is excited about something it’s time to pay attention. Excel Interactive View is part of Office 15 and is creating a lot of excitement because it allows users to analyze and manipulate data on a web page. Simply mind-blowing. Check...
by Oz du Soleil | Sep 25, 2012 | Data Integrity, Data Management
Today, 25 September, is my birthday and this reminds me of something: Data Collection Efforts That Invite Crap Data Crap data leads to questionable analysis, bad business decisions, and even contempt of your own customers because they’re the ones who fed you...
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 | Sep 4, 2012 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Tidiness
What Are Pivot Tables Used For? What Are Pivot Tables Good For? Many of you have heard of Pivot Tables and aren’t sure what they are. I’ll leave you to Google how to mechanically get one working but if you’re like me, teaching the mechanics...
by Oz du Soleil | Aug 20, 2012 | Data Management, Excel Geekdom, Tips
The Data Marshall returns to tell you about a feature in the forthcoming Excel 15. It’s going to be invaluable in Taming Dataville. There isn’t an official release date for Office 15 but there are previews and lots to be excited about. Check out this video...
