Support With Excel

Course Code
TO 411
Hours
3 hours
Type
Elective
Offered
  • Fall 21
  • Fall 22
  • Winter 21
  • Winter 22
Prerequisites
[(BBA Sophomore or Junior or Senior) or Ross Minors or MM] and (No credit in TO 512)

Excel Skills for Business --- 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
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-...
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...