VLookup in Excel Part 1 | VLOOKUP सिर्फ़ 30 minute में (हिंदी) Excel Lecture 4 | Neeraj Arora
#vlookup #ExcelforBeginners #neerajarora
Hi Guys! In this video, we will learn about VLOOKUP in Excel. VLOOKUP is one of the most important toosl in ms excel. In this video I have talked about how to use vlookup in ms excel and in addition to this we will also learn how to effectively use the vlookup formula. This vlookup tutorial is really going to increase your performance in work. Also, If you are about to appear in an interview and your job requires the use of excel, there are big chances that they may ask VLOOKUP formula.
In this video, we have discussed the following topics.
VLOOKUP definition
VLOOKUP Formula
VLOOKUP Examples
VLOOKUP basic case
VLOOKUP advance case
VLOOKUP Errors
VLOOKUP Approx Match
VLOOKUP Exact Match
VLOOKUP Intersheet
VLOOKUP Misc Topics
इस विडीओ में हमने VLOOKUP को काफ़ी डिटेल में कवर किया है उमीद करता हूँ आपको पसंद आएगी !
=========
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
Link: www.skill91.com/s/store/cours...
😍 Why Choose Excel Club By Neeraj Arora ? 😍
✅ 50+ Detailed pre-recorded videos highlighting every feature & function of Excel.
✅ Access anytime & anywhere On Android, iOS, and Web. Breathe easy and download videos on the fly to enjoy remote access
✅ 350+ Multiple Choice Based Tests to track your progress & evaluate your current level of proficiency with excel
✅ Interviews with Corporate Professionals from World’s Leading Organizations - uncover their experience with Excel & how they use Excel in their daily work to make real-time business decisions.
✅ Real-life use cases of excel that you can use in your job, business, or internship
✅ Certificate from Skill91 that you can highlight in your resume
✅ And above all a 24x7 Discussion Forum where you can ask all your doubts for an unlimited number of times and get personalized responses in a community of more than 3500 students who are learning excel with you RIGHT NOW!
Wondering about validity?
Don't worry. Each enrollment is valid for a SOLID 365 days!
No matter if you're a student, professional, or just looking to get started on MS-Excel
Excel Club will prove to be an EXCELLENT choice for mastering MS-Excel in a unique, fun, engaging, and informative way.
All Prices Running On Discounted Prices. Limited Time Offer Expires Soon.
Пікірлер: 1 300
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥 Link: www.skill91.com/s/store/courses/description/Excel-Club
@MWAIslamicStudio
2 жыл бұрын
I am in Dubai, I can't join excel club, indian number not working here so I added dubai number, now 4 digit code not received, what is the solution
@abhesinh0027
2 жыл бұрын
@@MWAIslamicStudio arasS sa ddzx*Xx Dd
@RT-yv7ev
2 жыл бұрын
Salute you sir, i know V lookup but your teaching skill is excellent with depth knowledge
@RT-yv7ev
2 жыл бұрын
Ek video pivot table pe b dekhna chahunga sir🤗
@poonamshukla3639
2 жыл бұрын
Kahan se khoju vlookup
video starts from 03:84, thank me later.....
@kajalmehra6124
7 ай бұрын
Thankyou
@arindamghatak8461
7 ай бұрын
03:48 aactually
@gunjarajbhar6942
6 ай бұрын
Thanks 😂
@rutvikjani5154
6 ай бұрын
Me watching ur comment after watching full video 😢
@namanshukla9382
6 ай бұрын
@@rutvikjani5154😅
Very helpful , everytime interviewer ask me about vlookup and i alwyz said that i dont know how to use.. but now i can say yes i know what is vlookup and how to use it. Thank you
Easy to Learn, Easy to Understand and Fun while learning, keep going Sir, thank you.
Extremely nice explanation. It cleared all of my doubts.. Thank you very much for his wonderful contribution in society !
Sir, most of the time people make jokes on this but today you proved that this line is not a joke and make this a reality that "sirf naam hi kaafi hai". whole CA family trust u to that extent that as this channel is of Neeraj sir then every video is worth to watch and every time u give more then the expectations. Thank u so much sir.. Respect for u always from heart..!
@PRADEEP3022
3 жыл бұрын
Thank you. Sir❤️
@shrawankumar-yp4xs
Жыл бұрын
S
Finally is vedio ko dekh kr seriously samjh m aya vlookup itna asan h.....this is it
@farooqkota8692
Жыл бұрын
Yes.. same here
Thank you so much sir...your classes are helping me a lot to learn excel in the proper way and gain some confidence🙏
awesome explanation. till now i was always afraid of vlookup, but now you have made it so simple . Thanks a billion...
I had learnt VLOOKUP 2-3 days back.... But saw your full vedio because i knew I will learn something more and GUESS WHAT.. i learnt it and that was APPROX MATCH...
What a teacher🔥 i love the way you teach us🤗
The way of teaching vlookup is far better than other videos which I had seen. Really did good job here. I have finally understood the proper use of Vlookup Sir ji. Thankyou for making this video for us. 😀
I have watched many videos for vlookup formula. I saw many videos but I can say this was the best video I found on youtube. Thank you so much sir for this amazing video of lookup for formula. I can easily now use vlookup formula.
The way of u teaching us , its really very interesting and easy to learn 👏
Awesome tutorial, thanks for sharing. Your way of teaching is very interesting
Trust me, I learned a lot things from this video. Am really thankful to you.
Thank you sir. This video made me v confident about v lookup function otherwise which I was dreadful about it over years. Thank you Sir🙌🏻. God Bless You.
Much awaited video of the whole excel series!!! Thank you so much sir!❤️
@ExcelforBeginners
4 жыл бұрын
More to come. Thanks. Please share with all.
it was really helpful to understand the concept. I tried practical use of it and without any mistake I separated some data from large data file.
You are an Excellent Teacher on KZread. It is very important for every student to learn from you. I like your Teaching video. Excellent training method.
Finally i have understand the concept, after watching this video
Excellent lecture on Excel sir mindblowing and mind opener video😎😎
Sir, ur teaching is awesome, I watched my v-look up, this the No - 1
awesome class sir alot of people around me told that working on excel is so much tough but when I start learning it from you I lov it :)
Superb! Awesome!. I understood vlookup from you. I have checked other videos also. But your way of explaining and understanding that we are bigineers was outstanding. But aap ye excel share karte to aur maza aa jata
Thank you, explained in such a beautiful way. Easily understood 👍🏼
Aaji L mere content real content to ye Hain sir there so many teachers who teaching VLookup but but no one teaching like you your teaching like elder brother (Jo Puri imandari k Saath sikhta h) thanks a lot for giving such solid content.💜
Thank you so much sir for amazing but detailed explanation.
Nicely presented and elaborated. Well done Indev . Keep it up 🌼🌼🌼
Wah Sir, 👏🏻👏🏻👏🏻 Kay Baat hai. Thank you 🙏🏻 so much
sir aapka tarika shandar h . me kabhi kisi video pr comment nhi krta pr is video ne comment krne pr majbur kr diya h ... i salute you
This is great package of excel , sir... love you
@suryabhansingh9630
4 жыл бұрын
Ery good sir bank ke liy best
Thank you so much sir for this video! A topic that I would like you to make a video on is Pivot Table. It plays a very important role in practical life.
really Sir first time i tried to learn Excel nd by seeing your vlookup video you make excel as like ABCD awesome Sir
At the starting of the video. I thought , he is just promoting the brands , but when i watched the full video , i would like to say that , I invested my time in the right place.# thankyou so much sir for the video❤
Thanks sir ab ITT Mai sab impress hojayenge
Thank You very much for such a wonderful teaching.
Thank you so much sir . Learned properly and practiced also in my data
Hello Sir,❤❤❤ I really loved this class, easy, simple, and sorted. I want more helpful videos like this to crack excel.
@poonamshukla3639
2 жыл бұрын
Kahan se khoju VLOOKUP
I don't think I will ever forget the learnings from this video
@satish4426
Жыл бұрын
Did u still remembered this formula ?
Thank you sir....my all doubts of vlookup are cleared and now I'm all set about vlookup
Jitna in sir ka padhane ka style acha hai itna to tution mei achi fees dene k bad bhi koi nahi batata hai. hats of you and your education skills sir.
I really love the way to teach.... Its became very easy for beginners like me to understand and perform on exel. But could u plz guide me how to download excel for free...
I think u should also give the link of data on description for our practice . That will be more beneficial for us
@raquibansari5224
11 ай бұрын
agree
Thank you very much,with fun i learned excel vlookup.very intresting.
Really Appreciate your lecture, Training, and way of teaching, which are most important for all who want to grow & improve their life, especially VLOOKUP.
Respected sir, I've been watching all your Excel as well as GST and all other videos. Your Teaching method is really User-friendly. My suggestion is try to make a Video on "INDEX MATCH" Regards, Thank you
Sir I want all questions of excel for practice if it's available so pls revert me
to be honest i dont know anything about vlookup but thnx to this video ive learned alot about vlookup.... brother you're doing good.... million thanks to you man..... im having excel test for my job interview process tomorrow and u helped me alot.... kudos to you..... lots of love brother..... god bless my man
Brilliant Neeraj sir . you made this program very easy. Thanks for your support.
Hello Sir, I want to learn advanced excel... may I know when you are uploading the same?
@AbhikAbhi
3 жыл бұрын
He won't do it here in youtube... Only in Edu91 website
Sir, please kaam ki baat jada kare.. likes subscribe ka marketing mat kijiye.. video useful hoga to apne aap like milenge...
@musicalyt5627
2 ай бұрын
Right 😢❤
@heartshad910
2 ай бұрын
Sahi baat hai 🙌
Thanks a lot sir great experience , basics Clear about v look up
Kya baat Arora saab. 🙏👍
Sir ITT me ap hi pdhana shuru krdijiye😉 satellite classes k through..
@Nikhilsharma-ry7sh
4 жыл бұрын
Jab samne teacher padaa raha hota hai tab to bacche padte nahi hai satellite se to pad chuke 😂
Sir are there some pen drive classes available for class 12 .... Sir i am a big fan of you ... Want to become a chartered accountant 😊
@ExcelforBeginners
4 жыл бұрын
You can check edu91.org
Thank you so much sir, Concept ke sath smj aa gyaa....
You have presented this video in interesting way.Really useful video to understand Vlookup.
Learning start from 3:58 🙏🏻❤️
3:50 skip
Finally someone could explained it!
Sir, very easy to understand, nicely explained, and humorous too which is nice for the learning process.
बहुत ही अच्छे से समझाया है आपने। धन्यवाद गुरु जी
I learnt very easily of VLOOKUP Excel formula.... Thanks Sir.... For your teaching 🙏🙏
Thanks for sharing this video.
Maza aagaya sir.
EXCELENT WAY OF EXPALANATION Thanks for sharing your knowledge
Thanks a million sir The best and easiest way I have ever experienced for Excel learning.
all doubts cleared sir thank you so much...
Thank you.. it's very helpful for me
Superb video..thank you sir
Supern sir ,Thank you for this gem👍☀️😊
Beautifully explained...thanks I have a doubt and it was beautifully cleared
Thanks a lot Sir.....Highly Appreciated!!!
Maza aa gya. Awesome video. Thank you very very much sir ji
Thanks Sir. You are quite helpful.
Thanks sir , Best video of vlookup on youtube .....👌👌👌👌
Best video for the command.
Bhut hi gazab
Thank you sir for sharing your awesome tutorial, you make us. Understand in a very easy way. Please keep sharing you videos
Thank you so much,,, Its really helpfull.😊🙏🙏
Great teacher of Excel God bless you sir .. thank you
Wah sir
Thank you... one of the most helpful video
Bht saal se pareshan tha . Vlookup ratt liya tha but samajh nhi aaya tha. Aaj samajh aa gya.. I interested for complete course
Thank You So Much Sir for your deep explanation on Vlookup.
You're the best teacher of MS excel.
Thank you sir for amazing video keep posting plss❤❤❤❤❤
Excellent video thanks for uploading
@excel for beginner sach mai maja aaya. Sir ji, abhi puri nahi dekhe but so easy to understand and also so helpful for everyone.
Easy to Understand. Appreciate effort that has been put in
Thank you...your video is the best..!!
Thank u so much for this video, it is very helpful.
Thank you, sir. This is really very helpful.
Gajab
Kya Baat hai sir matlab kya baat hai sir ek dum jabardast tutorial best to learn Vlookup 🙌💥
Professionals(CA, CMA, CS) logo ki baat kuch alag hoti hai... Very sir
Very helpful video, thanku sir
Thank you sir🙏🏻. Life badal di❤️
A lovely way of teaching does not bore even learning from long video.💓💓💓