Prev Page

Excel for Data Analysis I

ILT
Apply Now

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

Classroom Room 24-8

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

Instructor(s) Elizabeth DiLuzio

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

Schedule(s)

Day Day Type Date Start Time End Time Break Time Contact Hours Modality Location
1 Full 4/30/2025 9:00 AM 5:00 PM 12:00 PM - 1:00 PM 7 ILT Citywide Training Center
Prev Page