Support

Advanced Financial Modelling in Excel

6 sessions available starting from $990.00

Subject: Finance

Ages: All ages

Skill level: Advanced

Course Info

1 Day Workshop

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 decisions in the most time-efficient and effective way.

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

At minimum, it is assumed that participants will know how to:
• Navigate confidently...

see more

Course Info

1 Day Workshop

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 decisions in the most time-efficient and effective way.

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

At minimum, it is assumed that participants will know how to:
• Navigate confidently in Excel
• Use absolute cell references
• Create and use Excel functions on a regular basis
This course builds on students' advanced knowledge of Excel tools and functions and incorporates these into complex and dynamic financial models.

Software used
Excel 2007 or 2003

Learning Objectives
Short-cuts and techniques to build a financial model in less time
Become super-efficient in Excel through intensive use of keyboard shortcuts and best practices to efficiently build an effective and robust model.

Experience designing solutions to real-world examples
Create a financial model based on real-world financial modelling challenges. Incorporate current economic uncertainties into the model in order to take more calculated risks and make more informed business decisions.

Analytical thought on fluctuating economic assumptions in financial modelling
Identify correct economic inputs to model and deal with fluctuations. Quantify uncertainty in forecasting models with stress-testing, what-if analysis and risk analysis techniques.

Knowledge on how to deal with uncertainty and risk in financial modelling
Explore the several different ways to perform scenario and sensitivity analysis in Excel and learn to model in detail the complex but most commonly used methods of showing scenarios using a combination of formulas and drop-down boxes.

In addition, you will learn how to:

• 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

see less

Choose from 6 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, Vic
    8/500 Collins St, Melbourne VIC 3000, Australia
    Melbourne, VIC 3000

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Saxon's Training Facility, Sydney
    10/10 Barrack St, Sydney NSW 2000, Australia
    Sydney, NSW 2000

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Brisbane, Qld
    11/300 Adelaide St, Brisbane QLD 4000, Australia
    Brisbane, QLD 4000

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne
    8/500 Collins St, Melbourne VIC 3000, Australia
    Melbourne, VIC 3000

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Sydney
    10/10 Barrack St, Sydney NSW 2000, Australia
    Sydney, NSW 2000

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Saxon's Training Facility, Brisbane
    Brisbane, QLD 4000

Price: $990.00




My Other Listings

Advanced Dashboards in Excel
Advanced Dashboards in Excel
0 sessions available
Financial Modelling in Excel
Financial Modelling in Excel
6 sessions available starting from $990.00
Implementing Cost Reduction Strategies for Managers
Implementing Cost Reduction Strategies for Managers
0 sessions available

see all listings »


Found In