Good Modelling Practices in Microsoft Excel

Kyle Maclean; Lauren E. Cipriano; Gregory S. Zaric

Product #:9B16E012

Supplier:Ivey

Discipline:Management Science

Setting:2016

Details:Note (PDF) • 19 pages • 2016-06-30

Subjects:

Your Price:

$9.71

Purchase this material with a free Educator Account and enjoy more benefits:

Free Educator Copy
Free Teaching Notes
Build your coursepack
Discounted academic price

The purpose of this note is to illustrate the use of good modelling practices in Microsoft Excel. An effective spreadsheet model can be a valuable decision-making tool for businesses wanting to improve or expand their operations. To do so, a model must provide information relevant to the decision maker.

Learning Objectives

Upon completion of this note, students will be able to:

Clearly state inputs and assumptions;
Separate model inputs from analysis;
Reliably perform analyses; and
Create a spreadsheet designed to enable understanding and use of the model by other users.