Тёмный

LOOKUP Functions in Excel VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial 

Simon Sez IT
Подписаться 602 тыс.
Просмотров 125 тыс.
50% 1

Опубликовано:

 

11 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 63   
@SimonSezIT
@SimonSezIT 3 года назад
Download the instructor files and follow along! www.simonsezit.com/excel-biz-analysis-instructor-files/
@SleepEatWorkRepeat
@SleepEatWorkRepeat 3 года назад
Why do none of these links work? They never send the downloads to my email.
@victormayer5665
@victormayer5665 2 года назад
the files are not available anymore...
@dexxxxxxxx
@dexxxxxxxx 2 года назад
Links not working
@THE_REAL_HAUTE_CRE
@THE_REAL_HAUTE_CRE 3 года назад
I've been using Excel for over 30 years, and the presentation and syntax of this course and its content is among the best I've ever experienced. Makes diving into the Black Hole of Excel fun and interesting!
@cliffordeaton5455
@cliffordeaton5455 3 года назад
Thank you so much for the great instructional videos. For newbies like me, they're worth their weight in gold!
@SimonSezIT
@SimonSezIT 3 года назад
Glad you like them!
@realvirtualdemand4222
@realvirtualdemand4222 2 года назад
this is a great tutorial and how to get out excel skills up to par..
@sargonkheedo
@sargonkheedo 3 года назад
Deb, is the best of the best... thank you Simon Sez it... this is by far the most detailed easy to learn .. thank you
@genesisfincorp88
@genesisfincorp88 Год назад
It is wonder session of advance excel. learnt a lot. ❤❤
@SimonSezIT
@SimonSezIT Год назад
Glad you think so!😊 We have additional free Excel training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@ziaglos
@ziaglos 3 года назад
Just like it. Thank you Deb 👏👏👍
@SimonSezIT
@SimonSezIT 2 года назад
Glad you like it
@amitpanchal135
@amitpanchal135 2 года назад
I am so glad mam from meet you
@poodleseigien
@poodleseigien 2 года назад
Best instructor!
@justinoroy
@justinoroy 2 года назад
Thank u so much, keep doing great!
@SimonSezIT
@SimonSezIT 2 года назад
Thanks for watching Justino!
@1sornram
@1sornram 2 года назад
so freaking helpful! thanks a bunch
@jamesdep8128
@jamesdep8128 2 года назад
Great class. Thank you again!
@SimonSezIT
@SimonSezIT 2 года назад
Thanks for watching James!🙃
@jamesdep8128
@jamesdep8128 2 года назад
@@SimonSezIT I am watching all of your videos. it is greatly helping me in my training.
@shijogeorgethomas7830
@shijogeorgethomas7830 2 года назад
Perfect Explanation🙂
@black90ify
@black90ify 2 года назад
we are not receiving any e-mail to download the supported file . will you check this issue
@idowumayowadavid886
@idowumayowadavid886 Год назад
Thanks so much . I just received the file for free
@SimonSezIT
@SimonSezIT Год назад
Great! We have additional free Excel training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@nstcoffice3533
@nstcoffice3533 Год назад
Thank you for such a nice tutorial
@SimonSezIT
@SimonSezIT Год назад
You're welcome 😊
@bhavnakawa1299
@bhavnakawa1299 2 года назад
I have not received the support file either
@chutatipwattana399
@chutatipwattana399 3 года назад
Thank you!!
@SimonSezIT
@SimonSezIT 3 года назад
Happy to help!
@magtulunganpinoy5597
@magtulunganpinoy5597 Год назад
thanks soooooo much!!!!!
@SimonSezIT
@SimonSezIT Год назад
No problem!
@jessieren1296
@jessieren1296 2 года назад
It helps a lot! Thank you so so much!
@SimonSezIT
@SimonSezIT 2 года назад
You're welcome!
@lisapenfold2979
@lisapenfold2979 2 года назад
great video. thanks.
@SimonSezIT
@SimonSezIT 2 года назад
Thanks for the nice comments, Lisa 😊
@TVSCDN
@TVSCDN 10 месяцев назад
Thanks madam🎉🎉🎉❤❤❤😊
@SimonSezIT
@SimonSezIT 10 месяцев назад
Most welcome 😊
@nikush1631
@nikush1631 Год назад
Is the final module available for this online as well? Thanks for all that you do, starting a new job Monday and these videos are so helpful!
@ianrobertson5128
@ianrobertson5128 3 года назад
Do you do videos on Excel for Mac 365? These are fabulous but the Mac version is different in some spots.
@SimonSezIT
@SimonSezIT 3 года назад
Thanks Ian, Delighted you are enjoying the tutorials and thanks for letting me know what you are looking for, we'll see what we can do: Our Excel for Mac Tutorials are currently beginner level:ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sYU4k0P8c5g.html
@z-spotinternational165
@z-spotinternational165 2 года назад
I have subscribed to the excel file already but i dun see the work file being sent - its not in the spam folder either
@z-spotinternational165
@z-spotinternational165 2 года назад
the file has not gone to any SPAM Sir... hope you are able to help out with this
@athennasamelin425
@athennasamelin425 2 года назад
hii, if you don't mind, can I ask the reference you've used in Index Match (Market Research: Revenue and Profit for Popular Iphone Apps)? thank youuu
@hapemokenela7388
@hapemokenela7388 2 года назад
i didn't receive an email for the download link. Please reply.Thank You.
@SimonSezIT
@SimonSezIT 2 года назад
Please check your spam folder.
@RY-ey7dx
@RY-ey7dx 2 года назад
For some reason, the instructor files to follow along are not accessible. the link returns a blank webpage :(
@SimonSezIT
@SimonSezIT 2 года назад
Hi RY. Sorry about that. Please try clearing your cache or try another web browser.
@RY-ey7dx
@RY-ey7dx 2 года назад
@@SimonSezIT thanks.
@idowumayowadavid886
@idowumayowadavid886 Год назад
Please I really wish to get access to the file promised in the video. I have given my email details but I am yet to receive any file.
@idowumayowadavid886
@idowumayowadavid886 Год назад
Thanks alot . I just received the file for free.
@prathyushasegu4991
@prathyushasegu4991 3 года назад
HI Mam, Can you share a vedio by using Unit price inplace of Part No.
@hestiaa9354
@hestiaa9354 Год назад
I don’t know if that will work. The unit prices might be the same for several items. How would VLookup know which one to select?
@aradhyarathi2048
@aradhyarathi2048 3 года назад
Please send the document of VLOOKUP true statement for practice in my reply.
@SimonSezIT
@SimonSezIT 3 года назад
You can download the instructor files for this video here: www.simonsezit.com/excel-biz-analysis-instructor-files/
@aradhyarathi2048
@aradhyarathi2048 3 года назад
@@SimonSezIT Thank you !!
@aydaneliyeva4682
@aydaneliyeva4682 2 года назад
why doesnt work file?(
@ememanduquincy8457
@ememanduquincy8457 3 года назад
Can you make include timestamps to such a long video?
@SimonSezIT
@SimonSezIT 3 года назад
Thank you for the feedback, we'll see what we can do.
@sandhyarani362
@sandhyarani362 Год назад
will u make a video on excel 2007
@SimonSezIT
@SimonSezIT Год назад
We do have some older tutorial videos on Excel 2007. Check out this playlist ➡️ru-vid.com/group/PLzj7TwUeMQ3gIjaQf5o75BrEeaSF2cg_j
@dexxxxxxxx
@dexxxxxxxx 2 года назад
27:26
@dessleonid
@dessleonid 7 месяцев назад
Nope I didn't get the result of 57 and 52 but 100 and 100 on those cells while doing your shitty match + vlookup. Why? This is BS. Why do you need this complication with match formula while just Vlookup formula manages its work pretty damn good of its own accord?
Далее
Вопрос Ребром - Булкин
59:32
Просмотров 786 тыс.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
How to Use VLOOKUP to Compare Two Lists
15:20
Просмотров 810 тыс.
VLOOKUP in Excel | Tutorial for Beginners
32:09
Просмотров 1,9 млн
How To Use Index Match As An Alternative To Vlookup
19:28