Business Application Development with Visual Basic for Excel
- Fall 20 (A)
- Fall 21 (B)
- Winter 20 (B)
- Winter 21 (B)
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.