Microsoft Excel Lookup Functions – Online Excel Training Course

Book this course

Course description

For anyone working with lots of data – particularly those who need to easily cross-reference different sets of data – the ability to use functions such as VLOOKUP in Microsoft Excel is absolutely essential.

We show you all the basics of the LOOKUP, VLOOKUP, and HLOOKUP functions, showing you how they work, their limitations, and how you can make them work for you. 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 wants to learn how to use the lookup functions, or you want to refresh your existing knowledge, this online Excel training course will enable you to achieve that.

What will I get out of it?

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


  • How the LOOKUP function works and what its limitations are
  • How to write a basic VLOOKUP function to find related information within the same worksheet
  • The difference between near and exact matches in your searches
  • The limitations of the VLOOKUP function
  • How to build a VLOOKUP function working between different worksheets and workbooks
  • How to use the HLOOKUP function

Excellent trainer delivering the course in a friendly and professional manner. Good explanations and excellent knowledge of product.

Team Manager, Scotia Gas Networks

What does it cover?

  • Putting together the LOOKUP function
  • Applying the function to data
  • Limitations of the LOOKUP function
  • Putting together the VLOOKUP function
  • Applying it to a single data set
  • Using VLOOKUP across different worksheets
  • Using VLOOKUP across different workbooks
  • Limitations of the VLOOKUP function
  • Putting together the HLOOKUP function
  • Applying it to data

Book this course

Course leader

Richard Harker

Technical & Digital Learning Consultant

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