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;...
by Oz du Soleil | Apr 14, 2012 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Development, Tips
Do you work with password protection in Excel spreadsheets? If so, I have good news and bad news. BAD NEWS: the passwords are easy to break GOOD NEWS: the passwords are easy to break If you’re sanitizing data, repairing and modifying spreadsheets, it means...
by Oz du Soleil | Feb 23, 2012 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness, Tips
Let’s say you have 600 rows of data and you’re looking at a final number from column W telling you that you are owed a total of $17,384. Can you trust it? Suggestion: Create a formula that looks for any cells in column W that show the error: #NA....
