About the Bitesize course

  • Pre-requisites

    You'll need Excel 2007, 2010, 2013 or 2016 installed. You should be familiar with creating formulas such as SUM, COUNT and Absolute References. Check out our Excel Introduction course.

  • Who will benefit?

    Users who need to retrieve data from another sheet or table in order to create reports or summaries. Also anyone who has heard of VLookup/HLookup but unsure what's all about.

  • Course Outcomes

    You'll be able to understand what a VLookup/HLookup formula is, how to create one and how it can help in the retrieval of data. You'll also learn about creating Range Names to use for references tables and cells.

  • Course Duration

    The course will take approximately 45 minutes to complete.

Course curriculum

  • 1
    Welcome to the course!
    • Here's what you'll be learning...
    • Course Exercises
  • 2
    Introduction to VLookup and HLookup
    • Introduction to VLookup and HLookup
  • 3
    Range Names
    • Range Names
  • 4
    Creating a VLookup
    • VLookup Syntax
    • Using VLookup
  • 5
    Creating a HLookup
    • Using HLookup
  • 6
    Course Survey
    • Before you go, we'd love to hear your feedback on the course please...

Course Instructor

  • Simon Lambourne-Wills

    Microsoft Office and Office365 Trainer

    Simon Lambourne-Wills

    I’ve been an IT trainer for over 10 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it’s important to enjoy attending training courses. Therefore, engaging and interacting with students on their own experiences of using the software, enables them to feel more involved in the course.

Other Bitesize Courses