Hi!deepak sir.I'm from pakistani.Liked your video too much.These topic taught by our teacher wasnt clear enough,he potrayed like its diff topic but you made it too easy that im able to use it in every situation related too.
Hi!deepak sir.I'm from British pakistani but pakistani.Liked your video too much.These topic taught by our teacher wasnt clear enough,he potrayed like its diff topic but you made it too easy that im able to use it in every situation related too.
Sir I have got much respect after learnt excel from your website I have almost watched all the videos on your eduworld channel sir G thank you so much. Sir do me a favor I have to combine the contain of many workbook into a single worksheet so please publish a video illustrating easy way to do so, thanks
V lookup se to jada powerful hain but if we have huge amount of data firstly we have to find a lookup value row (number ) and in that case it will take too much time so vlookup choose formula is far better than this.
i think you should simply type or copy the value rather than using formula when you have to type row numbers to get values related to the product name , if that product is something else than mouse we have to change the formula itself
Hii sir apki sabhi Vedio bahot kamal ki rahti hai sir Maine fully automatic gst invoice ready kiya hoon Usme total gst value ata hai but mujhe 18%gst and 5% gst ki value alag alag dikhani hai please help me thanks
Mtlb ye basic h abhi lekin index match function agar aa jayga use krna then agar mouse ki jgah speaker select krenge toh value automatically change ho jaygi??
Nice video sir,waiting for next videos. Sir ms access me relationship create karne ke liye table me kya similarity hony chiye mera matlab hai kise base pe hum table ko connect kartain hai. Please guid me sir.
Yes sir you are right index formula is better than vlookup formula but sir hum index formula KO badi table per to use nahi Kar sakte because jyada badi table me hum exact row and column ko kaise guess kare small table me to yeh easy hai but badi table me nahi you please give me tha reason
@@DeepakEduWorld but sir main apki baat se agree hu but index formula me row number calculate karna jyada difficult hai But sir I like your way to teach thankyou sir
Deepak Ji. Plz Understand my problem........ Now a days main excel main Point of sale banny ki try main hu. Jis main Items ki Purchase Invoice bany, phr unhi products ko sale invoice bana kr sale kia jaye. isi trah sy agr stock return ho tu uski return invoice bany. phr in tmamam invoices ko excel date wise calculation kr ky humain stock bhi maintain kr k dy, humari total sales r expences ko bhi maintain kry r month end pr humain profit loss bhi show kry kia ya sb krna excel main possible hai ya main asy hi apna time r mind waste kr raha hu. agr ya possible hai tu kia iss p koi tutorial bana skty hain ya guide kr skty hain??
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Bhai hme aapse bat krni h ...
contact no ❤️
79 85 07 98 53
Chutiya samjhana aata nahi h
@@khanhaseebGulshi
Computet
9118736807
Hi!deepak sir.I'm from pakistani.Liked your video too much.These topic taught by our teacher wasnt clear enough,he potrayed like its diff topic but you made it too easy that im able to use it in every situation related too.
Hi!deepak sir.I'm from British pakistani but pakistani.Liked your video too much.These topic taught by our teacher wasnt clear enough,he potrayed like its diff topic but you made it too easy that im able to use it in every situation related too.
Excellent sir 👍👍
Thank you sir.
It's very helpful
sir aapki language bahot easy hai , I am learning excel, with the help of you. Thanks
Thanks a lot sir 🙏The way you make understand is awesome 👌 whenever I feel difficulty in any topic I watch your videos.
Superb and very simple explanation hence everyone could understand... Good work
Bhai mene excel ke bohut video dekhe lekin kese ne b douts clear nhi kare formula kya ha nhi bataya but aap me clear tarike se bata diya. Thank u👍
Wah.. supr se bhi upr h
Very nicely explained difference between Vlookup and Index. Thank you.
great Well explained.
Very useful vedio thanks for the sharing Deepak ji
Very informative video. Thanks.
Verry good explanation sir...thank you.....
Superb Sir I like👍 your way of teaching it's simple and superior.
Lovely Video ❤️
great job. a big Salute to you. no one can teach like you.🙏🙏
Bht ache se smjhate ho ap sir.. very helpful video.. thank you
शानदार
Excellent explanation....
You explain very well. thanks Deepak. Love from pakistan
Very very thanks.
in this video u mention index match formula but u show only index dont be foul to other . very vad experience
So useful video sir
Thank you.very helping.
very useful video...
👍
Deepak Sir,
एक दम झकास | ; )
Zabardast Sir G Ab Jaldi Say Index Match Function Ki Bhi Video Bana Dalain.
excellent brother .thanks for posting
Very useful
Keep educating
Thanks
hi Deepak ji I like your. videos these are very useful thanks
Super Hit Video Sir
Very nice 👌👌
Sir celling floor function ke upar video banaye please sir because your video is very nice 👍👍👍
Very nice update hai
Sir I have got much respect after learnt excel from your website I have almost watched all the videos on your eduworld channel sir G thank you so much. Sir do me a favor I have to combine the contain of many workbook into a single worksheet so please publish a video illustrating easy way to do so, thanks
Ya sure.. I will publish it as soon as possible
👍 👍
Noor Qamar
Watch my video for your answer
th-cam.com/video/ni2fU1kYIwU/w-d-xo.html
first time i got index function
best video and explanation sahi hai bhidu. keep up the good work and thank you
Really appreciate your work, Index formula works very well except in case of data validation.
For excel advanced video visit www.TH-cam.com/c4ccoachingforcareers
The approach to the subject is good thank you
Thank you sir for publishing this viedo .good explanation
Great Video of you sir thanku so much sir ..
Bahut accha sir
Mind blowing sir
good effort man
Great bhai thanks
Thank you sir 😊
very nice sir ji
Nice video Sir.....thanks
Index formula 👍👍👍
Bindasss,...😅🙏
Thank you very much bro for such a wonderful trick, anxiously waiting for next lecture
For excel advanced video visit www.TH-cam.com/c4ccoachingforcareers
Superb.
Sir plz next video aap Choose formula ki bana do.. vlookup+choose.....🙏
Sir ap mis executivve course karate Kia online
Thanks sir
☺️
Vlookup Full Tutorial Basic to Advanced
th-cam.com/video/V4YgQTFLmyc/w-d-xo.html
Supar sar
Superb
Very nice
Thank you sir
ur video is so useful
i have gotten a job due to ur video
Great !!!
Good
V lookup se to jada powerful hain but if we have huge amount of data firstly we have to find a lookup value row (number ) and in that case it will take too much time so vlookup choose formula is far better than this.
Match formula include krke best ho jayega
Thanks sir ji
excuse me Sir, all the best 👍✍👍
Deepak ji if i don't the row no. then how can i use the index fuction ?
Thanx!Thanx!
TNX SIRJI
Agar isi me ek se jada ki dwtails nikalni ho to matalb ki agar vlook ki trha pure column ki details chahiye to kyaa karege
Complete vlookup tutorial th-cam.com/video/V4YgQTFLmyc/w-d-xo.html
Thank_You
thanks sirji
i think you should simply type or copy the value rather than using formula when you have to type row numbers to get values related to the product name , if that product is something else than mouse we have to change the formula itself
Hii sir apki sabhi Vedio bahot kamal ki rahti hai sir Maine fully automatic gst invoice ready kiya hoon Usme total gst value ata hai but mujhe 18%gst and 5% gst ki value alag alag dikhani hai please help me thanks
good
👌👌👌👌👌👌👌👌
Good afternoon sir,
Mtlb ye basic h abhi lekin index match function agar aa jayga use krna then agar mouse ki jgah speaker select krenge toh value automatically change ho jaygi??
Thank you
Thx
I think index function is useless because if we have to calculate the row no. From large data...then I can look for the value manually
💻💻💻💻💻
Sir excercise ke liye inki pdf vagera bhi available karaye
Ok g
Nice video sir,waiting for next videos. Sir ms access me relationship create karne ke liye table me kya similarity hony chiye mera matlab hai kise base pe hum table ko connect kartain hai. Please guid me sir.
Yes sir you are right index formula is better than vlookup formula but sir hum index formula KO badi table per to use nahi Kar sakte because jyada badi table me hum exact row and column ko kaise guess kare small table me to yeh easy hai but badi table me nahi you please give me tha reason
Badi table m to vlookup m b column number dene k liye columns count karna hi hoga dear..
@@DeepakEduWorld but sir main apki baat se agree hu but index formula me row number calculate karna jyada difficult hai
But sir I like your way to teach thankyou sir
@@surbhibansal5429 you can use this tutorial...
th-cam.com/video/ulA2yMAeNvs/w-d-xo.html
Sir vlookup is better because in index, you have to apply index again and again
Thanks
deepak sir wordpad and notepad ka vedio h kya
Nhi
Excel ke sare formule jaise sum sum if etc inse related bi video bheje
नमस्ते सर, ms access के भी tutorial शुरू कीजिये सरजी
नमस्ते g... I will publish shortly
ok Thanks sir
Deepak Ji. Plz Understand my problem........
Now a days main excel main Point of sale banny ki try main hu. Jis main Items ki Purchase Invoice bany, phr unhi products ko sale invoice bana kr sale kia jaye. isi trah sy agr stock return ho tu uski return invoice bany. phr in tmamam invoices ko excel date wise calculation kr ky humain stock bhi maintain kr k dy, humari total sales r expences ko bhi maintain kry r month end pr humain profit loss bhi show kry
kia ya sb krna excel main possible hai ya main asy hi apna time r mind waste kr raha hu. agr ya possible hai tu kia iss p koi tutorial bana skty hain ya guide kr skty hain??
Sir mughe aap se web designer course sikhnna hai
Deepak bhai vlookup function k sathe aap choose funtion use karo to vlookup a6e say kam karega
Ok g.. I wil publish video shortly
Bhai mc office pr bhi video bnao 👌✌
for example..suppose lookup value hay product id jo ki 1st column may hay... to apko...
=vloolup(A12,choose({1,2},$B$1:$B$6,$A$1:$A$6),2,0)
Bhai If make data filter selected one product down also automatically change it is possible sir ? If possible how to make ?
agar data bohut jyada ho to index problem karega kyuki row number muskil hogi search Karne me
this formula is good but what if your data is large and you want to find the the value of data but dont know the row number?
You should use vlookup for it...
You can use this tutorial..
th-cam.com/video/ulA2yMAeNvs/w-d-xo.html