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 is a likelihood that many critical spreadsheets (eg. balance sheets, portfolio investment models, risk analysis models, revenue calculations) have material errors.

There is a clear and present need to develop error free spreadsheets and adopt these electronic documents into a checks and controls framework to prevent future errors.

In this training program, we learn Excel techniques to:

  • Develop robust spreadsheets.
  • Prevent formula and user operation errors.
  • Audit spreadsheets with powerful formula auditing techniques.
  • Foil attempts to conceal data and formulas.


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

Related posts:

  1. 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...
  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