by Oz du Soleil | Jul 3, 2012 | Data Integrity, Excel Geekdom, Guest Blogger, Spreadsheet Development, Spreadsheet Tidiness, Tips
This post will describe bad habits in Excel to do with cell formatting and formulas and how to avoid them. If you share spreadsheets in a team, the data will only be as strong as the weakest link in the team. For the first time ever, a Guest Blogpost on DataScopic.net...
by Oz du Soleil | Jun 11, 2012 | Spreadsheet Development
xlcalibre.com is a wonderful site that’s focused on Excel and how it’s used (and can be used) in Human Resources. I especially like the post Learning to Learn Excel. Often, the question comes up in conversation, in online forums, on Facebook, etc. How to...
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 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 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...