Plum Solutions
Availability: BOOK NOW
more info

Advanced Financial Modelling in Excel

(PS)-00011

Brisbane

$880.00per person

1 Day, 9:00am - 5:00pm

Public / Open

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.
Scenarios and sensitivity analysis
  • Show multiple scenario outcomes simultaneously with one and two-dimensional Data Tables
  • Using the Scenario Manager

  • Manual scenario building


  • Practical Exercise: At each step during the course, participants build and practice each formula, tool and technique. Record your own macro with buttons, build a pivot table, and create drop-down boxes.

    Practical Financial Modelling
  • Building on the tools and techniques covered, we will learn to apply advanced modelling skills to build complex, yet robust and user-friendly financial models.

  • Tiering Tables
  • Financial Model Critique
  • Factory Rollout Model


  • Practical Exercises: Utilising the tools and techniques covered in the first part of the day, participants will build their own financial model case study, performing stress testing, scenario and sensitivity analysis on their model."
      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 expedite 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"
    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.
    Scenarios and sensitivity analysis
  • Show multiple scenario outcomes simultaneously with one and two-dimensional Data Tables
  • Using the Scenario Manager

  • Manual scenario building


  • Practical Exercise: At each step during the course, participants build and practice each formula, tool and technique. Record your own macro with buttons, build a pivot table, and create drop-down boxes.

    Practical Financial Modelling
  • Building on the tools and techniques covered, we will learn to apply advanced modelling skills to build complex, yet robust and user-friendly financial models.

  • Tiering Tables
  • Financial Model Critique
  • Factory Rollout Model


  • Practical Exercises: Utilising the tools and techniques covered in the first part of the day, participants will build their own financial model case study, performing stress testing, scenario and sensitivity analysis on their model."
      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 expedite 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"

    Plum Solutions

    Plum Solutions delivers training in the following course categories

    • Financial Modeling
    • Financial Services

    Plum Solutions Training Courses and Open Programs in Sydney, Melbourne and Brisbane, Australia.

    Short Courses and In-House Training Programs:

    With Training Courses available in these categories:

    Financial Modelling | Budgeting & Forecasting | Business Cases & Pricing Models | Data Analysis

    Call us to book on 1300 768 368

    Need Approval?