This article looks at some classic spreadsheet errors in layman’s terms and suggests some preventative measures.



Comments


Written by elainerogers
326 days ago

Niall & Helen, a super article - thanks for highlighting the vulnerability and volatility of spreadsheets and their users!!

=20+15*2 - A most common error in spreadsheets is lack of knowledge of simple mathematics. Some would use this simple formula to return an answer of 70, however a spreadsheet will return 50. No amount of auditing/checking will proof something like this.

I had a client who used Excel for accounting - when moving over to an accounts package, they realised they had not invoiced for 2 contracts!! OK it was only 1000 Euros, but that is a lot of money to be missing out of a small business cash flow!

Again, thanks for highlighting. Self taught spreadsheet users can be the most dangerous kind, especially when they mentor others!



Log in to comment or register here.
Subscribe

Tim Jahn Gives an Intimate Look at Entrepreneurship

What's better than gaining top entrepreneurial advice for yourself and your own personal ventures? How about … More
Editor's Picks

Got small business blog posts? Register and submit them today!
See if you're one of our Top 10 Members this week!
Add BizSugar buttons and plugins to your small biz toolkit!
Shazam! Meet Contributor of the Week Paul Cox...Congrats, Paul!