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...
by Oz du Soleil | Jul 11, 2012 | Data Management, Excel Geekdom, Spreadsheet Tidiness, Tips
So, a client delivers a lot of data to me. They need it scrubbed or, reorganized or, an application built around their to automate tasks … or some combination of the three. Guess what? Most projects involve something that I don’t know how to do (yet). And...
by Oz du Soleil | Apr 17, 2012 | Data Integrity, Excel Geekdom, Spreadsheet Tidiness
Think about that person who comes in before the dentist? They look around, take x-rays, and get everything clean and set up for the dentist. In some ways a Data Hygienist is similar: come in before the Analyst; before the Accountant, before the Database Architect;...