Department of Citywide Administrative Services

Course Excel for Data Analysis III - (CMPD-8247-SU25)

Portfolio Management & Supervision

Cost $ 250.00 Per Participant

Prerequisite(s) None

Credits CEU:0.6, CPE:8, PDC:6

Modality Instructor Led Classroom Training

Classroom Room 24-8

Address 1 Centre Street, 24th floor south, NY, NY 10007.

Instructor(s) Elizabeth DiLuzio, Ian Duffee

Class Description

A one-day workshop that builds upon the foundational skills acquired in levels I and II, focusing on advanced data cleaning, processing, and visualization techniques. This course dives deeper into sophisticated uses of PivotTables, advanced data visualization strategies, and complex functions and formulas in Microsoft Excel. Participants will further explore joins, logic functions, and other advanced Excel features. Emphasizing best practices, this workshop enables students to effectively document and present their work. Collaborating in small teams, attendees will refine and address more intricate analytical questions, culminating in a data story presentation at the end of class, where they'll receive insightful feedback. 

Goals:

During the course of this training, the instructors will: 

? Reinforce and practice best practices in exploratory data analysis 

? Demonstrate advanced techniques with Microsoft Excel for data analysis 

? Reinforce problem ideation and data visualization skills introduced in levels I and II 

? Practice presenting true and compelling data stories to peers 

? Cultivate an attitude of curiosity to foster a culture of data-driven inquiry 

Key Takeaways: 

At the conclusion of the training, participants will be: 

? Experienced in the key steps of exploratory data analysis with Microsoft Excel 

? Familiar with the techniques of advanced data analysis with Microsoft Excel 

? Practiced presenting analytical findings and describing the key steps in their analysis to their peers 

? Better informed about how data can be leveraged for operational awareness and program success 

Target audience:

Managers, Supervisors, and Team Leaders involved in data analysis