Provider web pages

 

UCL Learning Portfolio

 

DSD: VLookup in Excel - workshop (ISVLUE) 
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 Blackboard Collaborate to join 15 minutes early in order to test out their connection/audio and help will be offered to sort out any problems. Participants are welcome to join any time within the first 15 minutes of the advertised start time. 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
09/11/2021 - 09/11/2021  (Enrol between 01/01/1951 and 07/11/2021) Enrol

01/12/2021 - 01/12/2021  (Enrol between 01/10/2021 and 29/11/2021) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue