Advanced Financial Modelling in Excel

Canberra

$770.00

Training Course ID: (PS)-10019

Overview: In the ever-changing business environment, being able to accurately model and forecast the volatile economic inputs is a critical skill for business professionals. Build on your existing modelling skills and apply new techniques to better analyse financial data, predict revenues and cost and assess risks to justify business decision in the most time-efficient and effective way.

Training Course Details

Duration
1 Day 9am - 5pm
TypePublic / Open
Provider

Plum Solutions

CPD0
Venue

TBA by Plum Solutions

VersionAdvanced

Outlines

Training Course Outlines:

Course content includes:

  • Financial Modelling Theory and Best Practice
  • Advanced Financial Modelling Techniques
  • Advanced Financial Modelling Tools and Functions
  • Bullet-proofing Your Model
  • Stress testing to deal with uncertainty and risk in Financial Modelling
  • Scenarios and sensitivity analysis
  • Practical Financial Modelling

Outcomes

Training Course Outcomes:

  • Streamline model building by applying best practice functions, tools and techniques
  • Apply commonly used formulas in new and different ways
  • Deal with risk and uncertainty by creating scenarios and performing sensitivity analysis
  • Build stress-tests, what-if and sensitivity analysis into your model by incorporating economic fluctuations
  • Minimise manual labour and automate common tasks by building macros into your models
  • Measure and interpret the performance of your company using Excel modelling
  • Master key steps to get the most out of Excel functionality to improve your financial modelling
  • Learn how to expediate and enhance the decision-making process
  • Maximise your analytical abilities by learning conventional and new approaches of modelling
  • Translate business concepts into logically structured models and formats
  • Select which advanced formulas are appropriate in different situations
  • Perform various advanced scenario modelling techniques

Accreditations / Prerequisites
Course Accreditations:

Course Prerequisites:

The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheets users. It is designed for users who do use (or will use) Excel on a semi-regular basis, and are comfortable with using its basic tools and functions.

At minimum, it is assumed that participants will know how to:

•Navigate confidently in Excel
•Use absolute cell references (e.g. =$A$1)
•Create and use simple formulas
•Link between workbooks
This course builds on students' existing knowledge of Excel tools and functions and incorporates these into a financial model.

Related Courses

Related Courses:

79 visited

People Visited:

79 people visited

BOOK THIS COURSE

Select Dates

The training supplier is currently updating new course schedules, please contact the mytraining.net team to register your interest at team@mytraining.net or please call 02 8998 4940

Add Attendees (Min 1 and Max 10)




Attendees x 0

Add To Cart

Selected Course Date:

Course Attendees:

PRICE / Person:

$770.00