Excel: Working with Functions and Formulas (Headquarters)
Upcoming sessions
To register, you will be prompted to sign in.
May 12, 2025
Virtual
9:00 am to 12:00 pm (ET)
French
August 06, 2025
Virtual
9:00 am to 12:00 pm (ET)
French
View more details
Overview
Delivery method
Classroom
Virtual Classroom
Duration
3 hours
Audience
Employees
Description
The purpose of this course at the intermediate/advanced level is to help participants learn how to manage functions and formulas, identify errors, correct them and link data using MS Excel 2010.
Learning Objectives
Upon completion of this course, participants will be able to:
- use formulas with MS Excel 2010
- browse, insert and use functions
- use advanced functions (VLOOKUP, HLOOKUP) and logical function (IF)
- reference cells
- correct error values
- work with array formulas
- link, consolidate and combine data
Legacy course code: 00012461
Additional upcoming sessions
| Date and Time | Session code | Location | Language | Available seats | |
|---|---|---|---|---|---|
| May 12, 2025, 9:00 am to 12:00 pm (ET) | IT9579-FR-20250512 | Virtual | French | 1 | Sign in to register |
| May 20, 2025, 9:00 am to 12:00 pm (ET) | IT9579-EN-20250520 | Virtual | English | Full | Sign in to register |
| August 06, 2025, 9:00 am to 12:00 pm (ET) | IT9579-FR-20250806 | Virtual | French | 10 | Sign in to register |
| August 25, 2025, 9:00 am to 12:00 pm (ET) | IT9579-EN-20250825 | Virtual | English | Full | Sign in to register |
Related products
Excel: Working with Functions and Formulas (Missions)
The purpose of this course at the intermediate/advanced level is to help participants learn how to manage functions and formulas, identify errors, correct them and link data using MS Excel 2010. Learning Objectives: Upon completion of this course, p
