For the individuals who are taking the Microsoft Office ProveIt Assessment (Outlook, Word, Excel, and PowerPoint), I highly encourage this video. I passed my tests with an overall score of 90.75. I made sure to add the video to my favorites so that if I am lacking in an area in the future, I can refer back to this video. Clear and concise instructions. The individual teaching this video is a great communicator in the sense that he does not bombard the viewers with confusing information.
Thank you so much for these. I retired 3 years ago and was fairly proficient with Excel. Recently started doing some personal financial work using Excel and was frustrated with how much I had forgotten. These are so well done and exactly what I needed to freshen my skills.
Two Rules to remember: First (The Data must be arranged in Vertical Columns) Second (The Information has to be to the left). Many Thanks for the clear and simple explanation.
I've been watching your videos all morning just trying to get an idea of how to work with Excel. You have a wonderful way of teaching. I've watched your video's a few times over, taken notes & worked within the program while watching. I will most definitely be using them again to continue to learn Excel. Thank you for what you do. Keep up the good work.
I've been training VLookups for years...never thought to compare it to an Index in a book or a telephone directory. I will be using this example in future sessions. Thanks for the inspiration!
Glad you said that. I thought it was just me. This is a phenomenon; a game changer. If he could teach rocket science, I could understand it. Pure and plain English. This is where I will be for instruction. And a very big thank you.
Honestly, the best explanation of Vlookup I've ever found! All other explanations are just very confusing but you just made it look like it's a piece of cake! Thank you so much!
Exactly!!! He explained the way my brain understood it. 4 different arguments. 1: what you know 2: the range 3: the answer you need 4: true or false. I hope this person is making a ton of money seeing how he is amazing!🩷
You are a born video instructor. Your voice is engaging, your speed with the mouse is not too fast and not too slow, and your progression made sure I did not get lost. I am absolutely coming back to watch this again when I need another refresher. Subscribed!
To summarise the Look Up Function parameters or Four Arguments, it is simply in the letters ( V, T, C, R) or Value of look Up, Table Array, Column Index, Range or FALSE), as easy as ABCD. Many Thanks again for the clear and simple explanation.
Hey! I normally don't comment on videos, but I wanted to say how great this video is! It's been two years since I've learned this stuff and I feel like I'm being taught it even better!!
Never found that satisfactory video response. I just watched it 1 time and Now i can play with VLOOKUP easily. Hats Off to you. Great teacher. May God Bless you with prosperity and Kindness. Aameen.
Very helpful. Excel has always been one of my biggest insecurities and it intimidates me, your tutorial made me understand the functions and objectives of Excel. Everything I know about Excel then is all cluttered up in my head, this helped me compartmentalized, sort, and regroup to get me a clean start (re)learning Excel.
Thank you so much! Your explanation that the Column Index Number is contextual and not the actual column number (A=1, B=2 etc) was what not many other tutorials covered & exactly why my formula kept failing
I looked up many vlookup videos and this was the easiest one so far! I have to do it for work and I'm on my second day of struggling. Still not quite sure how I'm going to do it at least now I understand I'm almost there. Lol I'm going to keep watching this video while I pull up my spreadsheet
Man! Am I glad I found your videos. I'm great with Word and Powerpoint, but Excel is where I suffered in high school with other students being a distraction. Now looking for a new job where strong excel skills are a must, I'd like to get that skill set up. Thanks again!!
or simply cut the original one and paste it to a new destination if you are going to delete the original destination anyways...cutting and pasting doesn't alter the formula.
Dragging does the same? I tried the 4 arrow drag(that appears when the cursor is over the borders) and the values did not change. I am new so just asking to make sure. thanks
@@randomjack477 Might be too late now (You might have watched further and this has been answered, I'm not sure), but No, simply dragging will still screw up the formula. If you drag the cell over by 1 cell, then all the information in the formula will be 1 cell off in the direction you drag it to. Easiest way to understand to get around it is to simply click on the cell you want to move, HIGHLIGHT the formula, copy that (This will copy it as text), click the cell you want to move it to, and then click paste. The "$" symbols in the tip above are also useful if you understand how to use them.
I'm doing a Coursera review of excel, and they did not explain each of the parts of the formula very well. This was so much clear. Thanks for breaking it down.
Hello..I have a job interview on Monday and the job responsibility stresses the importance of using Excel. I found your videos today and IM EXTREMELY GRATEFUL because of your awesome teaching , I know I will be prepared for this potential job 😊!!
I've never used VCODE before. I watched this video twice and was able to adopt your example to do exactly what I needed in my report. Thank you for being so clear and concise.
Hey man. You're the best. As a gratitude for your free lessons, I don't skip the ads even if I'm not interested in them so that you could earn more ad revenue.
Your explanations and examples were incredibly useful. The best intro video on Vookup that I've seen...and I've looked at over 10 so far! Very well done sir!
Excellent.... For the first time I heard about Vlookup... I tried it and got succeeded. Great explanation. Keep going on and on. Do educate us and keep your selves englihten
This is excellent instruction! I subscribed some time ago but forgot I had. I've watched umpteen videos elsewhere trying to figure out how to do this and lost an entire afternoon. Spent 12 minutes here - and I'm able to move on! Thank you!
Excellent teaching! Great, great. Thank you so much for taking the time to do this. I'm in between jobs and training myself new tools and you made this very easy to understand and the speed that you went was awesome. Thanks
I knew how to do v-lookup but wasn't sure of its actual value because you can always just use control f or just copy two columns next to each other instead, but the way you used a new reference cell that you can change at any moment made it clear that v-lookup is useful. Thank you so much
Best tutorial so far!! The tips on the last part really helps to clarify some questions. I would appreciate if you'll give tips everytime before you end your videos. Thanks!!!!!
You make it soooo easy to understand. Thank you!! Excited learning with your channel.😊❤ I have been sweating tryinh to understand in linkin and to be honest with you some people used difficult words to understand. You made it simple. Again Thank you.
Even though i consider myself between an intermediate to advanced excel user, I decided to start from the very beginning...just in case. Low and behold, there were a couple of actions/function in the beginner tutorial that i had not been aware of. it'll save time in the future! Great lessons...plan is, I will watch all 70+ tutorials. Easy to understand and thank you for explaining terms in a simplistic way. Very frustration free :-)
I love your videos but could you please number them, so that it would be easier to understand which one to watch first? Thanks for taking your time and doing these videos, they are extremely helpful!
I am really enjoying watching these videos. They are great refreshers for me and they help me understand things more clearer that I was having a hard time with.
Wonderfully done! I'm making some instructional videos for elementary students, and I wanted to make sure I didn't leave anything out. Reviewing your videos has helped me very much.
Your all tutorials about Excel are amazing and I'm learning so much from you💕 But I would like to suggest one thing, Please write tutorials' serial Number on thumbnail so that we can find easily the next one.
For anyone wondering, you don't have to rewrite the formula, just catch and drag the cell with the formula and move it where you need it. (in this case from H7 to I8)
For the individuals who are taking the Microsoft Office ProveIt Assessment (Outlook, Word, Excel, and PowerPoint), I highly encourage this video. I passed my tests with an overall score of 90.75. I made sure to add the video to my favorites so that if I am lacking in an area in the future, I can refer back to this video. Clear and concise instructions. The individual teaching this video is a great communicator in the sense that he does not bombard the viewers with confusing information.
I have learned more about excel on this youtube channel, then I ever did in highschool. Thank you for making this so accessible and understandable!
Me too!
Thank you so much for these. I retired 3 years ago and was fairly proficient with Excel. Recently started doing some personal financial work using Excel and was frustrated with how much I had forgotten. These are so well done and exactly what I needed to freshen my skills.
have an excel exam for a promotion at work. havent used excel in 3 years. this has been a great refresher-thank you so much!
It's 2024 and your video is still the most helpful in understanding VLOOKUP, thank you!
Happy to hear that!
True. I got stok in my system in the office. This video saved me now
What is the point of disliking? This tutorial is perfect.
Ikr
Ikr
People are so rude!!
Dislikers would be those who failed to match his lecture
I agree!
Exactly, don't watch the video if you are going to dislike. This video is so helpful.
Two Rules to remember:
First (The Data must be arranged in Vertical Columns)
Second (The Information has to be to the left).
Many Thanks for the clear and simple explanation.
I've been watching your videos all morning just trying to get an idea of how to work with Excel. You have a wonderful way of teaching. I've watched your video's a few times over, taken notes & worked within the program while watching. I will most definitely be using them again to continue to learn Excel. Thank you for what you do. Keep up the good work.
Wow... you are the best teacher I have ever come across
TRUTH!
Say it again!!
Yes, very true.
I've been training VLookups for years...never thought to compare it to an Index in a book or a telephone directory. I will be using this example in future sessions. Thanks for the inspiration!
Glad you said that. I thought it was just me. This is a phenomenon; a game changer. If he could teach rocket science, I could understand it. Pure and plain English. This is where I will be for instruction. And a very big thank you.
Honestly, the best explanation of Vlookup I've ever found! All other explanations are just very confusing but you just made it look like it's a piece of cake! Thank you so much!
I agree 💯
Exactly!!! He explained the way my brain understood it. 4 different arguments.
1: what you know
2: the range
3: the answer you need
4: true or false.
I hope this person is making a ton of money seeing how he is amazing!🩷
And it is done in less than 15 minutes 🎉
You are a born video instructor. Your voice is engaging, your speed with the mouse is not too fast and not too slow, and your progression made sure I did not get lost. I am absolutely coming back to watch this again when I need another refresher. Subscribed!
To summarise the Look Up Function parameters or Four Arguments, it is simply in the letters ( V, T, C, R) or Value of look Up, Table Array, Column Index, Range or FALSE), as easy as ABCD. Many Thanks again for the clear and simple explanation.
I cant explain, how much I appreciate this tutor!!! He explains everything so simple about Excel!!! The examples are great! Thank you so much!!!!!!!
Hey! I normally don't comment on videos, but I wanted to say how great this video is! It's been two years since I've learned this stuff and I feel like I'm being taught it even better!!
Never found that satisfactory video response. I just watched it 1 time and Now i can play with VLOOKUP easily. Hats Off to you. Great teacher. May God Bless you with prosperity and Kindness. Aameen.
Very helpful. Excel has always been one of my biggest insecurities and it intimidates me, your tutorial made me understand the functions and objectives of Excel. Everything I know about Excel then is all cluttered up in my head, this helped me compartmentalized, sort, and regroup to get me a clean start (re)learning Excel.
Thank you so much! Your explanation that the Column Index Number is contextual and not the actual column number (A=1, B=2 etc) was what not many other tutorials covered & exactly why my formula kept failing
The value you bring to us through this education is immeasurable
I have been struggling so much with vlookup and this video cleared up the confusion so well!!
I am currently in an excel class and learning about vlookup. Your video helped me understand it so much better. Thank you
I looked up many vlookup videos and this was the easiest one so far! I have to do it for work and I'm on my second day of struggling. Still not quite sure how I'm going to do it at least now I understand I'm almost there. Lol
I'm going to keep watching this video while I pull up my spreadsheet
Man! Am I glad I found your videos. I'm great with Word and Powerpoint, but Excel is where I suffered in high school with other students being a distraction. Now looking for a new job where strong excel skills are a must, I'd like to get that skill set up. Thanks again!!
I needed to learn about Vlookup for an interview and your channel might be the reason I get the job. Thank you soooo much !
Your videos are super crisp, short and way more informative
You can lock values before moving them by hitting "F4" or by adding "$" signs such as "D1"->"$D$1"
or simply cut the original one and paste it to a new destination if you are going to delete the original destination anyways...cutting and pasting doesn't alter the formula.
Shahid thank you for this tip.
Dragging does the same? I tried the 4 arrow drag(that appears when the cursor is over the borders) and the values did not change. I am new so just asking to make sure. thanks
@@randomjack477 Might be too late now (You might have watched further and this has been answered, I'm not sure), but No, simply dragging will still screw up the formula. If you drag the cell over by 1 cell, then all the information in the formula will be 1 cell off in the direction you drag it to.
Easiest way to understand to get around it is to simply click on the cell you want to move, HIGHLIGHT the formula, copy that (This will copy it as text), click the cell you want to move it to, and then click paste.
The "$" symbols in the tip above are also useful if you understand how to use them.
I'm doing a Coursera review of excel, and they did not explain each of the parts of the formula very well. This was so much clear. Thanks for breaking it down.
Hello..I have a job interview on Monday and the job responsibility stresses the importance of using Excel. I found your videos today and IM EXTREMELY GRATEFUL because of your awesome teaching , I know I will be prepared for this potential job 😊!!
I've never used VCODE before. I watched this video twice and was able to adopt your example to do exactly what I needed in my report. Thank you for being so clear and concise.
Hey man. You're the best. As a gratitude for your free lessons, I don't skip the ads even if I'm not interested in them so that you could earn more ad revenue.
Excel-lent! Appreciate how you zoom in when you're explaining this.
your explanation makes it easier to understand compared to other videos i've watched that made it look so complicated
2017 video, i saw in 2021....and what else, it's the best channel to learn Excel concepts....tysm!
Finally a video that gave me hope to understand it. I thought I'ld never get it. So many confusing tutorials. This is the best so far.
Your explanations and examples were incredibly useful. The best intro video on Vookup that I've seen...and I've looked at over 10 so far! Very well done sir!
LOVE IT!!! So simple to understand. You truly have the gift of teaching. Thank you so much!!!!
This is the best productive and detailed version video I have seen on v look up. Thanks
You are gifted! I love how skillful you are to teach it really kept me fully engage. Thank you!!!
Excellent.... For the first time I heard about Vlookup... I tried it and got succeeded. Great explanation. Keep going on and on. Do educate us and keep your selves englihten
man, it is 2020 now and you are still wonderful, wow . thanks man
Your tutorials are so helpful. My grocery price comparison spreadsheets have never been more efficient, I used to have to do everything by hand
THANKS THIS IS LIKE THE BEST EXPLANATION I'VE SEEN SO FAR
best tutorial for vlookup
This is excellent instruction! I subscribed some time ago but forgot I had. I've watched umpteen videos elsewhere trying to figure out how to do this and lost an entire afternoon. Spent 12 minutes here - and I'm able to move on! Thank you!
This is fantastic, I watched the beginners yesterday and now this one, you are awesome!!!!
Your excel videos are very informative. I used to think using excel was difficult until watching your videos. Thank you so much!
This actually is one of the cleanest explanation I ever heard.
Your teaching video's have made my motivation in finding a new job so exciting! Thank you for your time :)
Excellent teaching! Great, great. Thank you so much for taking the time to do this.
I'm in between jobs and training myself new tools and you made this very easy to understand and the speed that you went was awesome.
Thanks
I knew how to do v-lookup but wasn't sure of its actual value because you can always just use control f or just copy two columns next to each other instead, but the way you used a new reference cell that you can change at any moment made it clear that v-lookup is useful. Thank you so much
I just want to say thank you for teaching us this.. I wish you could be my teacher. Your teaching is so effective
You are an amazing teacher! So clear and concise!
Big love bruh honestly i even went into Microsoft site and couldn't understand it as good as i have from your video
this is actually awesome, im learning a lot thank you for these videos!
You are certainly a great instructor!!! Easy to follow and understand what you are doing. Thanks!!!
Thank you SOOOO MUCHHH... very clear and easy to understand. i am a mom who wants to return to work, so your videos help me a lot. thank you....
I was afraid and intimated by Excel until I discovered your tutorial. THANK YOU!
Seriously, the clearest way to teach excel. Awesome!
your videos make this very simple and accessible, thank you
Your video is easy to understand, and covers everything, thank you!
Best tutorial so far!! The tips on the last part really helps to clarify some questions. I would appreciate if you'll give tips everytime before you end your videos. Thanks!!!!!
You make it soooo easy to understand. Thank you!! Excited learning with your channel.😊❤ I have been sweating tryinh to understand in linkin and to be honest with you some people used difficult words to understand. You made it simple. Again Thank you.
Great video - one tip - it could be improved if you provide a file link so we can work along with the video. Thanks!
best explanation, demo i've seen so far. If you ever do another V lookup that compared part numbers with prices that would be appreciated! thank you
your excel videos are so helpful!!! learnt way more in a few videos as compared to attending an excel course over 3 days lol
Straight to the point these vids are great!
*If TH-cam had stars, I'd give this video & channel 10/10* 💯
Even though i consider myself between an intermediate to advanced excel user, I decided to start from the very beginning...just in case. Low and behold, there were a couple of actions/function in the beginner tutorial that i had not been aware of. it'll save time in the future! Great lessons...plan is, I will watch all 70+ tutorials. Easy to understand and thank you for explaining terms in a simplistic way. Very frustration free :-)
I did find this video to be helpful *_*
thank you, I didn't expect to enjoy learning excel but with your videos, it's just pleasurable
You've earned a subscriber for your splendid way of teaching !
Your videos are so comprehensible, Love them!
Keep educating and sharing your knowledge. Was really helpful thanks.
I sincerely liked the explanation and I am loving learning excel. Thanku so much.
OMG!!! I actually understood this!!! Thank you so much!!! I am in a class of 47 people, I am sharing the links, we need to learn excel for a job.
I love your videos but could you please number them, so that it would be easier to understand which one to watch first? Thanks for taking your time and doing these videos, they are extremely helpful!
Yes. It's a good idea.
Go to his Channel > go to Playlists > "Excel" (I believe that's the name of the playlist where this video is at. The videos should be in order there.
very cleared and very gentled teaching style thumbs up !!!
You have answered all my questions to a T, a much needed refresher. Thanks Teach.
I am really enjoying watching these videos. They are great refreshers for me and they help me understand things more clearer that I was having a hard time with.
you are my life saver . an incredible teacher you are. thank you.
You put so much effort and showcase a lot of patience. Thank You
Wonderfully done! I'm making some instructional videos for elementary students, and I wanted to make sure I didn't leave anything out. Reviewing your videos has helped me very much.
thank you so much sir.Iam studying std 12 and i spend my free time by learning some new features of excel which may be useful in my future
Thank You! You by far are the easiest and most enjoyable learning for technology I have found.
You make excel so much easier and fun 😍
It’s amazing how you explain it and make it so much easier to understand
Your tutorials have been very clear and helpful. Thanks 👍
Your all tutorials about Excel are amazing and I'm learning so much from you💕
But I would like to suggest one thing, Please write tutorials' serial Number on thumbnail so that we can find easily the next one.
Excellent, very easy and simple to understand. Very helpful
Faruk Shaikh I remember watching all videos on the channel one day before accounting exam and got 49 out of it .
Best vlookup Tutorial ever. Thank you so much
Oh man thank you for sharing these tutorials, so well done , I really hope you ll keep providing more
worth the sub. you are not just giving me some revision but also how should i teach my students . (y)
If I could add, instead of writing manually your movie titles, you could have used data validation, and use a drop down list instead. Great tutorial!
I have tried to do this so many times and never succeeded. Finally did it - thank you!
Great video. You made it very simple to understand.
Very helpful. Thank you very much. I need a refresher for work.
This is great, i was able to use it successfully immediately! thank you!
For anyone wondering, you don't have to rewrite the formula, just catch and drag the cell with the formula and move it where you need it. (in this case from H7 to I8)
you helped me SO MUCH for my IT test.
Glad it was helpful!
Truly helpful for we newbies 💯❤️
Can't get any clearer than this! Thank you! 👍