Advanced Spreadsheet Modeling

Catalog description

This course covers the use of Microsoft Excel and the programming language Visual Basic for Applications (VBA) within Excel for obtaining, managing, and processing information. Example areas covered include (1) automatically producing customized mass emails 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. 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.