Advanced Excel Training Courses Singapore

Robustness

is 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.
building robust spreadsheets microsoft excel training course singapore
Training Course Duration (days)
02
Location
Singapore
Venue
Frasers Tower
Dates
Ask for dates

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

Learning Objectives

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

Will be covered during the program and case studies will be presented.

Who should Attend

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.

Why Aeternus Training

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

About the Trainer

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

Past Participants

We worked with the best companies and individuals in Singapore and abroad.
shell
Created an automated service level dashboard for Terminal 2
Trained genius scholars on Excel
excel course client
microsoft excel training course client

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.
Invited to Economics Dev Board to conduct a team building workshop.
At GIC Pte Ltd to run a yearly Excel workshop for government scholars.
We ran an annual 1 day business infographics workshop for EMA.

Comfortable learning environment

No stuffy windowless classrooms for you and us. No, no, no.
Curious? Play the video to find out.