Advanced Spreadsheets for IT Applications
MGT 575
Course Description:
Covers the use of Microsoft Excel and the programming language VBA (Visual Basic for Applications) within Excel for obtaining, managing, and processing information. Example areas covered include 1) automatically producing customized mass e-mails and summary reports, 2) updating Excel databases with 100 or more sheets, 3) copying from a user?s workbook to a separate master workbook for analysis and returning solutions, and 4) solving a series of optimization models for various exchange rates. Most of the managerial problems used for illustration involve financial and operations applications. No prior exposure to VBA or any other programming language is required.
2 Credit(s)
Prerequisite(s):
Faculty:
- Larry LeBlanc (View Profile)
Subject Area(s):
- Information Technology
- Operations Management
Program(s):
- MBA
Please Note: Not all courses are scheduled each semester. Complete class schedules are available upon enrollment.
