by Oz du Soleil | Dec 29, 2012 | Data Integrity, Data Management, Spreadsheet Development, Spreadsheet Tidiness
Krampus torments a business owner who ran a business on crap data in 2012 high bounce rates on e-newsletters vital data sprinkled across multiple sources commission payments were wrong mail sent to out-of-state clients for local events unable to follow-up with major...
by Oz du Soleil | Dec 21, 2012 | News
21DEC12: Excel Workshop: It was great! On Wednesday 19DEC12 12 students met at Chicago’s Holiday Club to learn about Excel formulas. We had a good time! The Holiday Club provides a great venue in their back room. Their waitress, Emma has been our assistant both...
by Oz du Soleil | Dec 17, 2012 | How Tos and Q&As
And here we are at the 5th of the Top 5 Excel Functions to Know! SUMIFS is in the Top 5 because when you’re working with numbers and need to do analysis or summaries, SUMIFS makes it so easy to see details that you need to see. We didn’t always have this....
by Oz du Soleil | Dec 12, 2012 | How Tos and Q&As
#4 in the List of Top 5 Functions: IFERROR Q: What do an acrobat and Excel’s IFERROR function have in common? A: An acrobat and an Excel user who employs IFERROR are both expressing: it’s risky but I know what I’m doing and I do it with elegance...
by Oz du Soleil | Dec 12, 2012 | Case Studies, Data Management, Spreadsheet Development
I just couldn’t resist. This is an unplanned blog post but Chris Penn posted something that was just too juicy to keep to myself! In Chris’ post Avoid Magic for Magicians, Marketing for Marketers, he warns that experts can spend so much time around...
