Free

Looking up data in Excel

Event Information

Share this event

Date and Time

Location

Location

Walsall College

Littleton Street West

Walsall

WS2 8ES

United Kingdom

View Map

Event description

Description

This course is delivered by Walsall College

Learning outcomes:

  • Explain the purpose of the LOOKUP function and outline its structure.
  • Implement both, exact and approximate match, VLOOKUP and HLOOKUP functions to find data.
  • Outline the purpose and structure of the INDEX and MATCH functions
  • Compare the use of the INDEX and MATCH functions to the LOOKUP function.
  • Implement the INDEX and MATCH functions to find data.

  • Under the EU funding rules, eligibility will be checked before the course commences
  • People currently undertaking a modern apprenticeship are not eligible for this funded course
  • Your business must be based in the Black Country to be eligible for this course
Share with friends

Date and Time

Location

Walsall College

Littleton Street West

Walsall

WS2 8ES

United Kingdom

View Map

Save This Event

Event Saved