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)
  • Fall 20 (A)
  • Winter 18 (A)
  • Winter 19 (B)
  • Winter 20 (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 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...