Business Application Development with Visual Basic for Excel

Course Code
TO 515
Hours
2.25 hours
Type
Elective
Offered
  • Fall 20 (A)
  • Fall 21 (B)
  • Winter 21 (B)
  • Winter 22 (B)
Prerequisites
(GMBA or FTMBA or Online or Evening MBA or MAcc or MSCM) and (No credit in TO 415)

Business Application Development with Visual Basic for Excel --- This course demonstrates how to use VBA in Excel to automate repetitive and time consuming tasks, generate interactive reports, manipulate charts, filter databases, and run solver. Examples of specific decision support applications, such as product mix and portfolio optimization are presented. Students will develop advanced technical skills with Visual Basic for Excel, and learn how to utilize VBA to create efficient and user friendly business applications. Specifically, students will learn how to enhance applications created in Excel with customized dialog boxes, user defined functions, event-handling procedures, customized toolbars, and more. The course also introduces general programming concepts such as the use of Variables, If statements, Loops, and assignment statements.

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-...