Excel - VLOOKUP: How and when to use it Tutorial

In this video, you will learn about VLOOKUP and how and when to use it.
The video covers the VLOOKUP function, which is similar to a phone book, where you start with a piece of data and use it to find other related information.
The video demonstrates how to use VLOOKUP to find prices based on part numbers in a large spreadsheet.
By entering the part number in a specific cell, you can retrieve the corresponding price.
This will help you efficiently find information in a large dataset and save time.

2:38
1383 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - The HLOOKUP function

In this video, you will learn about the HLOOKUP function in Microsoft Excel.
The video covers the basic features of the HLOOKUP function and demonstrates how to use it to retrieve data based on a common element.
By specifying the search value, lookup array, returned array, and match mode, you can easily set up the HLOOKUP function.
This will help you efficiently retrieve data and complete your tasks in Excel.

497 views

Excel - The nuts and bolts of VLOOKUP

In this video, you will learn about the nuts and bolts of VLOOKUP.
The video breaks down how VLOOKUP works and explains its four arguments:
the lookup value, the table array, the column reference, and the range lookup.
It also highlights some important considerations, such as the need for the lookup values to be in the left-hand column of the table array and the arrangement of data in columns vertically.
The video demonstrates how to use VLOOKUP to find exact matches or partial matches and provides examples of both.
This tutorial will help you understand and effectively use the VLOOKUP function in Microsoft 365.

3:05
1714 views

Excel - Look up values on a different worksheet

In this video, you will learn how to look up values on a different worksheet using Microsoft 365. The video demonstrates how to use the VLOOKUP function to aggregate data from multiple worksheets into one place.
By entering the appropriate arguments, such as the column reference and the range of cells to search, you can find matching values and retrieve the desired information.
This tutorial will help you efficiently gather and analyze data from different worksheets, improving your data management skills.

2:39
1470 views

Excel - The VLOOKUP function

In this video, you will learn about the VLOOKUP function in Microsoft 365. The video demonstrates how to use the VLOOKUP function to retrieve data from another table based on a reference field.
It covers the steps to select the lookup value, specify the table array, determine the column index number, and choose the match type.
This knowledge will help you effectively use the VLOOKUP function in Microsoft 365 to retrieve specific data.

595 views

Excel - Start with "Ideas" in Excel

In this video, you will learn how to start with "Ideas" in Excel.
The Ideas feature in Excel allows you to analyze data using relevant models, patterns, and visual summaries.
You can access this tool from the Home tab by selecting a cell in a range of data and clicking on the Ideas button.
Excel will then provide you with relevant previews to help you interpret your tables.
This tutorial will help you make the most of the Ideas feature in Excel and enhance your data analysis skills.

0:38
1355 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivot tables, and take advantage of all that Excel has to offer!

Your trainer for this course
Cours E-learning

204 vues

ALL COURSES