Working with Excel and VBA
QAC 151
Spring 2026
| Section:
01
|
Many of us know Excel for its spreadsheets: a quick and easy way to store some information, share it, and maybe make some charts. The goal of this course is to show you the more advanced features of Excel. We will write code in Visual Basic for Applications (VBA), learn how to import data from external databases and Web-based resources, create custom menus to interact with a user, and examine how Excel can be used in business decision making. |
|
| Credit: .5 |
Gen Ed Area Dept:
NSM QAC, SBS QAC |
| Course Format: Laboratory Course | Grading Mode: Student Option |
| Level: UGRD |
Prerequisites: None |
|
Fulfills a Requirement for: (Informatics and Modeling Minor) |
|
Past Enrollment Probability: Less than 50% |
| SECTION 01 - 3rd Quarter | | Special Attributes: CQC |
Major Readings: Wesleyan RJ Julia Bookstore
Michael Alexander, Richard Kusleika, and John Walkenbach. Excel 2019 Bible. John Wiley and Sons. 2019
https://onesearch.wesleyan.edu/permalink/01CTW_WU/1nfr5mf/alma9932445863203768
|
Examinations and Assignments:
This course will have weekly homework assignments and a final project. The book for the course is available online through the Wesleyan library. Starting with week 2, you must come to class prepared and be familiar with the readings. |
Additional Requirements and/or Comments:
If you are considering taking this course, you must be sufficiently comfortable finding your way around Excel commands and menus. As a review, please familiarize yourself with the materials from Chapters 1 and 2 of the Excel Formulas and Functions for Dummies, available online through the Wesleyan Library:
Bluttman, Ken. Excel Formulas and Functions for Dummies. John Wiley and Sons, 2022.
https://onesearch.wesleyan.edu/permalink/01CTW_WU/1nfr5mf/alma9933346036203768 |
| Instructor(s): Oleinikov,Pavel V Times: .M..... 07:10PM-10:00PM; Location: TBA |
| Total Enrollment Limit: 19 | | SR major: 0 | JR major: 0 | | |
| Seats Available: 19 | GRAD: X | SR non-major: 5 | JR non-major: 5 | SO: 5 | FR: 4 |
| Drop/Add Enrollment Requests | | | | | |
| Total Submitted Requests: 0 | 1st Ranked: 0 | 2nd Ranked: 0 | 3rd Ranked: 0 | 4th Ranked: 0 | Unranked: 0 |
|
|