Alt Text

Get in touch

Would you like to discuss our training courses in more detail?
Call +61 2 8006 1728
or email us today.

Download Brochure
Course Dates & Pricing

Financial Modelling and Analysis Masterclass

This course has been designed for business and corporate analysts who wish to develop their data analysis, forecasting, charting and data presentation skills.

In this hands-on two-day course you will develop a multi-divisional forecasting and reporting model. With our structured approach, you will learn how to develop more effective and robust models, in less time and with greater accuracy and transparency. You will build your skills with practical exercises and example files, and will take away a comprehensive course book.

Who should attend?

  • Business and commercial analysts
  • Business planners and forecasters
  • Finance managers and financial controllers
  • Commercial managers

Why would I choose this course?

  • Develop financial models and analysis in a controlled, structured and transparent way
  • Learn and apply best practice modelling principles and techniques
  • Develop models for data analysis, forecasting and reporting
  • Learn more about what Excel can do for you, as well as useful keyboard shortcuts
  • Model multi-divisional businesses for greater efficiency
  • Create flexible dashboard/management reports
  • Learn how to analyse large data sets using pivot tables
  • Increase effectiveness and efficiency of models whilst reducing errors

What skills do I need to do the course?

  • Intermediate Excel skills
  • At least one–five years of relevant work experience

Presenter is skilful and is knowledgeable in his area of expertise. Explanations were clear and to the point.

Royal Bank of Canada,
Analyst

Overall, a very well presented and practical course which will provide some significant benefits for our organisation.

Capral Ltd,
Commercial manager

The presentation materials were clear and concise. They are easy to follow and will be a useful future reference.

Standard Chartered PLC,
Analyst

What will I learn from this course?

Planning

Learn how to apply a managed model development process:

  • Define the aims of a financial model or analysis
  • Find out why it’s essential to follow a defined development process approach when building financial models or analysis
  • Understand the six stages of development
  • Learn how to incorporate stakeholders’ requirements into financial models
  • Control inputs using data validation and combo boxes

Best practice

Use best-practice standards in your financial models:

  • Find out what ‘best practice’ is and why it is important
  • Learn the 10 golden rules for best practice modelling
  • Learn Excel shortcuts and function tips

Model construction

Learn professional and efficient model construction set-up:

  • Learn correct file management and naming conventions
  • Learn custom number and date formats, conditional formatting, and styles
  • Define a corporate colour palette
  • Implement model checks
  • Model timing flags and schedule events

Flexible forecasts

Develop flexible forecasts:

  • Use a scenario manager to create scalable and flexible forecasts
  • Incorporate and apply sensitivity analysis
  • Apply escalations and indexation
  • Use data tables for scenario and sensitivity analysis

Data analysis

Analyse data using pivot tables:

  • Manipulate large volumes of data using pivot tables
  • Tailor pivot tables and create pivot charts
  • Link pivot tables to management dashboards

Data processing

Data processing and analysis techniques:

  • Clean base data using data processing techniques
  • Learn data mapping techniques to assist with data analysis
  • Learn data analysis functions and techniques

Management reports

Create management reports and dashboards:

  • Find out what management reports and dashboards are
  • Create dynamic reports and dashboards
  • Use dashboard reports for continuous analysis
  • Increase effectiveness using conditional formatting and traffic lights

Advanced charting

Create powerful and accurate visual material:

  • Optimise data layout for more efficient charting
  • Learn chart formatting techniques and how to use chart templates
  • Develop dynamic and interactive charts
  • Create step charts

Testing and handover

Ensure quality, reduce errors and manage risk:

  • Learn quality control techniques, including final testing and peer review
  • Manage handover and issuing models to third parties
  • Learn about including disclaimers in models

Organisations we have trained

Portfolio Image
Alinta Energy
training
Portfolio Image
Capral
training
Portfolio Image
Louis Dreyfus
training
Portfolio Image
Standard Chartered
training

In-house and group courses

We can deliver any of our courses anywhere in the world. We can either travel to you or host the course in the most convenient place for your team.

Why should you consider in-house training?

  • Customised content – we can tailor the agenda to suit your exact needs and even incorporate data from your business into the practical exercises.
  • Locally hosted – we travel to you and present either locally or at your premises, reducing the time you spend out of the office.
  • Group size – as in-house courses are often smaller groups, there is even more one-on-one time with the trainer.
  • Costs saving – an in-house course is delivered for a fixed fee regardless of the number attending, and you benefit from added savings on travel, accommodation and time.

The in-house option is ideal for teams of six or more. To talk about whether an in-house course is right for your business, please contact John Stroud on john.stroud@digitadvisory.com or +61 2 8006 1728.