Excel - Formulas & Charts (PM)
Course Excel - Formulas & Charts - (TSDC-3091-F25)
Portfolio Technology
Cost $ 75.00 Per Participant
Prerequisite(s) None
Credits CEU:0.3, CPE:4
Duration
0.5 Day(s)
Modality Instructor Led Classroom Training
Instructor(s) Jeanette Davidson
Class Description
In This Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets and Workbooks.
Course Objectives
Upon successful completion of this course, students will be able to create Intermediate Formulas and Charts using Microsoft Office Excel.
Agenda
1 - PERFORMING CALCULATIONS
Functions
Absolute reference
2 - WORKING WITH FUNCTIONS
Named ranges
Logical functions
3 - WORKING WITH LISTS
Database functions
4 - VISUALIZING DATA WITH CHARTS
Creating and modifying charts
5 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
Creating links
3-D references
Consolidating data
6 - USING LOOKUP FUNCTIONS
Vlookups
Hlookups
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.
Schedule(s)
| Day | Date | Start Time | End Time | Break Time | Contact Hours | Modality | Location | Classroom |
|---|---|---|---|---|---|---|---|---|
| 1 | 8/24/2026 | 1:30 PM | 5:00 PM | 3.5 | ILT | Citywide Training Center | Room 24-8 |