Warning: mysql_real_escape_string(): Access denied for user 'dragon99'@'localhost' (using password: NO) in /home3/dragon99/public_html/wp-content/plugins/easy-contact-forms/easy-contact-forms-database.php on line 152

Warning: mysql_real_escape_string(): A link to the server could not be established in /home3/dragon99/public_html/wp-content/plugins/easy-contact-forms/easy-contact-forms-database.php on line 152
Spreadsheet Development Archives - Oz du Soleil
Select Page

## Excel Solution: Who Should Sit Where?

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

## Excel Dashboards for Simpler Data Entry & Analysis

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

## The Seven Deadly Sins of Data Entry (or how NOT to use Excel)

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

## COUNTIF you have errors

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