Course Detail()

1.00 CPE Hours (Category 1, Category 2, Category 3, Category 4, Others)
Online


Programme Overview

This is an e-learning programme. 
Upon successful registration and payment, you will be notified via email within 7-10 working days on your login ID, password and user instructions to access this programme. 
(The programme is valid for 6 months from the date of purchase.)

 
No cancellation or change in programme enrolment once the enrolment is successful.
 

Programme Outline

Financial modelling is becoming an increasingly important skill in an economic environment characterised by ever more uncertainty: the ability to use Excel to predict what the financial performance and position of a business or venture might look like in the future, depending on particular assumptions and estimates.

Effective use of logical statements is an essential skill required to build a dynamic and flexible financial model. The ability to lookup particular data items is also important and this course covers a number of different ways of doing this.

On completion of this course, you will have a greater understanding of:
 

  • The use of logical statements (IF/AND/OR) to model conditions
  • The use of lookup functionality (V/H Lookup, Match, Index. Offset) to select particular data

Training Methodology

E-Learning (24/7)

Intended For

Foundation to Intermediate programme intended for practising and non practising accountants

Schedule & Fees

Testimonial

Funding

No funding Available!

Programme Facilitator(s)


Programme Overview

This is an e-learning programme. 
Upon successful registration and payment, you will be notified via email within 7-10 working days on your login ID, password and user instructions to access this programme. 
(The programme is valid for 6 months from the date of purchase.)

 
No cancellation or change in programme enrolment once the enrolment is successful.
 

Programme Outline

Financial modelling is becoming an increasingly important skill in an economic environment characterised by ever more uncertainty: the ability to use Excel to predict what the financial performance and position of a business or venture might look like in the future, depending on particular assumptions and estimates.

Effective use of logical statements is an essential skill required to build a dynamic and flexible financial model. The ability to lookup particular data items is also important and this course covers a number of different ways of doing this.

On completion of this course, you will have a greater understanding of:
 

  • The use of logical statements (IF/AND/OR) to model conditions
  • The use of lookup functionality (V/H Lookup, Match, Index. Offset) to select particular data

Training Methodology

E-Learning (24/7)

Intended For

Foundation to Intermediate programme intended for practising and non practising accountants

Programme Facilitator(s)


No course instances or course instance sessions available.