Course description

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.

Enrollment limited to non-Dyson majors. Forbidden overlap: due to an overlap in content, students will not receive credit for both AEM 2830 and AEM 2831.

Prerequisites

AEM 2011 or similar coursework. Students should have intermediate knowledge of MS Excel.

Summer 2024: Online course

Reza Moghimi
Reza Moghimi
Lecturer
Section ID:AEM 2831 001-LEC
Number:1022
Session:Summer 3-week 2
Class dates:June 24-July 12, 2024
Final exam/project due:Friday July 12, 11:59 PM (see Final exams)
Time / room:
Mode of instruction:Online (async)
Credit:3
Grade:Graded only
Instructor:Moghimi, R. (am2393)
Max. enroll:16
Restrictions:Enrollment limited to non-Dyson majors.
Notes:Forbidden overlap: Due to an overlap in content, students will not receive credit for both AEM 2830 and AEM 2831. Student must have intermediate Excel knowledge.
Eligibility:

Rising Seniors

See Eligibility.

To enroll:

See Apply for Online Courses.

See Dates & Deadlines.

See Online Learning FAQs.

This course is open to all registrants, including undergraduates and precollege students.

Tuition & fees:See Tuition for Online Courses