आपका बहुत-बहुत धन्यवाद कि आपने इस प्रकार का वीडियो लेकर आते हैं वह भी बहुत साधारण भाषा में, जो व्यक्ति आपके वीडियो को एक बार अच्छी तरह से देख ले तो उसको किसी प्रकार के दिक्कत का सामना ही नहीं करना पड़ेगा और किसी इंस्टिट्यूट में भी नहीं जाना पड़ेगा आपका बहुत-बहुत धन्यवाद सर
Sir Deepak Ur way Of teach 2 Good.i like So Much few days Ago i was Join coaching for Class There Is Not wel to learn when friend toald me About U I daily Learn Listen Form ur classes
Apko nahi malum ki me apke vdo dekhne se pahle sirf excel me likhna and usko font wise ya color karne ke alava kucha bhi nahi ata tha but aj me puri sheet ko bana ke usme kahi trah k formula laga ke mere boss ko impress karta hu jisse unhone khus ho k meri selry bhi badha di hai Me apka bahut bada abhari hu So ap ase hi bariki vdo banate raho and mene jo apko ek thoda sa pucha hai usk bare me jarur batay so tnx again
सुप्रभातम श्रीमान जी। मैंने आपका "show/hide data" आधारित संबंधित वीडियो देखा जो बहुत ही मजेदार था ।अब मै चाहता हू कि ड्राप-डाउन की सहायता से जिस प्रकार डेटा " Hide /show" होता है ,उसी प्रकार "drop-down "की सहायता से डेटा "Hide"न होकर ,एक साथ बहुत सारे "columns"मे " " formulas"के साथ डेटा चेंज हो जाये ।कृपया ऐसा विडियो भी बनाइये।
Its an awesome video. Weldone... Ek cheez puchni hai... Jese ham drop down row me branch code likhen, or next column me jahan names arhe hain, wahan branch numbers, branch manager number, operation manager numbers sab side by side aajae, Just one drop down list me branch code likhne se.. Ye kese bnega.. Plz b btayein..
Thank you for this tutorial. I have been following all your videos and have learned a lot. I would like to know how to how to use dynamic vlookup for Multiple Value which you unfortunately did not show in the video. As per the tutorial do we need to put a Vlookup formula in each cell for it to update the multiple columns? May I please request you to show us how to use Dynamic vlookup for Multiple Value 🙏🙏
Sir apke video bahut hi kam k hai so tnx But is vdo me ek bat aur apne bata di hoti to bahut hi maza aa jata Jese ki apne bataya ki jo no. Next column ya row me fill karte hai to automatic cell ban jata hai is tarah dat bhi automatic aa jay jis din hum usme kuch likhe jis din us sheet ko kholke likhne jay tab vaha date us din ki automatic aa jaye Please i requested ye bhi bata do sir
Deepak ji kya hum apme excel m apna data ko kisi local disk (D,E) m rakh ke kisi dusri file m apna data dekh saktay h jo hamari in file se connect ho or hamara data sahi aata rahe agar hum us m koi bhe entry kare to Please tell us Thanks Yogesh panchal
Nice sir iski jarurat bahut dada thi sir ek or cheez yadi hum invoice mail value dalte jaye to humare pass jo data h usme se sab kuch minus hota jaye ye kese karenge sir plzz arjent h plzz btaye.
Hello brother, i do follow ur videos and they helped me very much and am so thankful to u. Would u please show to copy data from one sheet to another sheet using vlookup, which ever formula suits. Plz guide me.
Hello, Deepak ji, good morning. aap ki tarah se bahut badhia xl ki very useful & day today works ke liye fayeda wala video aa raha hai. Thank u very much. is video me sab kuch thik thak hai but one thing - mein ek data banake us sheet ko formula hide kar diya to us ke baad jab mein kuch data entry karta hun to ye table update nahi ho raha hai. uska kuch solution hai kya ?
Sir ap ne ek row me formula lagaya hai, jo k ek row tak limited hai. Ab hmein 6, 7 rows me data search krna ho, to kese krengy? Jahan ap ne drop down bnaya us k bary me keh rhi hun k ek row me lagaya hai formula, ek se zyada me kese krengy ?
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Sir helper colum banakar( do cell ko ek me karke name / add) iske bad dynamically update. Vlookup nahi le raha hai value likha raha hai helpe me
Ya countif formula lagane par bhi kam nahi karta hai
Very Nice, Excellent, Superb, Great teacher and extremely great teaching...Keep it up, Sir. You are the best👍👍👍👍👍👍👍❤❤❤
जय हिन्द इस video देख देख ही अपनी लाइफ स्टाइल बदल लिया
इसलिए दिल से शुक्रिया ❤❤❤❤
Bohat hi lajawab chiz btayi hai, great bhai
Sir,Your all Videos are so useful.Thanks.
sach mein aap ek bohot ache teacher hain....
You are awesome Dada.Thanks so much for uploading such important excel videos. 👍👍👍👍
Very useful sir, I will use this in my work
Sir i like very much ur videos, i learn so much with the help ur videos
Sir aap bahut achche sey samjhate ho
Achchi tarah samaj aa gaya aur achcha laga
Deepak Sir,
बहुत ही बारीक, बड़िया और काम की चीज़ बताई, कृपया ऐसे ही बताते रहे, आपके videos से बहुत फायदा हुआ | : )
+Puneet Vij 👍👍
I like your all views and and videos
Teaching is very nice .l am proud of you
Ye video 5 minute me bhi pura ho sakta tha, itna lamba krne ki jarorat nahi thi, but acchha sikhne ko mila
Sir ap video bahut acchi ladti hai
😍
Very2 Thanks to you Sir ..
Very helpful sir
I am.new to.joing this channal.and very instresting learing video
🤗🤗🤗 welcome 😊
very very nice video Sir
Thank you sir ,Actually I was looking this kind of Videos for my Daily Report, I got it .
awsm Dipk ji...sach mein its very useful...Thanks
please make videos on financial modeling. your teaching method is super cool.
Good bhaiji
आपका बहुत-बहुत धन्यवाद कि आपने इस प्रकार का वीडियो लेकर आते हैं वह भी बहुत साधारण भाषा में,
जो व्यक्ति आपके वीडियो को एक बार अच्छी तरह से देख ले तो उसको किसी प्रकार के दिक्कत का सामना ही नहीं करना पड़ेगा और किसी इंस्टिट्यूट में भी नहीं जाना पड़ेगा आपका बहुत-बहुत धन्यवाद सर
+Smart work in Smart phone 👍
Awesome... All in one video tha.... Thanks
😊
Very nice vedio
I LIKE YOUR VIDEO VERY MUCH.
Very nice video
Sir, You are God for me!
Sir aapke sare hi video bahut hi ache h our kam ke h ham chahte h ki aap Google sheet pe video banaye
Super sir
That is very smart form of VLOOKUP. Thanks for publish this video.
Thanks and very usefull video sir.
har video me kuch na kuch sikhne ko milta hai
Vlookup Full Tutorial Basic to Advanced
th-cam.com/video/V4YgQTFLmyc/w-d-xo.html
very clear explanation , Great
😊🤗
Sir Deepak Ur way Of teach 2 Good.i like So Much few days Ago i was Join coaching for Class There Is Not wel to learn when friend toald me About U I daily Learn Listen Form ur classes
Helpful for my requirement as I needed to display data from two different places at same place.
Thanks for update very useful video...
Thnks a lot deepak ji very useful video
Your way of teaching is very good. Please make a video on VBA CODE in excel
+amit singh okay...
Best technology sir i love ur videos
Super sir.....
Nice 1 👍
Great Sir g
Very interested sir thank you so very
Thank u so much sir😊
Nice Video Bundle of Thanks Sir
Good bro very useful tricks
Thank you Deepak jii.
Apko nahi malum ki me apke vdo dekhne se pahle sirf excel me likhna and usko font wise ya color karne ke alava kucha bhi nahi ata tha but aj me puri sheet ko bana ke usme kahi trah k formula laga ke mere boss ko impress karta hu jisse unhone khus ho k meri selry bhi badha di hai
Me apka bahut bada abhari hu
So ap ase hi bariki vdo banate raho and mene jo apko ek thoda sa pucha hai usk bare me jarur batay so tnx again
But mere saval ka solution nahi bataya apne
+Pramod Solanki 👍
+Pramod Solanki ok i will publish a video... Regarding ur query
VERY NICE
Thank you so much sir ji
kya bat sir osm video
Hello Deepak. sumproduct and coutif wala formula se jo ranks hum nikaltay hay kia ye formula dynamic ho sakta hai?
Hanji bilkul.. bas data table format me convert krke formula lagao ✅
Nice video sir
God bless you .. Thank you..
सुप्रभातम श्रीमान जी। मैंने आपका "show/hide data" आधारित संबंधित वीडियो देखा जो बहुत ही मजेदार था ।अब मै चाहता हू कि ड्राप-डाउन की सहायता से जिस प्रकार डेटा " Hide /show" होता है ,उसी प्रकार "drop-down "की सहायता से डेटा "Hide"न होकर ,एक साथ बहुत सारे "columns"मे " " formulas"के साथ डेटा चेंज हो जाये ।कृपया ऐसा विडियो भी बनाइये।
Thanku sir
Nice sir ji
Thanks a lots
ThAnk YoU Deepak Sir
Super 👌 👌 👌.
Its an awesome video.
Weldone...
Ek cheez puchni hai...
Jese ham drop down row me branch code likhen, or next column me jahan names arhe hain, wahan branch numbers, branch manager number, operation manager numbers sab side by side aajae,
Just one drop down list me branch code likhne se.. Ye kese bnega..
Plz b btayein..
Thanks for uploading such a good informative video
Thanks sir ji
Maza aa gaya
thank you deepak sir
ok and thanks deepak sir
Superb
Sir Thank-you so much apki har video unique hoti he thanks again......
very nice brother
Kya month wise sheet pe isko use kar sakte hain
Yaaa sure 👍👍 👍
Thank you for this tutorial. I have been following all your videos and have learned a lot. I would like to know how to how to use dynamic vlookup for Multiple Value which you unfortunately did not show in the video. As per the tutorial do we need to put a Vlookup formula in each cell for it to update the multiple columns?
May I please request you to show us how to use Dynamic vlookup for Multiple Value 🙏🙏
good job
Great
😊
Sir apke video bahut hi kam k hai so tnx
But is vdo me ek bat aur apne bata di hoti to bahut hi maza aa jata
Jese ki apne bataya ki jo no. Next column ya row me fill karte hai to automatic cell ban jata hai is tarah dat bhi automatic aa jay jis din hum usme kuch likhe jis din us sheet ko kholke likhne jay tab vaha date us din ki automatic aa jaye
Please i requested ye bhi bata do sir
+Pramod Solanki ok g i will publish video on this topic as soon as possible...
Deepak ji kya hum apme excel m apna data ko kisi local disk (D,E) m rakh ke kisi dusri file m apna data dekh saktay h jo hamari in file se connect ho or hamara data sahi aata rahe agar hum us m koi bhe entry kare to
Please tell us
Thanks
Yogesh panchal
+YOGI LOHAR yas.. We can do it.. I have published a video to link multiple workbooks together.. Please visit our channel playlist
MR TARUN nice video
Nice sir iski jarurat bahut dada thi sir ek or cheez yadi hum invoice mail value dalte jaye to humare pass jo data h usme se sab kuch minus hota jaye ye kese karenge sir plzz arjent h plzz btaye.
Sure.. I will publish video as soon as possible on this topic
Thnx sir
Hi Deepak
Offset formula use kar sakte hey aapka kya suggestion hey.
Offset formula se bhi to hoga yah kam
👍
Thank you Brother
wel come to Myanmar
very weldone deepak G. I learnt too many things here from your video lessons. Please tell me the exact diff b/w vlookup and lookup?
Okay i will publish a video on lookup hlookup and vlookup
Thank you
Good explain everything
Hello brother, i do follow ur videos and they helped me very much and am so thankful to u.
Would u please show to copy data from one sheet to another sheet using vlookup, which ever formula suits. Plz guide me.
Hai thanks for this
Also can I get also data like pdf or jpeg attachment automatic from my library or another sheet using vlookup match function
VERY NIVCE
Hello, Deepak ji, good morning. aap ki tarah se bahut badhia xl ki very useful & day today works ke liye fayeda wala video aa raha hai. Thank u very much. is video me sab kuch thik thak hai but one thing - mein ek data banake us sheet ko formula hide kar diya to us ke baad jab mein kuch data entry karta hun to ye table update nahi ho raha hai. uska kuch solution hai kya ?
+SANTOSH KUMAR ACHARYA okay... I'll check it...
Good sir ji
Hello Sir, aapne full table ka to bta diya bt agr coloum ka data bahut jayda ho to bina count kiye kya hm vlookup se nikl skte h??
*depak bhai agar mai kahu ki b1 cell me b likha hai to C1 cell me 1 likh jaye to kaise likhenge if ke sath ya other form. ke sath*
Thanks
great
Sir according software demo bataeye sir
Nice
Sir, I want to ask about Pivot table slicer I am using window 2007 so how will add slicer. Pls help me.
Sir ap ne ek row me formula lagaya hai, jo k ek row tak limited hai.
Ab hmein 6, 7 rows me data search krna ho, to kese krengy?
Jahan ap ne drop down bnaya us k bary me keh rhi hun k ek row me lagaya hai formula, ek se zyada me kese krengy ?
To good sir
Thanks sir mujhe Grade ka thora promlem hy mark sheet me grade ka videos Dale plz
G
My WhatsApp number 9102813548
My advance excel sikh liya thanks sir