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! ShareConsider 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 Share Your company may have spent thousands of dollars on a fancy financial application but nothing beats the comfort and familarity of a spreadsheet. They...

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!

trust

How to trust an Excel VBA application?

Share A trust worthy person should be: 1. Honest & true. 2. The person is honest and true in many different situations. 3.The person is honest and true over a long period of time. Trusting an Excel VBA application is like trusting a person. When you trust a person, you have an expectation that this [...]

Continue Reading

Just as I was about to get used to Excel 2010. Now the game changed again!

Office 15, Word 15, Excel 15 & PowerPoint 15 screenshots.

ShareIt didn’t seem too long ago that Microsoft released Office 2010 (Office 14) upon us. Continuing the Windows 8 momentum we soon will hear about Office version 15! Here’s what going to happen. According to a Bloomberg report, Microsoft plans to finish up all work on Windows 8 by summer 2012 and release the new [...]

Continue Reading

Connect with us on Social Media

Twitter
Discussion forum, directions to office, new ideas, discounts and offers.

Any questions?

  1. (valid email required)
  2. (required)