Fall 2023 School of International & Public Affairs U4011 section 001

Advanced Techniques in Excel

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 1:06PM Saturday, May 11, 2024
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