Department of Citywide Administrative Services

Course Excel for Office 365, Part 3 - (TSDC-3086-F24)

Portfolio Technology

Cost $ 150.00 Per Participant

Prerequisite(s) None

Credits CEU:0.6, CPE:8

Modality Instructor Led Classroom Training

Classroom Room 24-8

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

Instructor(s) Jeanette Davidson

Class Description

This course builds off the foundational and intermediate knowledge presented in Excel for Office 365 Part 1 and 2. This interactive class will help you get the most out of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn how to get Excel to do the hard work for you, the more you will be able to focus on getting the answers you need from the vast amounts of data your organization generates.

Objectives:

• Work with multiple worksheets and workbooks
• Perform calculations
• Share and protect workbooks
• Automate workbook functionality
• Use the Lookup function and formula auditing
• Forecast data
• Create Sparkline and map data

Target Audience: Employees who already have a foundational knowledge of Excel and want to take advantage of some of the higher-level Excel functionality to analyze and present data.