Robust Spreadsheets with Checks and Controls

Develop robust spreadsheets. Prevent operation errors. Audit spreadsheets with powerful formula auditing techniques.

A methodology for Robust Spreadsheets (click for bigger pic)
Synopsis:

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.

Training Objective
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.
A methodology for Robust Spreadsheets
Robust spreadsheets are developed by a more disciplined and planned approach. We will discuss a framework of 5 spreadsheet design principles.
Relevant Excel features and its applications for Spreadsheet Auditing
Will be covered during the program and case studies will be presented.
Risky Excel Settings
We will discuss seldom known but nevertheless risky excel settings that corporate Excel users should avoid.
Who should enroll
This is a career enhancing training program for business analysts, statisticians, business intelligence executives, reporting analysts, accountants.
Duration: 2 days.

*Losses from spreadsheet errors:
June 2003: A cut and paste spreadsheet error cost TransAlta Corp $24 mil when it underbid an electricity supply contract.

Write to us
To enquire detailed brochure,simply drop us a message.
General Enquiries
  1. (required)
  2. (required)
  3. (valid email required)
 

Choose other Master Class Excel programs