by Oz du Soleil | Jul 30, 2015 | Excel Geekdom, Spreadsheet Development, Tips
Months ago, my friend Michael asked, “is Excel for the common man?” That question has stirred my attention and imagination like I’ve just turned 21 years old again. Excel can be used for so many things and it’s been fun to come up with uses for...
by Oz du Soleil | Jan 25, 2013 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness
In preparation for teaching a workshop on Excel Dashboards & Reports, I’m thinking about what needs to be covered. Several months ago, Mynda Treacy of My Online Training Hub provided an excellent guest post on Excel reporting. (Going forward, I use...
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 | 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....