दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰 *My New Channel :* bit.ly/3qFrbl5 *Complete Microsoft Word Tutorial :* th-cam.com/video/Xkq0-xXAj48/w-d-xo.html *Complete Powerpoint Tutorial :* th-cam.com/video/OekrBhNybP0/w-d-xo.html *Xlookup Complete Tutorial :* th-cam.com/video/0LjfRVD7srU/w-d-xo.html *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb *Excel All Formulas :* th-cam.com/video/C9y53fedo04/w-d-xo.html *Office Work in Excel :* th-cam.com/video/PT8D1qQwe1k/w-d-xo.html
बहुत ही अच्छी तरह से समझाया है आपने। दरसल ये सच है कि मैं आपकी ही वीडियो देख कर इसे कर पाया। लेकिन मैं ये भी कहना चाहता हूं कि ये वी लुक अप से सिर्फ़ इसी मामले में आगे है कि ये दोनों तरफ़ के डेटा दे सकता है लेकिन ये सिर्फ़ एक ही डेटा दे पाता है। अगर हमें किसी स्टूडैण्ट के सारे डेटा एक साथ प्रिण्ट आउट के लिये चाहिये तो ये इस काम को नहीं कर सकता जब कि वी लुक अप सारे कालम्स के डेटा एक बार में डिस्प्ले कर देता है, इसीलिये वी लुक अप की उपयोगिता कभी समाप्त नहीं हो सकती। ये सिर्फ़ स्टूडैण्ट के नाम के साथ उससे जुडे किसी एक डेटा को एक बार में बता सकता है (फ़ादर्स नेम, रोल नम्बर, किसी सब्जैक्ट के नम्बर इत्यादि) पर ये सारे डेटा एक साथ नहीं दे सकता जो वी लुक अप आसानी से दे देता है, अत: ये सिर्फ़ चैक करने के लिये ही ठीक है। ये रोल नम्बर से स्टूडैण्ट को भी नहीं ढूंढ सकता उसके लिये इसका अलग से दूसरा वर्जन तैयार करना होगा।
Hi Deepak, I am working in Aditya Birla Group in Dubai for past 4 years in Field of Excel Automation. And i must appreciate you for the way you are explaining to the learners. I usually do not see the basic videos but your thumbnail was too attractive to refuse. Kudos to Excel. Also in case you or any of your excel enthusiastic friend want to join for some role ill be happy to help. From Mudit Lalwani
Xlookup is really best bhai... And the way u taught me... Bhai.. Nxt level tha...bhot shukriya... Indexmatch b sahi h lekin complex hai... But xlookup mast h
BHAI thank you thank you very much me ye aek formula janta nahi tha or isi vajah se kafi din se mera project atka hua tha but ap ne aj bata ya to kayi dino ka baki project mera khatam ho gaya ........ agian thank you very very much sir......
Index formula तो जादू है। बहुत पसंद आया। मन में एक प्रश्न है ,यदि drop down दो से अधिक भी हों तो क्या index +match funtion काम करेगा ? यदि हाँ तो कैसे ? उम्मीद है आप मदद ज़रूर करेंगे।
Sir , achha mis report bananeke liye kon kon se excel formulas ki Sabse jaada jarurat hai kya iska ek video upload kar sakte hai? I really trust you sir. It's really good whenever I watch Ur videos I gain more knowledge in excel. thank u so much sir.
Whenever ur doing.. Please do it with full column and row..please don't do it in drop down.. That is the one thing u please change.. Apart from that ur the best from all.
Sir , ek request hai aap se. Sir koi aisi video banaiye unlogon ke liye Jo aapki advanced level ki Puri videos dekhne ke baad and unki practice ke baad , apne aapko test kar sakaein. Test video banaiyege please.
Hi Deepak, I have seen number of videos on Advanced Excel, but I found your videos are well explained in details, you have explained very calmly and concept wise. I have saved all your links, your channel is Assets to me. Allah aapko aur success and long life de. Aameen
Dear Deepak Sir good evening how ru hope ur fine sir this video index + Match formulae is really awesome sir please iam requesting you to prepare videos on MIS reports and Dash boards Thank you Sir
Jai hind sir. I am a soldier of indian army Sir apne jo is video me drop down list banayi h itms name/rate ki plz ap use suru se bana ke dikhana taki puri tarah se samjh aa jaye Waise apki independent drop down list ki video dekha hu pr plz ek baar time mile to jarur drop down list ke regarding jo bhi queries h pl clarify karna. Jai hind sir..
Sir, I see your excel videos on youtube regularly. Sir, mere pass file name book 1 excel me Emp Name and uska DL No. hai uske aage mujhe cab Number lana hai. Dusare Excel file name book 2 me 1st column me cab no. and 2nd column me DL No. hai jahan se mujhe book 1 me cab no. value as output lana hai. Vlookup with choose ke though to maine kar liya but index and match se kaise hoga. Please help me sir its urgent. I am waiting for your reply. Your's Vishwa Deepak Pandey
Dear Deepak, I learned this formula, apply on my simple data worked quite satisfactory thanks for that,Now I have a problem I have multiple dependent data for selecting one component, at least five criteria I made a data with cell merge to create it will it work or can you upload new video to explainthis complexity? I willbe very thankful to you.
Sir agar hum ek invoice banate hai just like mobile ka invoice banate hai tab kya ye Kam kare ga formula kyuki Hume product name se hi uske rate ki show karwana hai ya product id se hi uske rate aur product name dno show karwana hoga Aur sir party k name se hi Hume party ka address, GST no. Aur GST kitane percentage lag to hai aur kitane percentage discount de rahe hai ye sab Ho jaega sir bataiye and invoice no., Date order no. Bhi change kaise kare ye bhi hai ek question Aur kya hum log index+match function se students k roll no. Se full details results m show karwa sakte hai ya nahi sir please reply me sir
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* th-cam.com/video/Xkq0-xXAj48/w-d-xo.html
*Complete Powerpoint Tutorial :* th-cam.com/video/OekrBhNybP0/w-d-xo.html
*Xlookup Complete Tutorial :* th-cam.com/video/0LjfRVD7srU/w-d-xo.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* th-cam.com/video/C9y53fedo04/w-d-xo.html
*Office Work in Excel :* th-cam.com/video/PT8D1qQwe1k/w-d-xo.html
bht bakwas tha.. kam ki bat km bakwas pahle sunni padti h
बहुत ही अच्छी तरह से समझाया है आपने। दरसल ये सच है कि मैं आपकी ही वीडियो देख कर इसे कर पाया। लेकिन मैं ये भी कहना चाहता हूं कि ये वी लुक अप से सिर्फ़ इसी मामले में आगे है कि ये दोनों तरफ़ के डेटा दे सकता है लेकिन ये सिर्फ़ एक ही डेटा दे पाता है। अगर हमें किसी स्टूडैण्ट के सारे डेटा एक साथ प्रिण्ट आउट के लिये चाहिये तो ये इस काम को नहीं कर सकता जब कि वी लुक अप सारे कालम्स के डेटा एक बार में डिस्प्ले कर देता है, इसीलिये वी लुक अप की उपयोगिता कभी समाप्त नहीं हो सकती। ये सिर्फ़ स्टूडैण्ट के नाम के साथ उससे जुडे किसी एक डेटा को एक बार में बता सकता है (फ़ादर्स नेम, रोल नम्बर, किसी सब्जैक्ट के नम्बर इत्यादि) पर ये सारे डेटा एक साथ नहीं दे सकता जो वी लुक अप आसानी से दे देता है, अत: ये सिर्फ़ चैक करने के लिये ही ठीक है। ये रोल नम्बर से स्टूडैण्ट को भी नहीं ढूंढ सकता उसके लिये इसका अलग से दूसरा वर्जन तैयार करना होगा।
Very Helpfull Video Just Extracted data after watch watching ur Video...Thanks
Sir aap ka video bahut acha lagta hai
😊😊😊❤️
very well clarify the formula and i am very happy how you shown by break up of formula 👍 now i am your subscriber..
thanx buddy. was tring to apply multiple match function with Index but I was getting confused. video helped me to get the huge number level.
Hi Deepak,
I am working in Aditya Birla Group in Dubai for past 4 years in Field of Excel Automation.
And i must appreciate you for the way you are explaining to the learners.
I usually do not see the basic videos but your thumbnail was too attractive to refuse.
Kudos to Excel.
Also in case you or any of your excel enthusiastic friend want to join for some role ill be happy to help.
From
Mudit Lalwani
Hi Deepak... Any opportunity for PPT and excel skillset
Hi Am looking for the same
😳
L
Xlookup is really best bhai... And the way u taught me... Bhai.. Nxt level tha...bhot shukriya... Indexmatch b sahi h lekin complex hai... But xlookup mast h
most of your video I am watching. Its very helpful. Thank You
BHAI thank you thank you very much me ye aek formula janta nahi tha or isi vajah se kafi din se mera project atka hua tha but ap ne aj bata ya to kayi dino ka baki project mera khatam ho gaya ........ agian thank you very very much sir......
Bundle of Thanks Sir Ap Ney kafi Intizar Karwa. Zara Jaldi Jaldi Video Launch Karin.
Ok g.. My sechudle was too busy.. But now i will try to publish videos regularly
Really your teaching style nd examples are very helpful..... thanks you so much....
Apka tutorial bohot hi powerful hai
Very nice approch mr deepak,
Your mic gives best quality out put...
thanks dipak sir ji aap bohat acha Kam kar rahe ho .ek kahavat he Gyan batne se Gyan badhta he.
Very interesting style se smjhaya apne Thnk you so muxh
🤗😊
Thank you So much Deepak Bhai for your wonderful work. You're an Angel and Blessing in disguise. Bow to the Excel King, Excel Knight. God Bless!
Starting se table ka define krege to aur jada better hoga .. because beginners k lie bhi acha h..phle se hi table and sb rkha hota h apne
Sir plz upload video on daily basis. We want to learn more from you . video was splendid .
Ok g.. I will try to publish videos daily
Index formula तो जादू है। बहुत पसंद आया। मन में एक प्रश्न है ,यदि drop down दो से अधिक भी हों तो क्या index +match funtion काम करेगा ? यदि हाँ तो कैसे ? उम्मीद है आप मदद ज़रूर करेंगे।
Thank you very much deepak apke sare excel video mere liye bhut helpful hai
Thank you very much sir ji. Masterpiece video
Thank you very much...Deepak sir....You are my literally inspiration in IT field.
Finally i learned it thank you
thank you sir ji very much you are best teacher 🙏👍
Sir , achha mis report bananeke liye kon kon se excel formulas ki Sabse jaada jarurat hai kya iska ek video upload kar sakte hai? I really trust you sir. It's really good whenever I watch Ur videos I gain more knowledge in excel. thank u so much sir.
G blkul
very good explaination, thanks for the content
Deepak sir, your way of teaching is very good. You are best teacher
🐨🐯🐮🐷🐮🦊🐮🐻🐰🐯🦊🐯🐯🐯🐯🐯🐯🐯🦊🐰🦊🐹🐯🐰🦊🦊🐮🦊
Aap ke bolne andaaz mast hai Deepak sir carry on bro sab ko samaj ajayega thanx bro
thanks bro, tons of love from Pakistan
You are such a great teacher & your teaching methods also great.
I love your videos
सर मेने आपके विडियो से बहुत कुछ सीखा हे तो आप मेरे टीचर हुऐ और आज आपको कैसे भूल सकते है
" Happy Teachers day "
Thanks for Teach us
Great learning video again. Thanks.
Your presentation really great
Kya mast formula hai bro maza aara hai formula se khelte hoye
Thnaku so much specialy for special trick 👍👍
Sir, thanks for this video.
I PRAY YOUR CHANNEL GROW MULTIPLE TIMES. YOU ARE SUCH A GREAT TEACHER OF EXCEL.
Thanks g 🙏
Thank you very much for this informative video. You are doing a great work.
Whenever ur doing.. Please do it with full column and row..please don't do it in drop down..
That is the one thing u please change.. Apart from that ur the best from all.
Sir ap bhot ache ho hmare confus doors ho gya
Sir , ek request hai aap se. Sir koi aisi video banaiye unlogon ke liye Jo aapki advanced level ki Puri videos dekhne ke baad and unki practice ke baad , apne aapko test kar sakaein. Test video banaiyege please.
Ham apka Excel ka total video dekh rahe hai
Advance Excel ❤
Hi Deepak, I have seen number of videos on Advanced Excel, but I found your videos are well explained in details, you have explained very calmly and concept wise. I have saved all your links, your channel is Assets to me. Allah aapko aur success and long life de. Aameen
Thanks Deepak Sir. Please send VIDEO for INDEX + MATCH in Large datas with multiple worksheets.
Thank you for very informative and useful video
😊
Amazing video sir
It's very useful for me
Thank you.
Video bahut badiya h.
THANKS FOR EASILY UNDERSTANDABLE DEMO AND EXPLANATIONS.
Thanks sir, as usual explained very well.
very good brother ...hats off to you !!
Deepak sir please start making video on SAP in costing field it will helful to most of us. Because your explanation is superb .
Okay g.. I will publish video shortly
Dear Deepak Sir good evening how ru hope ur fine sir this video index + Match formulae is really awesome sir please iam requesting you to prepare videos on MIS reports and Dash boards Thank you Sir
Ok g.. Please wait.. I will publish video as soon as possible
Nice job, index aur match function advance use ke vedio ka intezar hai.
U r a genius Sirji
Jai hind sir.
I am a soldier of indian army
Sir apne jo is video me drop down list banayi h itms name/rate ki plz ap use suru se bana ke dikhana taki puri tarah se samjh aa jaye
Waise apki independent drop down list ki video dekha hu pr plz ek baar time mile to jarur drop down list ke regarding jo bhi queries h pl clarify karna.
Jai hind sir..
Thanks bhai.. very good
Awesome Sir. This was very helpful to me and i learn a lot from all your video. Thanks
👍👍😊😊😊
Each and every steps are explained very neatly. Just bravo brother
I’m waiting for the same functionality in huge data
Superb Combination !!!
Very easy to understand by such way you explained... *Ontime Edu*
Very Nice Formula sir, I clearly understand.. Thank You Sir..
th-cam.com/video/3rvoqNWHqm0/w-d-xo.html
THANKS A LOT SIR
God always bless you and your knowledge!
Sir you are very hard work
very nice video.really like it keep up the good work.
Learnt a lot❤️
Its very good, knowledge booster video. thanks for update.
th-cam.com/video/3rvoqNWHqm0/w-d-xo.html
Sir ek vedio banao jismai more of one sheet mai index formula laga sake.
Very good explaining style
Very nice 👌 thanks sir 👍
Very Good Concept
Awesome sir ji
good Mr.deepak, you help me a lot
Sirji if a product has 2 or 3 values how to get the latest rate or 2nd rate or 1st rate???
Sir, I see your excel videos on youtube regularly. Sir, mere pass file name book 1 excel me Emp Name and uska DL No. hai uske aage mujhe cab Number lana hai. Dusare Excel file name book 2 me 1st column me cab no. and 2nd column me DL No. hai jahan se mujhe book 1 me cab no. value as output lana hai. Vlookup with choose ke though to maine kar liya but index and match se kaise hoga. Please help me sir its urgent. I am waiting for your reply.
Your's
Vishwa Deepak Pandey
Deepak sir thumps up for your energy 💥
Awesome. Thanks for the info. Very helpful.
😊
Thank you sir for publishing this viedo
Thank you sir.
Deepak Sir,
बहुत बड़िया | ; )
wonderful & helpful
if there are more than 2 moues or product, can it sum it like vlook up? if not pls guide for the same. thank you.
very well explained
Excellent!!...You should write a book
you are best sir g thanks for such fantastic videos.
Dhanyawad sir 🙏
super, very good!
Deepak sir Aapka yeah video bahut achha hai, lekin aapne Item name/ Rate Combine Down Drop kaise kiya woh batana please
Nice video.
😊😊😊
It is very usefull formula for filter data into information
good lesson
😊
Very Helpful video
Dear Deepak, I learned this formula, apply on my simple data worked quite satisfactory thanks for that,Now I have a problem I have multiple dependent data for selecting one component, at least five criteria I made a data with cell merge to create it will it work or can you upload new video to explainthis complexity? I willbe very thankful to you.
Dear Sir very nice
Sir agar hum ek invoice banate hai just like mobile ka invoice banate hai tab kya ye Kam kare ga formula kyuki Hume product name se hi uske rate ki show karwana hai ya product id se hi uske rate aur product name dno show karwana hoga
Aur sir party k name se hi Hume party ka address, GST no. Aur GST kitane percentage lag to hai aur kitane percentage discount de rahe hai ye sab Ho jaega sir bataiye and invoice no., Date order no. Bhi change kaise kare ye bhi hai ek question
Aur kya hum log index+match function se students k roll no. Se full details results m show karwa sakte hai ya nahi sir please reply me sir
Great badiya
i like it very much in this field have co to the other function in this have no change other wise this idea what is this value in the cell
very good