MBA 614

Download as PDF

Spreadsheet Automation and Modeling

Marriott School of Business

Course Description

Programming in Excel VBA; automating common tasks; retrieving data from web servers; building optimization models and user forms.

When Taught

Fall and Winter

Min

3

Fixed/Max

3

Fixed

3

Fixed

0

Other Prerequisites

Admission to a Marriott School graduate program.

Title

Retieve Data

Learning Outcome

Retrieve data from internet web servers and corporate database servers.

Title

Programming Concepts

Learning Outcome

Understand basic programming concepts such as variables, arrays, procedures, conditions, and control of flow statements.

Title

Programming Technology

Learning Outcome

Apply programming technology to solve unstructured business problems.

Title

Build Forms

Learning Outcome

Build forms for gathering user input.

Title

Automate Procedures

Learning Outcome

Automate repetitive procedures in Excel.