Support With Excel

Course Code
TO 411
Hours
3 hours
Type
Elective
Offered
  • Fall 18
  • Fall 19
  • Winter 18
  • Winter 19
  • Winter 20
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
Kyle Maclean
  • Visiting Assistant Professor
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...