Where Microsoft Excel Fails

buggy
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 indispensible tools for budgeting and analysis in all sorts of corporate functions like human resource, finance, accounting and the list goes on.

Now imagine among all the thousands of spreadsheets in your department what are the chances that you find errors in them? As reported in Computer World (May 2004) as much as 20% to 40% of Excel spreadsheets have errors. Some researchers would even put it as high as 91%!

Think about the odds next time you are working on a worksheet. Be very very careful.

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. 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...
  3. How to design a Sales Dashboard in Microsoft Excel Sales activity is the life blood for all businesses.  People who are responsible for sales must have their fingers on this vital pulse at all...

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