Call Number | 11238 |
---|---|
Day & Time Location |
M 11:00am-12:50pm 510A International Affairs Building |
Points | 0 |
Grading Mode | Pass/Fail |
Approvals Required | None |
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 | 29 students (44 max) as of 1:08PM Monday, May 13, 2024 |
Subject | School of International & Public Affairs |
Number | U4011 |
Section | 001 |
Division | School of International and Public Affairs |
Open To | SIPA |
Campus | Morningside |
Note | Spring 2024 Course Dates: Jan 29 - Mar 4 |
Section key | 20241SIPA4011U001 |