Excel: Working with Functions and Formulas (Headquarters)

Product code: IT9579

Overview

Delivery method

Delivery method

Classroom

Virtual Classroom

Duration

Duration

3 hours

Audience

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

No Current Offerings

Related products

Course
IT9580

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
Date modified: 2022-07-11