Support

Financial Modelling in Excel

6 sessions available starting from $990.00

Subject: Finance

Ages: All ages

Skill level: Intermediate, Advanced

Course Info

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 to translate business 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...

see more

Course Info

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 to translate business 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

Prerequisites
Students are expected to be reasonably regular Excel users, and should be comfortable with simple formulas and linking between workbooks.

Software used

Workstations are provided. The course is demonstrated using Microsoft Excel 2007, but students can use Excel 2003 if they prefer.

Learning Objectives

During the course, participants will create their own financial model to take away and use for future reference. You will learn how to design and create a user-friendly model which can then be used by anyone with limited knowledge of excel.

You will learn how to:

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

see less

Choose from 6 available sessions:

When

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

Where

  • Saxon's Training Facility, Melbourne
    Melbourne, VIC 3000

Price: $990.00

When

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

Where

  • Saxon's Training Venue, Sydney
    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 Qld
    Brisbane, QLD 4000

Price: $990.00

When

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

Where

  • Melbourne
    Melbourne, VIC 3000

Price: $990.00

When

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

Where

  • Sydney
    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

Data Analysis & Power Pivot - Chandoo Masterclass
Data Analysis & Power Pivot - Chandoo Masterclass
0 sessions available
Essential Excel for Finance
Essential Excel for Finance
0 sessions available
Advanced Dashboards in Excel
Advanced Dashboards in Excel
0 sessions available

see all listings ยป


Found In