Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.


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

Analysing and Interpreting Financial Statements
Analysing and Interpreting Financial Statements
0 sessions available
Data Analysis & Power Pivot - Chandoo Masterclass
Data Analysis & Power Pivot - Chandoo Masterclass
0 sessions available
Advanced Excel & Dashboards - Chandoo Masterclass
Advanced Excel & Dashboards - Chandoo Masterclass
0 sessions available

see all listings ยป


Found In