by Oz du Soleil | Jun 6, 2012 | Excel Geekdom, Tips
Excel is already exciting, and then you add macros or VBA (Visual Basic for Applications) into the mix and WOAH! When I started using Excel VBA with regularity, it seemed like the right VBA code would allow me to see into the future. I’ve used VBA for...
by Oz du Soleil | May 21, 2012 | Excel Geekdom, Spreadsheet Development, Tips
Have you worked with a complex, long, and/or detailed formula, Excel keeps returning #N/A or #NAME and it’s making you crazy? Excel does have a Formula Troubleshooter but it’s not so user-friendly. So, how do you troubleshoot formulae without going...
by Oz du Soleil | Apr 30, 2012 | Excel Geekdom, Spreadsheet Tidiness, Tips
Have you written a complex formula or had to understand a long formula that someone else wrote? It can become a jungle of parentheses and commas. One simple tip: Use ALT+ENTER in the Formula Bar to Make Troubleshooting and Validation easier Here’s a...
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...
