Accounting & Finance

Accounting & Finance Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Business Management

Discover business management training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Business Process Improvement

Business Process Improvement Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Legal & Compliance

Legal & Compliance Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Marketing & Advertising

Discover marketing & digital marketing training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Procurement & Purchasing

Procurement & Purchasing Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart;

view coursesgroup bookings

Real Estate Management

Real Estate Management Training Courses Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart Building Services | Property Development | Property Asset Management | Retail Property Management | Operations and Facilities Management | Property Investment

view coursesgroup bookings

Sales Training

Discover sales training courses and in-class open programs in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Supply Chain Logistics

Supply Chain Logistic Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Workplace Health & Safety

Workplace Health & Safety Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

IT Technical & Computer

Discover IT and computer training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Personal Development

Personal Development Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart;

view coursesgroup bookings

Training & Facilitation

Training & Facilitation Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Training by Industry

Industry Specific Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

First Aid Training

Discover first aid training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Certificates & Diploma

Certificates & Diploma Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

Communication Skills

Discover communication skills training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Customer Service

Discover customer service training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Government / Public Sector

Government / Public SectorTraining Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

TOP CATEGORIES

Government

Human Resources

Discover human resources training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Leadership Development

Discover leadership development training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

Management Training

Discover management training courses and in-class open programmes in Australia. Select your course from a range of leading providers.

view coursesgroup bookings

People Development

People Development Training Courses & In-Class In-house Open Programs Australia | Sydney Melbourne Brisbane Perth Adelaide Canberra Darwin Hobart

view coursesgroup bookings

ACT - Australian Capital Territory

Book all your Corporate & Government Training Courses in Canberra ACT Australia | Short In-house In-Class Room Open Programs Software

view coursesgroup bookings

TOP CATEGORIES

Canberra

NSW - New South Wales

Book all your Corporate & Government Training Courses in New South Wales NSW Australia | Short Course In-house In-Class Room Open Programs

view coursesgroup bookings

NT - Northern Territory

Book all your Corporate & Government Training Courses in the Northern Territory, NT Australia

view coursesgroup bookings

TOP CATEGORIES

Darwin

QLD - Queensland

Book all your Corporate & Government Training Courses in Queensland, QLD Australia | Short Course In-house In-Class Room Open Programs

view coursesgroup bookings

SA - South Australia

Training Reservations for Training Courses, Development Programs, Software Programs in South Australia

view coursesgroup bookings

TAS - Tasmania

Training Reservations for Training Courses, Development Programs, Software in Tasmania, Australia

view coursesgroup bookings

TOP CATEGORIES

Hobart

VIC - Victoria

Corporate & Government Training Courses in Victoria (VIC) Australia | Short Course In-house In-Class Room Open Programs

view coursesgroup bookings

WA - Western Australia

Book all your Corporate & Government Training Courses in Western Australia | Short Course In-house In-Class Room Open Programs

view coursesgroup bookings

Auckland

Training Reservations for Training Courses, Development Programs, Software Training, Safety & Compliance Training Programs located in Auckland, New Zealand

view coursesgroup bookings

Christchurch

Training Courses, Development Programs, Software Training, Safety & Compliance Training Programs located in Christchurch, New Zealand

view coursesgroup bookings

Dunedin

Training Courses and Development Programs, Software Training, Safety & Compliance Training Programs located in Dunedin, New Zealand

view coursesgroup bookings

Hamilton

Training Courses and Development Programs, Software Training, Safety & Compliance Training Programs located in Hamilton, New Zealand

view coursesgroup bookings

Palmerston North

Training Courses and Development Programs, Software Training, Safety & Compliance Training Programs located in Palmerston North, New Zealand

view coursesgroup bookings

Wellington

Training Reservations for Training Courses, Development Programs, Software Training, Safety & Compliance Training Programs located in Wellington, New Zealand

view coursesgroup bookings
Plum Solutions
Availability: BOOK NOW
more info

Advanced Financial Modelling in Excel

(PS)-00012

Melbourne

$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.
    Financial Modelling Theory and Best Practice
  • Overview of best practice financial modelling techniques
  • Model planning structure and steps in building your model
  • The technical, design, business and industry knowledge required for financial modelling
  • Selecting the formula or tool which is most appropriate for each modelling situation
  • Attributes of a good financial model
  • How long should a formula be?
  • Deciding when to break a complex formula in several steps to maintain transparency and allowing ease of model auditing


  • Advanced Financial Modelling Techniques
  • Maintaining model integrity and avoiding Excel errors
  • Rebuilding an inherited model
  • Building self-balancing error checks
  • Correcting and suppressing errors
  • Fixing circular references


  • Advanced Financial Modelling Tools and Functions
  • Pros and cons of using array functions
  • Useful functions in financial modelling such as INDEX, MATCH, CHOOSE , OFFSET, LOOKUP and TRANSPOSE

  • Nesting formulas
  • Using aggregation and array functions to perform complex conditional calculations
  • Learn how to have Excel automate variance analysis using complex conditional formatting
  • Automate your financial model for the user with Macros. Recording and modifying VBA code and creating macro buttons

  • Pivot tables – summarise, dissect and analyse large amounts of data
  • Shortcuts for data manipulation in Excel


  • Bullet-proofing Your Model
  • Protect your model so that it can be used by anyone with a limited use of Excel
  • Locking and protecting cells
  • Restriction incorrect data entry with data validations
  • Creating error validation messages
  • Use of form controls such as spin buttons and combo boxes


  • Stress testing to deal with uncertainty and risk in Financial Modelling
  • Economic inputs to model and modelling fluctuations in external factors
  • Use of stress testing to validate your underlying assumptions and risk calculations

  • Advanced What-if analysis
  • Importance of assumptions when assessing risk


  • 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 Critque
  • 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 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"
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.
    Financial Modelling Theory and Best Practice
  • Overview of best practice financial modelling techniques
  • Model planning structure and steps in building your model
  • The technical, design, business and industry knowledge required for financial modelling
  • Selecting the formula or tool which is most appropriate for each modelling situation
  • Attributes of a good financial model
  • How long should a formula be?
  • Deciding when to break a complex formula in several steps to maintain transparency and allowing ease of model auditing


  • Advanced Financial Modelling Techniques
  • Maintaining model integrity and avoiding Excel errors
  • Rebuilding an inherited model
  • Building self-balancing error checks
  • Correcting and suppressing errors
  • Fixing circular references


  • Advanced Financial Modelling Tools and Functions
  • Pros and cons of using array functions
  • Useful functions in financial modelling such as INDEX, MATCH, CHOOSE , OFFSET, LOOKUP and TRANSPOSE

  • Nesting formulas
  • Using aggregation and array functions to perform complex conditional calculations
  • Learn how to have Excel automate variance analysis using complex conditional formatting
  • Automate your financial model for the user with Macros. Recording and modifying VBA code and creating macro buttons

  • Pivot tables – summarise, dissect and analyse large amounts of data
  • Shortcuts for data manipulation in Excel


  • Bullet-proofing Your Model
  • Protect your model so that it can be used by anyone with a limited use of Excel
  • Locking and protecting cells
  • Restriction incorrect data entry with data validations
  • Creating error validation messages
  • Use of form controls such as spin buttons and combo boxes


  • Stress testing to deal with uncertainty and risk in Financial Modelling
  • Economic inputs to model and modelling fluctuations in external factors
  • Use of stress testing to validate your underlying assumptions and risk calculations

  • Advanced What-if analysis
  • Importance of assumptions when assessing risk


  • 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 Critque
  • 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 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"

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?