Course Detail
Units:
1.5
Course Components:
Lecture
Enrollment Information
Enrollment Requirement:
Prerequisites: Masters status in the School of Business OR Instructor Consent.
Description
This class is a continuation of OIS 6500 and therefore explores more advanced Excel applications using VBA. Topics will include arrays in VBA; worksheets and workbooks objects; file and folder operations; event procedures; ActiveX data objects and SQL, web queries in Excel, and Solver and PivotTable automation.