Excel Modelling for Decision Making

The University of Auckland Business School

The University of Auckland Business School

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Who should attend

  • Team Leaders and managers that need to make financial decisions
  • Accountants
  • Finance Business Partners
  • Management Consultants
  • Analysts

About the course

Use Excel to enhance your organisation’s decision making and analysis.

This course uses a case study to work through the methods and Excel modelling best practice used to analyse and make both short-term and long-term financial decisions. Using a hands-on approach, you are equipped with the ability to develop a generic Excel modelling road map for any decision making process.

In preparation for this course, you will have access to the Executive Education online learning platform to look into Net Present Value Rule as part of their pre-work.

Topics covered

This one-day course is designed for people with a basic knowledge of Excel, and focuses on how you can use excel to make fact-based decisions. The course covers the basics of Excel modelling, Excel model design and construction, how to amend and extend models, and methods to check that your model and its output are perfect.

  • Legendary Excel shortcuts to make you amazingly efficient
  • Model design options
  • Generic roadmap for modelling
  • Focusing on the output
  • Identifying data sources and missing information
  • Charting for success
  • Building scenarios

Outcomes

You will:

  • Learn a model roadmap to assist in the construction of any Excel model
  • Tour through some key metrics for short-term and long-term decision making
  • Enhance your Excel modelling knowledge and skills, allowing you to work more effectively and efficiently in Excel
  • Learn how to use your business knowledge to make a decision

Your organisation will:

  • Benefit from an enhancement of the analysis that can be undertaken at the desk
  • Have increased confidence that the models that are constructed are reasonably error-free

Experts

Mary Farmer

Mary Farmer is an experienced finance, modelling and accountancy trainer with a background in investment banking and financial services. Since 2007, Mary has undertaken a variety of training roles, including undergraduate, graduate and professional exam training as well as financial training for...

Videos and materials

Excel Modelling for Decision Making at The University of Auckland Business School

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.


Something went wrong. We're trying to fix this error.

Thank you

Someone from the Coursalytics team will be in touch with you soon.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.