Robust Spreadsheets with Checks and Controls

Robustness: the ability of a structure to withstand events like fire, explosions, impact or the consequences of human stupidity.

Robust Spreadsheets with Checks and Controls

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

Training Course Duration (days)

Location:
Singapore

Venue:
Frasers Tower

Dates:
Ask for dates

Funding:
SkillsFuture subsidies not applicable yet

Did You Know

June 2003: A cut and paste spreadsheet error cost TransAlta Corp $24 mil when it underbid an electricity supply contract. Google for more details.

Course Description

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.

Course Outline

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.
Relevant Excel features and its applications for Spreadsheet Auditing.
Risky Excel Settings

A methodology for Robust Spreadsheets

Who Should Attend This Course

This workshop is designed for someone who wishes to build professional grade, competent, robust spreadsheet models. Suitable roles in Business analysts, statisticians, business intelligence executives, reporting analysts, accountants.

Training Provider

Aeternus Consulting have been consistently rated by our clients for great quality in program design & reference materials.

Course Trainer

Jacqueline Tang is the Principal Consultant at Aeternus. She is an engaging, sought-after public speaker and instructor for Microsoft Office and SharePoint.

I want to say that the lessons were some of the best instruction I have ever had. You have a great teaching manner and mix of structure and flexibility which made learning enjoyable. If I come back to Singapore for any length of time I will definitely sign up for another one of your courses.