UCL Learning Portfolio

 

DSD: VLookup in Excel - workshop
Course Description:
The VLookup function in Excel is able to look for a value in a table or range and retrieve some corresponding data. For example, you can use a VLookup formula to look for a particular module code in a table and extract some further information about it, such as how many students are enrolled or the name of the tutor. In this introductory-level session, we will practice several examples of VLookup and take a brief look at HLookup too.

IMPORTANT:

Once you have enrolled, please check that you have received a confirmation email from MyLearning. You will also receive an email with a joining link at least one day before the session.

Courses start on the hour but please join during the 5 minutes prior to this to download resources and test out your connection/audio.

For more details on how to book, cancel and join sessions please visit our practical course information page.


Objectives:
By the end of the session you will be able to:
  • Apply the VLookup function.
  • Understand when to specify an exact match or approximate match for a value.
  • Work with VLookup across worksheets.
  • Apply the HLookup function.
Intended Audience:
This workshop is aimed at those wishing to learn how to use the VLookUp function in Excel.
Target Audience: All
13/12/2022 - 13/12/2022  (Enrol between 31/07/2022 and 09/12/2022) Enrol

07/02/2023 - 07/02/2023  (Enrol between 21/11/2022 and 03/02/2023) Enrol

22/03/2023 - 22/03/2023  (Enrol between 21/11/2022 and 20/03/2023) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue