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: Please ensure you are using Desktop@UCL or the UCL VPN when booking because you need to be on the UCL network to use the system.

Once you have enrolled, you will need to click on the play button under 'My current enrolments' in My Learning to join at the time of the live session. You will also receive an email from ISD containing the direct joining link a day before the session. Please check your junk folder as these emails are occasionally tagged as spam.

We would encourage those who are new to Microsoft Teams to join within the first 15 minutes of the advertised start time in order to test out their connection/audio. The actual session will start on the hour.
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
Register Interest in future dates Register Interest

Back to MyLearning Catalogue