Live Online - Microsoft Excel Lookup & Reference Functions

Event Information

Share this event

Date and Time

Location

Location

This is an Online Training course delivered via the web using industry leading software

Online Training, VIC

Australia

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

This ½ day Online Microsoft Excel – Lookup and Reference Functions course will get you up and running with some of the most popular tools in Excel, used to look up specific information within data sets. Lookup and Reference functions including Vlookup are showcased here.

You will also explore Range Names, and move on to more powerful and flexible functions such as Index and Match.

This is an Intermediate level course.

What you get

  • Class size kept to a maximum of 10 participants.
  • Average class is 4-6 people.
  • Qualified, experienced and approachable facilitators.
  • Training materials and take away practice files.
  • Lifetime post course support.

Need to Learn more about Live Online Training.

Microsoft Excel - Lookup & Reference Functions Course Content

Working with Range Names

  • Naming Ranges
  • Navigating with Range Names
  • Using Range Names in Formulas
  • Modifying Range Names

Choose Function

  • Using the Choose Function

Lookup Functions

  • Using Lookup Functions
  • Lookup
  • VLookup
  • HLookup

Index and Match Functions

  • Using Index
  • Using Match
  • Using Index and Match Together


If you need to book a course after the ticket sales have closed, please get in touch and we'll do our best to accommodate you.

See here for terms and conditions.

Date and Time

Location

This is an Online Training course delivered via the web using industry leading software

Online Training, VIC

Australia

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved