Microsoft Excel Functions – INDEX and MATCH – Online Excel Training Course

Book this course

Course description

While the VLOOKUP function in Microsoft Excel is an extremely useful tool, there are certain situations in which it’s not quite dynamic enough – for example, when you want to be able to search an entire data table without the need to move lookup references, or you want to be able to search through multiple tables at once. In those instances, the INDEX or MATCH functions can solve your problem.

We take an in-depth look at both the INDEX and MATCH functions – what they do, how they work, and how they can be used in conjunction with the VLOOKUP function. Learners are encouraged to participate in the session by asking questions, and we’ll be here to give you support via telephone, email or Twitter for 90 days after the programme finishes.

Is it right for me?

If you’re an Excel user who already knows how to use lookup functions, and you want to learn about INDEX and MATCH functions, or you just want to refresh your existing knowledge, this online Excel training course will enhance your current lookup skills.

What will I get out of it?

By the end of the course you will be able to:


  • The syntax to the INDEX and MATCH functions
  • How to combine INDEX and MATCH to create fully dynamic searches
  • How to search across multiple areas or tables
  • How to display user tips
  • How to warn or prevent users from entering invalid data

The trainer gave a lot of useful shortcuts. Superb style and subject knowledge. Excellent course, one of the best I have attended.

Flight Operations Inspector, Civil Aviation Authority

What does it cover?

  • MATCH function syntax
  • INDEX function syntax – array form
  • INDEX function syntax – reference form
  • Creating dynamic look up functions combining INDEX and MATCH
  • Using the REFERENCE form to search multiple tables
  • Using drop down lists to create dynamic searches
  • Creating a dynamic VLOOKUP formula

Book this course

Course leader

Richard Harker

L&D Consultant, IT Solutions

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine