This article looks at some classic spreadsheet errors in layman’s terms and suggests some preventative measures.
Lies, Damn Lies and Spreadsheets; How to Prevent Spreadsheets from Ruining Your Business
Posted by nialldevitt under ManagementFrom http://tweakyourbiz.com 4334 days ago
Who Voted for this Story
Subscribe
“Rachel: Great to hear! Thanks for your kind words! :)
All the Best,
Martin...”
“Thank you, Martin. That's a fantastic motto... and I couldn't agree more!...”
“Lisa: Good to hear! Thanks for your response....”
“For sure, I know I did years ago when I was working for others....”
“Lisa: I wonder if they potential employee is doing a background check on...”
Comments
4331 days ago
=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!