Microsoft Excel VLOOKUP with INDIRECT Function
Автор: Banahene Tutorial Collections
Загружено: 2022-08-04
Просмотров: 328
Описание:
You are welcome to Banahene Design Works. This wonderful channel is about computer techniques, computer design works and training on Microsoft office software. As an ICT teacher and trainer I do have the passion to share my IT ideas with people. In Microsoft Excel spreadsheet application, there are a lot of formulas and functions to be used for different task. Today i want to show you a special two functions to manipulate your Excel data. These functions are VLOOKUP and INDIRECT. In addition to these functions, we will also used Name Range to make it quicker for us. let's check this out. Below are timestamps.
Timestamp:
00:00 Introduction
00:22 Introduction to worksheet data
02:44 How to create a name range in excel
05:52 How to use the VLOOKUP function
09:55 How to use the VLOOKUP, and INDIRECT function
13:24 Video conclusion
Thank you for watching. Please like, share and comment for improvement of this channel.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
