दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰 *My New Channel :* bit.ly/3qFrbl5 *Complete Microsoft Word Tutorial :* ruclips.net/video/Xkq0-xXAj48/видео.html *Complete Powerpoint Tutorial :* ruclips.net/video/OekrBhNybP0/видео.html *Xlookup Complete Tutorial :* ruclips.net/video/0LjfRVD7srU/видео.html *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb *Excel All Formulas :* ruclips.net/video/C9y53fedo04/видео.html *Office Work in Excel :* ruclips.net/video/PT8D1qQwe1k/видео.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 काम करेगा ? यदि हाँ तो कैसे ? उम्मीद है आप मदद ज़रूर करेंगे।
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
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.
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
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.
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..
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* ruclips.net/video/Xkq0-xXAj48/видео.html
*Complete Powerpoint Tutorial :* ruclips.net/video/OekrBhNybP0/видео.html
*Xlookup Complete Tutorial :* ruclips.net/video/0LjfRVD7srU/видео.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* ruclips.net/video/C9y53fedo04/видео.html
*Office Work in Excel :* ruclips.net/video/PT8D1qQwe1k/видео.html
bht bakwas tha.. kam ki bat km bakwas pahle sunni padti h
बहुत ही अच्छी तरह से समझाया है आपने। दरसल ये सच है कि मैं आपकी ही वीडियो देख कर इसे कर पाया। लेकिन मैं ये भी कहना चाहता हूं कि ये वी लुक अप से सिर्फ़ इसी मामले में आगे है कि ये दोनों तरफ़ के डेटा दे सकता है लेकिन ये सिर्फ़ एक ही डेटा दे पाता है। अगर हमें किसी स्टूडैण्ट के सारे डेटा एक साथ प्रिण्ट आउट के लिये चाहिये तो ये इस काम को नहीं कर सकता जब कि वी लुक अप सारे कालम्स के डेटा एक बार में डिस्प्ले कर देता है, इसीलिये वी लुक अप की उपयोगिता कभी समाप्त नहीं हो सकती। ये सिर्फ़ स्टूडैण्ट के नाम के साथ उससे जुडे किसी एक डेटा को एक बार में बता सकता है (फ़ादर्स नेम, रोल नम्बर, किसी सब्जैक्ट के नम्बर इत्यादि) पर ये सारे डेटा एक साथ नहीं दे सकता जो वी लुक अप आसानी से दे देता है, अत: ये सिर्फ़ चैक करने के लिये ही ठीक है। ये रोल नम्बर से स्टूडैण्ट को भी नहीं ढूंढ सकता उसके लिये इसका अलग से दूसरा वर्जन तैयार करना होगा।
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
Very Helpfull Video Just Extracted data after watch watching ur Video...Thanks
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.
Apka tutorial bohot hi powerful hai
very well clarify the formula and i am very happy how you shown by break up of formula 👍 now i am your subscriber..
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
Really your teaching style nd examples are very helpful..... thanks you so much....
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!
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......
Finally i learned it thank you
Very nice approch mr deepak,
Thank you very much...Deepak sir....You are my literally inspiration in IT field.
Sir aap ka video bahut acha lagta hai
😊😊😊❤️
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.
Thank you very much deepak apke sare excel video mere liye bhut helpful hai
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
thanks bro, tons of love from Pakistan
thank you sir ji very much you are best teacher 🙏👍
Thank you very much sir ji. Masterpiece video
Your presentation really great
Great learning video again. Thanks.
Sir, thanks for this video.
very good explaination, thanks for the content
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
Very interesting style se smjhaya apne Thnk you so muxh
🤗😊
Deepak sir, your way of teaching is very good. You are best teacher
🐨🐯🐮🐷🐮🦊🐮🐻🐰🐯🦊🐯🐯🐯🐯🐯🐯🐯🦊🐰🦊🐹🐯🐰🦊🦊🐮🦊
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
You are such a great teacher & your teaching methods also great.
I love your videos
Video bahut badiya h.
Index formula तो जादू है। बहुत पसंद आया। मन में एक प्रश्न है ,यदि drop down दो से अधिक भी हों तो क्या index +match funtion काम करेगा ? यदि हाँ तो कैसे ? उम्मीद है आप मदद ज़रूर करेंगे।
Kya mast formula hai bro maza aara hai formula se khelte hoye
Aap ke bolne andaaz mast hai Deepak sir carry on bro sab ko samaj ajayega thanx bro
Thnaku so much specialy for special trick 👍👍
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
Thank you very much for this informative video. You are doing a great work.
Ham apka Excel ka total video dekh rahe hai
Advance Excel ❤
I PRAY YOUR CHANNEL GROW MULTIPLE TIMES. YOU ARE SUCH A GREAT TEACHER OF EXCEL.
Thanks g 🙏
U r a genius Sirji
THANKS FOR EASILY UNDERSTANDABLE DEMO AND EXPLANATIONS.
Sir ap bhot ache ho hmare confus doors ho gya
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
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.
Superb Combination !!!
Thank you for very informative and useful video
😊
Very nice 👌 thanks sir 👍
Learnt a lot❤️
Thanks bhai.. very good
Thanks Deepak Sir. Please send VIDEO for INDEX + MATCH in Large datas with multiple worksheets.
Each and every steps are explained very neatly. Just bravo brother
I’m waiting for the same functionality in huge data
THANKS A LOT SIR
Very Good Concept
Amazing video sir
It's very useful for me
Thank you.
very good brother ...hats off to you !!
Sir you are very hard work
सर मेने आपके विडियो से बहुत कुछ सीखा हे तो आप मेरे टीचर हुऐ और आज आपको कैसे भूल सकते है
" Happy Teachers day "
Thanks for Teach us
Very easy to understand by such way you explained... *Ontime Edu*
Thanks sir, as usual explained very well.
Thank you sir.
Very good explaining style
Awesome sir ji
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
wonderful & helpful
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.
Great badiya
God always bless you and your knowledge!
Very Nice Formula sir, I clearly understand.. Thank You Sir..
ruclips.net/video/3rvoqNWHqm0/видео.html
Nice job, index aur match function advance use ke vedio ka intezar hai.
Deepak sir thumps up for your energy 💥
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
Awesome Sir. This was very helpful to me and i learn a lot from all your video. Thanks
👍👍😊😊😊
good Mr.deepak, you help me a lot
very well explained
super, very good!
Very Helpful video
Dear Sir very nice
Nice video.
😊😊😊
Sir ek vedio banao jismai more of one sheet mai index formula laga sake.
Very useful
😇
mesmerizng sir
very good
Thanks a lot
Its very good, knowledge booster video. thanks for update.
ruclips.net/video/3rvoqNWHqm0/видео.html
It is very usefull formula for filter data into information
very nice video.really like it keep up the good work.
Sirji if a product has 2 or 3 values how to get the latest rate or 2nd rate or 1st rate???
Thank you sir for publishing this viedo
Thank you so much.
Excellent!!...You should write a book
Awesome. Thanks for the info. Very helpful.
😊
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..
Dhanyawad sir 🙏
Deepak sir Aapka yeah video bahut achha hai, lekin aapne Item name/ Rate Combine Down Drop kaise kiya woh batana please
good lesson
😊
you are best sir g thanks for such fantastic videos.
Superb!!!