Friday, April 25th, 2014 / by ExcelHelp
The use of Microsoft Excel to create spreadsheets has long been a business standard. The platform has helped numerous organizations improve how they operate and find trends. However, as with any system that has a high level of human involvement, there can be errors made by those that do not fully understand how to use the software.
An article from The Wall Street Journal’s MarketWatch examined how bad the situation can get when organizations make mistakes with their Excel worksheets.
The impact of oversights in your spreadsheet
According to Ray Panko, a professor of IT management at the University of Hawaii, bad spreadsheets practices are still widespread. In fact, he estimates that 88 percent of worksheets contain an error. Even with careful development, one percent or more of all formula cells has a mistake and when you consider how large some documents can be, with thousands of formulas, that could mean there are dozens of undetected errors.
While it is easy to think that you could have a mistake in a family budget or with the books of a small business, one would think that larger organizations would be able avoid them. But that is not always the case.
The article mentioned a Harvard economics study that was released in 2012 by Carmen Reinhart and Kenneth Rogoff. There was a mistake where certain spreadsheet cells were not included in specific formulas which caused the report to overstate the impact debt burdens have on a nation’s economic growth.
Avoiding common errors
Patrick O’Beirne, the chairman of the European Spreadsheet Risks Interest Group, said that the mistake could have easily be avoided.
“Technically, the Harvard error could have been spotted by simple tests, such as pressing Ctrl + [ on a formula, to show what cells feed into the total,” he says. “There are also many software tools, such as XLTest, to point out structural flaws.”
He went on to say that this problem is created because many companies do not double check their spreadsheets. While the text used in a press release or white paper will be passed along to multiple people for edits, that is typically not the case when it comes to a spreadsheet. This is where the small errors that have larger consequences slip through.
Preventing future complications
There has been a push for a widespread certification program that would help ensure best practices are followed by anyone making a spreadsheet.
Instead of following this path, organizations can partner with a consulting firm that can help with Excel functions and ensure errors are kept to a minimum.
I can not recommend ExcelHelp more highly. We had been struggling to complete a critical project and finding them was a lifesaver. Tom was knowledgable, professional, personable, patient and responsive. Look no further for your database programming needs. Thanks Tom and ExcelHelp.com!Randy Hartnell
We anticipate a long business partnership with ExcelHelp and look forward to working with them. I have been nothing but impressed with your firm’s services, your team members tenacity and the overall results. Sometimes you have to travel a bumpy road trying different firms until you find the one that fits.Posted By: Charlene Faber
Chief Operation Officer, Current Builders
I’d like to express my gratitude for the help and cooperation we’ve received from your entire organization during the development of our Modeling Utility. Over the past several weeks we’ve engaged key customers worldwide...We have confidence that this effort will add significant capability and value to the overall success of the program.Business Development Manager
Network Architecture and Strategy
Posted By: Marty M.