AEM 2831 - Excel VBA Programming for Non-Dyson

Winter, Summer. 3 credits. Letter grades only.

Forbidden Overlap: due to an overlap in content, students will not receive credit for both AEM 2830 and AEM 2831.
Not open to: Dyson students.

R. Moghimi.

This course is an introduction to programming with Excel Visual Basic for Applications (VBA) for students aiming to enter the world of business analytics. Using business applied cases students will increase decision making efficiency and productivity through a detailed understanding of VBA programming languages.

Outcome 1: Utilize VBA, a strong tool that adds a great deal of functionality to Excel.

Outcome 2: Develop algorithmic thinking.

Outcome 3: Recognize Basic Data Structures.

Outcome 4: Apply conditional branching and looping.

Outcome 5: Create procedures and functions.

Outcome 6: Develop skills in building models to solve real-world business problems.

Outcome 7: Produce an Excel VBA solution for a business application.