by Oz du Soleil | Apr 14, 2012 | Excel Geekdom, Tips
Data can be wily and you never know what’s inside a data set until you begin to work with it to scrub it or extract information from it. You might need to do the same procedure from different angles to locate particular oddities. So, forgive yourself for not...
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....
by Oz du Soleil | Feb 22, 2012 | Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness, Tips
A handy feature in Excel: hide formulas that result in 0. You’ve set up a spreadsheet in anticipation of the future. All of the formulas are in place and the vast majority = 0. Of course they do. It’s only February. None of your product lines have sales...
