Excel: Working with Functions and Formulas (Missions)

Product code: IT9580

Upcoming sessions

To register, you will be prompted to sign in.


12 April 2023

Virtual

06:00 to 09:00 EST


See more dates

Overview

Delivery method

Delivery method

Virtual Classroom

Duration

Duration

1 day

Audience

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 More Info
12 April 2023 06:00 to 09:00 EST IT9580-EN-2023-001 Virtual English Full More Info
Date modified: 2022-07-11