Excel: Working with Functions and Formulas (Missions)
Upcoming sessions
To register, you will be prompted to sign in.
12 April 2023
Virtual
06:00 to 09:00 EST
English
See more dates
Overview
Delivery method
Virtual Classroom
Duration
1 day
Audience
Employees
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 functions (IF)
- reference cells
- correct error values
- work with array formulas
- link, consolidate and combine data
Legacy course code: 00012462
Additional upcoming sessions
Date and Time | Session code | Location | Language | Status | |||
---|---|---|---|---|---|---|---|
|
06 December 2022 07:00 to 10:00 EST | IT9580-EN-2022-001 | Virtual | English | Full | Sign in to enrol | More Info |
|
12 April 2023 06:00 to 09:00 EST | IT9580-EN-2023-001 | Virtual | English | Full | Sign in to enrol | More Info |