0

Overview

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.

Why Choose Teachers Training

Some of our website features are:

  • This is a dedicated website for teaching
  • 24/7 tutor support
  • Interactive Content
  • Affordable price
  • Courses accredited by the UK's top awarding bodies
  • 100% online
  • Flexible deadline

Entry Requirements

No formal entry requirements. You need to have:

  • Passion for learning
  • A good understanding of the English language
  • Be motivated and hard-working
  • Over the age of 16.

Certification

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.

  • You can get your digital certificate (PDF) for £4.99 only
  • Hard copy certificates are also available, and you can get one for only £10.99
  • You can get both PDF and Hard copy certificates for just £12.99!

The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

Schema Markup

Course Curriculum

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
Review

COURSE REVIEWS

Related Courses