Financial Modelling in Excel (Intermediate)

Melbourne $880.00 AUD per person

Training Course Overview Add to Compare Add to My Development Plan

Training Course ID: (PS)-00001

This course is designed for business professionals who need to explore the practical usage of advanced excel functions in a financial model. By creating your own user-friendly financial model, you will learn totranslatebusiness concepts into a structured format to identify weaknesses and predict future performance.
You will:

Discover how to measure and interpret the performance of your company using Excel modelling
Create your own effective and reliable model and identify weaknesses and predict future performance
Gain an in-depth understanding of how to build a business case
Master key steps to get the most out of Excel functionality to improve your financial modelling
Learn how to 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

Duration: 1 Day 9:00am - 5:00pm
Provider: Plum Solutions
Venue: Level 8, 500 Collins Street, Melbourne
Type: Public / Open

Course content includes:

Model Tools
Choosing between Excel and Access
General Functions
Financial Functions
Other Useful Tools
Modelling Techniques
Rebuilding an inherited model
Bullet-proofing your model
Making a model user-friendly
Final Model Results
Scenarios and Sensitivity Analysis
Presentation of Model Output
The Fine Print

Build a financial model from scratch, or modify and improve an inherited model
Mitigate errors by building in error checks
Prevent incorrect use of your model by protecting worksheets
Validate data entry by setting data entry parameters
Create a navigation page to help users find their way around your model
Create drop-down boxes which enable a model to produce a series of results depending on scenario variable selected
Mitigate liability by providing assumptions
Write instructions for use
Present findings in a concise and meaningful way

Related Training Courses

Provider Terms & Condition

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. With Training Courses available in these categories: