Managerial Spreadsheet Modeling

Catalog description

The goal of this hands-on course is to develop proficiency in quantitative modeling within the environment of Microsoft Excel. Students develop and use spreadsheets to analyze a variety of business problems. The course has two principal components: spreadsheets and models. Spreadsheet topics include principles of good spreadsheet design, the effective presentation of information through spreadsheets (including graphical controls and dashboard design), and advanced Excel features (e.g., conditional formatting, data validation). Modeling topics include the art of finding the appropriate level of modeling detail, sensitivity analysis, and using solver and regression to perform optimization and estimation tasks. (MHA-EL, MPA-TPA)