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 | 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...