Booking options
£27.99
£27.99
On-Demand course
1 hour 47 minutes
All levels
XLOOKUP and VLOOKUP Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this XLOOKUP and VLOOKUP Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills.
Consisting of several modules, the course teaches you everything you need to succeed in this profession.
The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website.
Some of our website features are:
No formal entry requirements. You need to have:
CPD Certification from The Teachers Training
Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.
The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.
XLOOKUP | |||
What Is XLOOKUP? | 00:01:00 | ||
XLOOKUP Syntax | 00:08:00 | ||
XLOOKUP Rules | 00:05:00 | ||
XLOOKUP NA Error | 00:03:00 | ||
XLOOKUP Match_mode | 00:09:00 | ||
XLOOKUP Search_mode | 00:08:00 | ||
XLOOKUP Wildcards | 00:11:00 | ||
XLOOKUP Horizontal Lookup | 00:04:00 | ||
XLOOKUP Across Different Spreadsheets | 00:03:00 | ||
VLOOKUP | |||
Introduction | 00:02:00 | ||
What Is VLOOKUP? | 00:01:00 | ||
VLOOKUP Syntax | 00:06:00 | ||
VLOOKUP - Range_lookup FALSE | 00:06:00 | ||
VLOOKUP - Range_lookup TRUE | 00:06:00 | ||
VLOOKUP Rules | 00:06:00 | ||
VLOOKUP NA Errors | 00:06:00 | ||
VLOOKUP Wildcards | 00:11:00 | ||
VLOOKUP Insert Function | 00:04:00 | ||
VLOOKUP Across Different Tabs | 00:07:00 |