Mastering Lookups with Microsoft Excel

Who is this course for?

This specialist hands on session is for you if you are working with lots of data, are new to the lookup functions or just want a recap. If you are unfamiliar or completely new to formulas or calculations then attending our “Introduction to Formulas and Functions” session could benefit you before attending this session.

What are the benefits

At the end of this session you will be familiar with the lookup functions, LOOKUP, VLOOKUP, HLOOKUP, cross reference data using INDEX and MATCH and recognise when data is not found.

Enquire about this course

Course Enquiry

Please type your full name.
Invalid email address.
Invalid email address.
Invalid Input

Course Duration

2-3 Hours

Course Content

Getting Started

  • Review function writing
  • Recap function structure

The LOOKUP Function

  • Assembling the LOOKUP function
  • Applying the function to data
  • Understanding the limitations of the LOOKUP function

The VLOOKUP Function

  • Assembling the VLOOKUP function
  • Applying the function to data
  • Understanding the limitations of the VLOOKUP function

The HLOOKUP Function

  • Assembling the HLOOKUP function
  • Applying the function to data
  • Understanding the limitations of the HLOOKUP function

The INDEX Function

  • Assembling the INDEX function
  • Applying the function to data
  • Understanding the use of the INDEX function

The MATCH Function

  • Assembling the MATCH function
  • Applying the function to data
  • Understanding the use of the MATCH function

Nested Functions

  • Use nested LOOKUP and MATCH functions to return data

Correcting errors

  • Recognise the common LOOKUP error messages
  • ISNA
  • IFERROR
  • IF ISERROR

Formula Auditing

  • Use Microsoft Excel’s inbuilt auditing tools to track errors

What our users say

 

  • A very good course, trainer had good knowledge and delivered well
  • I like the fact that you have selected topics/functions on the basis of their interest/possible use - course is much more than pertinent and a better use of time
  • Very friendly and helpful trainer
  • Ray is the only IT Trainer who has ever inspired me with enough confidence to learn effectively
  • It was very good, I really enjoyed it and learnt a lot
  • I will definitely use the Pivot Tables at work in the future! Thank you for such a great training day!
  • Will ensure my team all attend (they all work remotely)
  • Exactly what I was hoping to learn, thanks

  • Contact Us
  • 44 (0) 208 681 1485
  • 44 (0) 7794 0689 6985

E Mail Us