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.


Advanced Financial Modelling in Excel

6 sessions available starting from $990.00

Subject: Finance

Ages: All ages

Skill level: Advanced

Course Info

1 Day Workshop

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.

Prerequisites
The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheet users. It is designed for users who do use Excel on a regular basis, and are comfortable with using its tools and functions.

At minimum, it is assumed that participants will know how to:
• Navigate confidently...

see more

Course Info

1 Day Workshop

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.

Prerequisites
The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheet users. It is designed for users who do use Excel on a regular basis, and are comfortable with using its tools and functions.

At minimum, it is assumed that participants will know how to:
• Navigate confidently in Excel
• Use absolute cell references
• Create and use Excel functions on a regular basis
This course builds on students' advanced knowledge of Excel tools and functions and incorporates these into complex and dynamic financial models.

Software used
Excel 2007 or 2003

Learning Objectives
Short-cuts and techniques to build a financial model in less time
Become super-efficient in Excel through intensive use of keyboard shortcuts and best practices to efficiently build an effective and robust model.

Experience designing solutions to real-world examples
Create a financial model based on real-world financial modelling challenges. Incorporate current economic uncertainties into the model in order to take more calculated risks and make more informed business decisions.

Analytical thought on fluctuating economic assumptions in financial modelling
Identify correct economic inputs to model and deal with fluctuations. Quantify uncertainty in forecasting models with stress-testing, what-if analysis and risk analysis techniques.

Knowledge on how to deal with uncertainty and risk in financial modelling
Explore the several different ways to perform scenario and sensitivity analysis in Excel and learn to model in detail the complex but most commonly used methods of showing scenarios using a combination of formulas and drop-down boxes.

In addition, 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

see less

Choose from 6 available sessions:

When

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

Where

  • Melbourne, Vic
    8/500 Collins St, Melbourne VIC 3000, Australia
    Melbourne, VIC 3000

Price: $990.00

When

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

Where

  • Saxon's Training Facility, Sydney
    10/10 Barrack St, Sydney NSW 2000, Australia
    Sydney, NSW 2000

Price: $990.00

When

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

Where

  • Brisbane, Qld
    11/300 Adelaide St, Brisbane QLD 4000, Australia
    Brisbane, QLD 4000

Price: $990.00

When

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

Where

  • Melbourne
    8/500 Collins St, Melbourne VIC 3000, Australia
    Melbourne, VIC 3000

Price: $990.00

When

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

Where

  • Sydney
    10/10 Barrack St, Sydney NSW 2000, Australia
    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

Advanced Dashboards in Excel
Advanced Dashboards in Excel
0 sessions available
Essential Excel for Business Administration
Essential Excel for Business Administration
0 sessions available
Essential Dashboards in Excel
Essential Dashboards in Excel
0 sessions available

see all listings »


Found In