This course is designed for hospitality managers
who know a little Excel, and who want to learn how to use it as a
valuable business modeling tool. The course consists of lectures,
explanations of a significant number of business models, in-class
exercises and model creation, and opportunities for the participants
to discuss their business modeling experiences, to show models they
have developed, and to seek advice for models they wish to develop.
Models covered in class will mostly be operations-oriented, though
examples of financial and marketing models will also be included.
Participants are provided with take-home videos showing the
step-by-step development of the models presented in the course. The
course is targeted primarily at those who want to be able to develop
models themselves, though it would also be useful to those who want
to direct the development of models. A basic knowledge of Excel is
very desirable, though not essential, since a pre-course exercise
can serve as a primer to the basics of Excel.
Key Benefits:
Excel is an exceedingly powerful tool for
developing business models. This class will show you how to take
ideas and create useful business models in Excel.
Topics Include:
• • Formulas: the building blocks of Excel models
• Building robust Excel models
• Building user-friendliness into Excel models
• Excel model examples from operations, finance and marketing
• Planning and building your own Excel models
• Taking Excel to the next level using macros
• Show-and-tell opportunities
• Stump-the-modeler session
• How-do-I…?
• Take-home videos showing all the steps in building the Excel
models covered in the course
Faculty
Gary M. Thompson, Ph.D., Professor:
Singapore (July 28-30, 2008)
