by Oz du Soleil | Apr 21, 2012 | Case Studies, Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness, Tips
The following isn’t meant to be a “how-to.” This is designed to quickly show how we got over a challenge faced by a client who didn’t think that there was a simple solution. Have a look. Maybe this will inspire you to think about ways that your...
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 17, 2012 | Case Studies, Data Management, Excel Geekdom, Spreadsheet Tidiness, Tips
Converting PDF to Excel. OMG! Several of my clients have needed critical information that was locked in a PDF file. Maybe they wanted to sort thousands of entries by zip code, # of employees, square-footage or by industry. No-can-do in a PDF! There are lots of PDF to...
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...