Description
COURSE OBJECTIVE:
This online Excel course teaches participants how to use lookup
functions to quickly find and retrieve information from large datasets.
Learners will explore functions such as XLOOKUP, VLOOKUP, and HLOOKUP,
gaining an understanding of how to match records across different tables
and worksheets. Through practical examples, participants will learn how
to automate data retrieval, reduce manual searching, and build more
efficient and accurate spreadsheets for everyday tasks.
COURSE FORMAT:
The course involves explanation, demonstration and hands-on practice,
working through exercises that build on your existing skills and
increase the functionality of spreadsheet formulae.
PREREQUISITES:
Participants should be able to perform the following tasks without
assitance:-
• Create formula using basic function such as SUM, AVERAGE etc
• Calculate percentages
• Fix a cell reference within a formula (absolute cell referencing)
To gain these skills we recommend that you attend the following course
first:-
Excel Understanding Formula (to learn basic formula & functions)
CONTENT
• Lookup & Reference Functions (IFNA, LOOKUP, VLOOKUP, HLOOKUP,
XLOOKUP)
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
