Spring 2024 School of International & Public Affairs U4011 section 001

Advanced Techniques in Excel

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:07PM Tuesday, June 25, 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