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
Hila Etzion
  • LEO Lecturer III 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...
Tariq Mughal
  • LEO Lecturer I in Technology & Operations
Professor Mughal’s background is in engineering and applied mathematics. Prior to joining academia, he worked in aerospace industry. He joined...
Kyle Maclean
  • Visiting Assistant Professor
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-...