Business Application Development with Visual Basic for Excel

Course Code
TO 515
Hours
2.25 hours
Type
Elective
Offered
  • Fall 18 (A)
  • Fall 18 (B)
  • Fall 19 (A)
  • Fall 19 (B)
  • Winter 18 (A)
  • Winter 19 (B)
Prerequisites
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 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...
Mehmet Begen
  • Visiting Associate Professor
Mehmet A. Begen is an associate professor of management science in the Ivey Business School at the Western University. Besides Ivey, he is cross-...