Digital Skills Course: Excel: Analyse your data using LOOKUP functions

Who is this course aimed at?

All University Staff

What is this course about?

The VLOOKUP and XLOOKUP functions in Excel can be used to find items in a table or range of data arranged in rows. For example, find an employee name based on their employee ID. In this session, learn how to merge and extract data using the VLOOKUP and XLOOKUP functions in Excel.

Details of any pre-course/programme requirements

Some knowledge and experience in the use of Excel is recommended.

Objectives

Here is what you can expect by attending this course:
  • An understanding of the VLOOKUP function and its limitations compared to XLOOKUP.
  • Knowledge of how to extract data using VLOOKUP
  • Knowledge of how to merge data using VLOOKUP and XLOOKUP.

Booking info:

08 October 2024 14:00 - 15:30 Places Remaining
28 November 2024 14:00 - 15:30 Places Remaining

You can book your place on one of the courses above or add yourself to the waiting list using the "Book your place" button above.

Please note, if you experience difficulty in connecting to the waiting list, please log into MyHR separately and then click "Book your place" again. You can also contact people@hud.ac.uk if you require further assistance.

Don't have access to MyHR?

If you do not have access to MyHR (i.e. you may be an Affiliate) please email people@hud.ac.uk confirming your full name, the name of the course you would like to attend (and date of course if applicable) and the School/Service that you work for.

Attendee Details

*
*
*
*
*

Our Development Themes

Want to book on to a session or explore our themed learning resources?

A-Z of our Sessions

Search for a session using our A-Z guide.

Upcoming Sessions

Find our upcoming sessions here.