0 item(s) $0.00 AUD + GST

Financial Modelling Workshop

Date: Thursday, 23 February 2017 - 9:00am - Friday, 24 February 2017 - 5:00pm

Location: Kuala Lumpur

Duration: 2 Days

Day 1

Specifically designed for finance professionals who need to take their Excel skills to the next level, this intensive full day course focusses on the technical Excel skills required in everyday Finance roles.  This very practical course covers everything you need to perform your job and nothing you don’t!

Day 2

This course is designed for business professionals who need to explore the practical usage of advanced excel functions in a financial model. By creating your own user-friendly financial model, you will learn to translate business concepts into a structured format to identify weaknesses and predict future performance.

Learning Objectives

During the course, participants will create their own financial model to take away and use for future reference. You will learn how to design and create a user-friendly model which can then be used by anyone with limited knowledge of Excel.

You will learn how to:

  1. Build a financial model from scratch, or modify and improve an inherited model
  2. Select the most appropriate formula to achieve the desired outcome
  3. Identify common errors in modelling & mitigate errors by building in error checks
  4. Prevent incorrect use of your model by protecting worksheets
  5. Validate data entry by setting data entry parameters
  6. Develop manual scenario selection 
  7. Mitigate liability by providing assumptions
  8. Gain an in-depth understanding of how to build a business case
  9. Communicate the results of your model clearly and concisely

This course builds on students' existing knowledge of Excel tools and functions and incorporates these into a financial model.

This course is being hosted by an external provider.  Please email info@plumsolutions.com.au for further details.