Working with Excel Through Formulas and Scripts
QAC 151
Spring 2027
| 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. You will learn how to use dynamic arrays in formulas, how to import and transform data using PowerQuery, and how to automate operations using JavaScript and VBA. |
|
| 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) |
| 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 | | |
| | GRAD: X | SR non-major: 5 | JR non-major: 5 | SO: 5 | FR: 4 |
|
|