Excel for Data Analysis II
Course Excel for Data Analysis II - (CMPD-4317-F24)
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
Class Description
A one-day class reinforcing the skills necessary to clean, process, and visualize data, as well
as introducing advanced skills with PivotTables, data visualization, functions, and formulas
including joins, and logic functions in Microsoft Excel. This class reinforces the problem
ideation and process mapping skills taught in “Developing the Data-Driven Mindset” and
“Data Analytics for Managers”, as well as best practices for documenting and visualizing
work from “Excel For Data Analysis I”. Working collaboratively in small groups, participants
develop an analytical question they explore throughout the class, presenting their data story
at the end of class for constructive feedback.
Objectives:
• Reinforce and practice best practices in exploratory data analysis
• Demonstrate advanced techniques with Microsoft Excel for data analysis
• Reinforce brainstorming, problem ideation, and process mapping skills introduced in
previous classes
• Practice presenting true and compelling data stories to peers
• Cultivate an attitude of curiosity to foster a culture of data-driven inquiry
Target Audience: Managers, Supervisors, and Team Leaders involved in data analysis
Schedule(s)
| Day | Day Type | Date | Start Time | End Time | Break Time | Contact Hours | Modality | Location |
|---|---|---|---|---|---|---|---|---|
| 1 | Full | 1/8/2025 | 9:00 AM | 5:00 PM | 12:00 PM - 1:00 PM | 7 | ILT | Citywide Training Center |