Advanced Excel Skills with VBA

Course Code
TO 415
Hours
3 hours
Type
Elective
Offered
  • Fall 23
Prerequisites
(BBA Junior or Senior or BusAd Minor) and TO 411

Advanced Excel Skills with VBA --- This course builds on the basic excel skills students learn in TO 411, taking those skills to the next level utilizing VBA for excel. Students learn how to enhance applications created in Excel with customized dialog boxes, user defined functions, event-handling procedures, customized toolbars, and more. The course demonstrates how to use VBA in the context of Excel to automate repetitive and time consuming tasks, generate interactive reports, manipulate data and run solver. The course introduces student to general programming concepts and to business applications of VBA and related Excel macros. Students apply VBA to decision support applications drawn from several business disciplines including operations, finance and marketing. This class includes a large portion of hands-on work.

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