Business Modeling with Spreadsheets

This course is designed for students who want to learn how to construct and use powerful spreadsheets. Its main purpose is to develop proficiency in quantitative modeling to support effective managerial decision-making. This course is mostly project-oriented with a dual focus on spreadsheet engineering and quantitative modeling of financial applications. The student will develop spreadsheet models to solve financial and other business problems and to aid the user in reaching reasonable and justifiable decisions. Several classic quantitative models will be developed and discussed. The course will introduce and review the fundamental quantitative tools including forecasting, sensitivity analysis, and data analysis using pivot tables.

Fall, Spring, Summer