Call Number | 17298 |
---|---|
Day & Time Location |
M 11:00am-12:50pm 510A International Affairs Building |
Points | 0 |
Grading Mode | Pass/Fail |
Approvals Required | Instructor |
Instructor | Kenyon S Saverance |
Type | LABORATORY |
Method of Instruction | In-Person |
Course Description | Prerequisites: SIPA U4010 or equivalent experience This course explores skills needed for sophisticated spreadsheet development and problem solving in Microsoft Excel. Topics include implementing advanced logic using complex formulas, managing complexity with Excel's auditing features, leveraging lookup functions leveraging and calculated references, parsing and cleaning raw data, refining data structure, and constructing and leveraging PivotTables. The course does not focus on specific models or applications, but instead explores general concepts and techniques that can be flexibly applied to different solutions in Excel. The course is open to SIPA students only. Instructor approval is required: students will be waitlisted in SSOL and contacted by the instructor. Part of the Excel at SIPA course series. Deadline to drop this course is one week prior to the start date of the course. A notation of "W" will be assigned if requests to drop are not made by this deadline. |
Web Site | Vergil |
Department | International and Public Affairs |
Enrollment | 26 students (44 max) as of 9:05PM Thursday, March 13, 2025 |
Subject | School of International & Public Affairs |
Number | U4011 |
Section | 001 |
Division | School of International and Public Affairs |
Open To | SIPA |
Campus | Morningside |
Note | Instructor Perm Req; Fall 2023 Course Date: Sep 25 - Oct 30 |
Section key | 20233SIPA4011U001 |