Support With Excel

Course Code
TO 411
Hours
3 hours
Type
Elective
Offered
  • Fall 20
  • Fall 21
  • Winter 20
  • Winter 21
Prerequisites
No credit in TO 515

Decision Support with Excel --- Spreadsheets are among the most widely used decision support tools in business today, and have advanced to the point of providing powerful, general-purpose functionally. The first half of the course introduces decision support modeling using spreadsheets, including: what-if analysis; financial, statistical, and time/date functions; graphical presentation of data; organizing and extracting information from spreadsheet databases; and cross-tabulation of data. The second half of the course includes importing information into spreadsheets from external sources; goal seeking; one and two way data tables; the use of a solver to find optimal solutions to problems; designing macros to develop semi-automated and fully automated spreadsheet applications; and probabilistic modeling to support risk analysis in the context of spreadsheets. Lecture/demonstrations illustrate the features of spreadsheet software. Lab work involves carrying out hands-on tutorials in a supervised setting, then reinforcing and extending conceptual and operational aspects of the material by doing follow-up cases. Windows-based spread-sheeting software (such as Excel for Windows) is typically studied in the course.

Taught By
Hila Etzion
  • LEO Lecturer IV of Technology and Operations
Dr. Etzion is an Assistant Professor in the Business Information Technology group at the Michigan Business School. Her research focus is on...
Mehmet Begen
  • Visiting Associate Professor of Technology and Operations
Mehmet A. Begen is an associate professor of management science in the Ivey Business School at the Western University. Besides Ivey, he is cross-...