Advanced Excel Skills with VBA

Course Code
TO 415

3 hours
(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.