Spreadsheet Macros (VBA) for IT Applications

2 credits · Owen Graduate School of Management

Uses the latest version of Microsoft Excel for Windows to demonstrate the power of Visual Basic for Applications (macros) in Excel. The course begins with a one-class coverage of advanced features of Excel. All other classes emphasize the programming language VBA (Visual Basic for Applications) within Excel for obtaining, managing, and processing information. This is a very important tool for supporting managerial decision-making and analysis by automating tasks. Using custom dialog boxes and message boxes to prompt the Excel user on how to manipulate data contained in an Excel worksheets is typical. Example areas covered include 1) automatically producing and sending customized mass emails and summary reports, and 2) manipulating Excel workbooks with 100 or more sheets. Most of the managerial problems used for illustration involve financial and operations applications. Illustrations from actual company projects demonstrate the power and versatility of course concepts. No prior exposure to VBA or any other programming language is required. Prerequisite: MGT 6405 or MGT 6574. [2]