Department of Citywide Administrative Services

Course Excel for Data Analysis I - (CMPD-9659-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

Instructor(s) Elizabeth DiLuzio, Mark Yarish

Class Description

This course will address one of the most significant challenges managers face today: making
sense of the data they already have. Being able to quickly and efficiently summarize and
analyze information is essential to making better business decisions. Using Excel, participants
will practice some of the most effective techniques of summarizing and displaying data to
extract actionable intelligence quickly and accurately.

Objectives:
-  Basic functions
-  Specific functions: Average, Count, Round, If Then, Nested If, Concentrate, PMT, Using Ranges, VLookup and Time and Date functions
-  Specific Excel features: Sorting, Consolidating, Eliminating of Duplicates, multiple sheet references, and Using Basic Pivot Tables

Target Audience: Managers, Supervisors, and Team Leaders involved in data analysis

There is no cost to employees; the agency covers the cost of participation for their employees.

If you require a reasonable accommodation to attend a training, please contact the DCAS Citywide Learning and Development Center at CitywideTrainingCent@dcas.nyc.gov at least 7 days before your training start date.