Home >> Courses >> Others >> A Course on the VLOOKUP and XLOOKUP Functions in Excel

A Course on the VLOOKUP and XLOOKUP Functions in Excel

VLOOKUP and XLOOKUP

Last Updated:10/2022 English (UK) Instructor: Kathryn Tilley

Lectures: 20
|
Videos: 1.87 hours
|
Level: All
|
Language: English
|
Last Updated: 10/2022

Skills: Excel Formulas and Functions Microsoft Excel

Eduonix Infiniti Subscription Plan

Access this and 2000+ courses for free

Free with Infiniti

Offer Price:

$3.00

Our Price:

$6.00

Original Price:

~~$12.00~~

You Save:

$6.00 (50%)

Free with Infiniti

Ends in:

00D 00H 00M 00S

20 lectures 1.87 hours English

Learn Risk Free

30 day money back guarantee

$6.00 ~~$12.00~~

About this Course

Hello and welcome to this course on the VLOOKUP and XLOOKUP functions in Excel.

In this course, we shall go through the VLOOKUP and XLOOKUP functions in Excel to have a look at what they are, how to use them and some examples of using each. VLOOKUP and XLOOKUP are handy built-in functions in Excel that are used to find and retrieve information from datasets or tables. Throughout this course, I assume you have absolutely no knowledge of Excel or even spreadsheets in general, so I take you right from the start and describe each step in terms you will understand. We will have a look at each section of the VLOOKUP and XLOOKUP syntax as well as looking at examples with each. Some of the sections we cover in the course are:

The syntax of each function
Exact matching and approximate matching
Match_mode
Search_mode
Rules to follow to avoid common errors
NA Errors
Using wildcards with each function
Using the insert function option
Using the functions across different tabs and spreadsheets

This course is ideal for anyone who wants to learn what the VLOOKUP and XLOOKUP functions are and how to use them. You may have been using VLOOKUP for years but are ready to find out what XLOOKUP can do for you instead, or you may just want refreshers on using both of these functions.

People interested in this course also viewed

Course Content

Prerequisites

About the Instructor

Kathryn Tilley

Courses...

Hello! My name is Kathryn and I create online courses to help you to learn all about Excel and how it can make your life easier.

I have worked with Excel for many years, and despite having IT qualifications, there is so much that I've learnt about this program through my everyday use at work. Since starting to use Excel, I now use it to make life easier both in work and at home.

Reviews and Ratings

Top Reviews

View More Reviews

Frequently Asked Questions

It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.

A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.

A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.

We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.