Course Detail(AER# : Advanced Excel for Reporting)

SDF Funding

AER# : Advanced Excel for Reporting

7.00 CPE Hours (Others)
Classroom

Important:

This AER# sessions are entitled for Early Bird Special and not valid in conjunction with any other offer or funding claims.

For funding-enabled sessions, please click here.


Programme Objective

This one-day practical course aims to train participants with the knowledge and ability to apply advanced excel functions for business analysis and financial reporting. Participants will also learn the fundamentals of transforming static formula to interactive formula in order to produce sustainable reports.

This programme also serves as a primer for the Business Analytics & Reporting (BAR) course.

For more information, please click on “Download Brochure”.

Programme Outline

Overview of Excel
Cell References
  • Relative vs. Absolute referencing
  • Named Ranges
Using Functions to Lookup and Reference to Database
  • Match
  • Hlookup / Vlookup
  • Choose
  • Offset
  • Index
Text Functions
  • Concatenate
  • Left
  • Right
  • Mid
Using Functions to Manage Data
  • Logical functions
  • Mathematical functions
Placing controls on a worksheet
  • Creating interactivity using combo box, spinner and scroll bar
  • Making choices using check box or option box on a worksheet
  • Linking a control to worksheet data


Training Methodology

Lecture style, with computer hands-on Exercises


Closing Date for Registration

1 Week before programme or until full enrolment

Intended For

This programme is especially suitable for those who need to build skills and confidence in complex spreadsheet systems in the area of finance and business, accounting and banking. This is also a pre-requisite for the Business Analytics & Reporting (BAR) programme.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

29 Mar 2017 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Christopher Nyoe

Testimonial

Funding


1] SDF Funding
This course is approved for SDF funding - For Company-sponsored participants only (eligibility criteria apply). SDF Funding amount is $2 per training hour.

 

Programme Facilitator(s)


Christopher Nyoe
BAcc(Hons), CA Singapore

Christopher graduated with honours in Accountancy from Nanyang Technological University and is a member of the Institute of Singapore Chartered Accountants. He is currently working in a leading integrated commodity producer and trader, and has over 15 years of experience in auditing, accounting, management reporting and compliance. 

A seasoned accounting professional with extensive hands-on experience with Excel, Christopher has been coaching and mentoring fellow professionals in varied settings. He believes in the creative use of Excel to value add and solve everyday problems faced by modern accountants.

Important:

This AER# sessions are entitled for Early Bird Special and not valid in conjunction with any other offer or funding claims.

For funding-enabled sessions, please click here.


Programme Objective

This one-day practical course aims to train participants with the knowledge and ability to apply advanced excel functions for business analysis and financial reporting. Participants will also learn the fundamentals of transforming static formula to interactive formula in order to produce sustainable reports.

This programme also serves as a primer for the Business Analytics & Reporting (BAR) course.

For more information, please click on “Download Brochure”.

Programme Outline

Overview of Excel
Cell References
  • Relative vs. Absolute referencing
  • Named Ranges
Using Functions to Lookup and Reference to Database
  • Match
  • Hlookup / Vlookup
  • Choose
  • Offset
  • Index
Text Functions
  • Concatenate
  • Left
  • Right
  • Mid
Using Functions to Manage Data
  • Logical functions
  • Mathematical functions
Placing controls on a worksheet
  • Creating interactivity using combo box, spinner and scroll bar
  • Making choices using check box or option box on a worksheet
  • Linking a control to worksheet data


Training Methodology

Lecture style, with computer hands-on Exercises


Closing Date for Registration

1 Week before programme or until full enrolment

Intended For

This programme is especially suitable for those who need to build skills and confidence in complex spreadsheet systems in the area of finance and business, accounting and banking. This is also a pre-requisite for the Business Analytics & Reporting (BAR) programme.

Competency Mapping

Others = 7.00 Hours

Programme Facilitator(s)

Christopher Nyoe
BAcc(Hons), CA Singapore

Christopher graduated with honours in Accountancy from Nanyang Technological University and is a member of the Institute of Singapore Chartered Accountants. He is currently working in a leading integrated commodity producer and trader, and has over 15 years of experience in auditing, accounting, management reporting and compliance. 

A seasoned accounting professional with extensive hands-on experience with Excel, Christopher has been coaching and mentoring fellow professionals in varied settings. He believes in the creative use of Excel to value add and solve everyday problems faced by modern accountants.

Upcoming Schedule

Registration is closed

Date & Time

29 Mar 2017 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 321.00
For Non-Members: $ 374.50

Programme Facilitator(s)

Christopher Nyoe

Venue

60 Cecil Street
ISCA House
Singapore 049709