Business Analytics with Excel: Elementary to Advanced

The purpose of this course is to expose you to a variety of problems that can be solved using management science methods and modelled in Excel. In this course, we start from the basics of spreadsheet design and work our way up to broader mathematical optimization modelling. Many airlines, banks, and technology companies could not operate today as they do without the skills and techniques taught in this course. In this first module, we begin by introducing a relatively simple example of a mathematical model which we will use as our platform to build off of for more complicated applications later in the course.

We are now ready to introduce more complexity to our spreadsheet models. Since everyone comes from different Excel backgrounds, we will review some basic functions and features as well as more advanced techniques. This module covers more of the modelling process and includes some of the less-well known, but particularly helpful, Excel functions and tools that are available. Remember though that this course's objective is not to be a "how-to" of Excel. Instead, the focus and intent is to use these features to provide insights into real business problems.

In this module the modeling concept of estimating relationships between variables by curve fitting, or regression analysis, is used to solve realistic business problems. Different regression curves are introduced and a mathematical analysis of which curve is best to help defend the model is presented. This allows not only an understanding of the techniques of modelling but also the rational behind which model to use.

In this module we introduce spreadsheet optimization, one of the most powerful and flexible methods of quantitative analysis. The specific type of optimization presented here is linear programming (LP) which is used in all types of organizations to solve a wide variety of problems. As you will see through the examples presented in this course, LP is used in problems of labor scheduling, inventory management, advertising, finance, transportation, staffing, and many others. The goal of this module is to introduce you to the basic elements of LP, the types of problems it can solve, and how to model an LP problem in excel.