Control your Excel spreadsheets!

Consider these shocking stories on how a simple Excel error can cause you sleepless nights:

  • A cut and paste error cost TransAlta $24 mil when it underbid an electricity supply contract.
  • A missing minus sign caused Fidelity Magellan Fund to overstate projected earnings by $2.6 bil and miss a promised dividend.
  • Falsely linked spreadsheets permitted fraud totalling $700 mil at Allied Irish Bank.

We tend to use Excel spreadsheets like pieces of paper without care and consideration. I’m willing to bet that many of our most important Excel spreadsheets have material errors.

bad-excel-habits

Learn more about our Excel training program Robust Spreadsheets with Checks and Controls.

Related posts:

  1. Develop Robust Excel Spreadsheets with Checks & Controls The use of spreadsheets has crept into daily business operations at the highest levels. Given that many spreadsheets are developed by self taught professionals, there...
  2. Where Microsoft Excel Fails Your company may have spent thousands of dollars on a fancy financial application but nothing beats the comfort and familarity of a spreadsheet. They are...

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

android-10b-excel

Google officially announces 10 billion app downloads in Excel

As an Android fan, I am happy to learn that the Android Market has surpassed 10 billion downloads. I found this pretty looking 3D column chart. I have never been convinced that 3D charts are good enough for serious business use. But this chart made me think again. The exponential growth trend jumped at me. [...]

Continue Reading

3D Setting in Excel Charts

Do it in Excel: Ring charts are better Pie charts

Pie charts are a circular chart divided into sectors, illustrating proportion. I remembered learning them when I was in primary school. Apparently it was invented by this person called William Playfair in 1801. Pie charts are simple to understand but rather limited because: 1. Can only show a single data series. 2. Can only show [...]

Continue Reading