BUS-K507 Intro to Spreadsheet Modeling

• 7 weeks
• 1.5 credits
• Prerequisite(s): MBA Core

In this course we will use spreadsheet modeling to solve business problems. We will show how sophisticated Excel models can be applied to many problems such as those you will face in your internships and ultimate career. In addition to Excel fundamentals, we will learn how optimization tools, as part of the business analytic toolkit, are used to find tools to find the optimal—or near optimal solutions to constrained optimization problems. We also will consider Monte Carlo simulations that allow us to model uncertainty in Excel models. Throughout the course we will show you many features of Excel 2013 that will be useful in your career and MBA classes.