OPIM 530 Programming in VBA for Excel Select Term:
The objective of this course is to provide the fundamentals necessary to develop VBA programs in EXcel and to teach how to develop decision support tools in Excel that use management science and statistical models for a wide variety of business problems, mostly from operations management and finance. The course assumes no prior programming experience and emphasizes the importance of following a professional style in writing code. Working with ranges, and other Excel objects, developing user forms, error handlings are covered in addition to basic building blocks of VBA programming. To support model development, importing data from databases, working with pivot tables, and automating Solver are also covered in the course. Upon completion of the course, students should be able to develop modest but useful applications of their own.
SU Credits : 1,5
ECTS Credit : 3
Prerequisite : -
Corequisite : -