The University of Auckland Business School

Excel Modelling for Decision Making

Available dates

Apr 3, 2020
Auckland, New Zealand
NZD 1195 ≈USD 786
NZD 1195 per day

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with The University of Auckland Business School.

Full disclaimer.

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

Who should attend

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

Trust the 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...

More...

Course reviews

Downloadable materials

Available dates

Apr 3, 2020
Auckland, New Zealand
NZD 1195 ≈USD 786
NZD 1195 per day

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with The University of Auckland Business School.

Full disclaimer.

Not sure which program or school is right for you?

Get advice from our founders