Saturday, February 23, 2013

Spreadsheets And GIGO

JPMorgan Chase's recent $6 billion trading loss was viewed as a huge error in judgement. However, the company laid the blame for a portion of the loss on an error in a spreadsheet. Spreadsheets are a valuable tool in Finance, but the old adage of "Garbage in, garbage out" (GIGO) still applies. Software has helped improve the accuracy of spreadsheets. When you consider that companies may have 50,000 or more spreadsheets, you should recognize the sheer number of possible errors. And, if you are not sure why you should learn to use Excel, consider one number in the article: More than 59 percent of Finance employees spend more than one-half of their time working with spreadsheets.