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)
Frasers Tower
Ask for dates
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.

Corporate Clients

We have helped teams from various organisations.

We work with businesses and individuals

who need effective Microsoft Office training solutions.​

We organise bespoke corporate workshops​

to improve employee productivity using Microsoft Office Tools.

Trainers with decades of real-world consulting experience

so you can ask us anything.

About Aeternus Consulting

Best Excel courses in Singapore conducted by expert consultants

Aeternus Consulting is the premier training centre in Singapore for Excel CoursesBasic Excel, Advanced Excel and Excel VBA Macro courses. For more Microsoft Excel training courses, please visit our Excel training page.

Aeternus Consulting is now on Instagram! So take a look and follow us on Instagram.