दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें 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
You have an excellent understanding of Excel. There are several good courses available online for learning Excel. But all those courses are in English. Which is very hard to understand for those people who are poor in English. Your videos are very helpful to those who don't understand English. But very sad to say that there is no escape from English in India..
I love tha fact, that how you always show previous methods and the new methods. Where you had shown both previous "if" formula then "switch " formula. This extra effort actually helps me to recollect my previous if formula. Thank u for this effort. I have started to watch your videos just recent days, wonderfully explained. A big Thank u. Hope , your channel will grow better 🙏 😊 ❤️ 👍 💙
thanks for ur supporting and explain spellnumber without macros and vb tq one more i want for example (530.39) (five hundred thirty point three nine ) in convert to word in excel
Sir ek school management software banaye jisme macro, advance filter, pivot table, conditional formatting, hyperlinks, vlookup etc. Use kare jisse ki humlogo ko real sense mai use samaj mai aaye.
you don't need to manually change the column index no. Just type 1 in cell A1, type 2 in cell A2 and type 3 in cell A3, Now, you can mention A1 at column index no and simply drag it till marks.
Sir मैंने आपके वीडियो से एक्सेल में बहुत कुछ सीखा है। इस लिए मैं आपका ध्यान वाद करता हूं लेकिन मुझे एक्सेल में वलुकुप फॉर्मूला में कोई भी नंबर या टेक्स्ट डाले ऑटोमैटिक उस समय का टाइम ओर उस दिन का डेट बताए एक ही साथ प्लीज sir thank you so much
Sir mene Jasco Logistics company mein job k liye apply kiya hua ha aur wo keh rahy hain k hmara accounts ka kam ha...to wahan kesy kam krna hoga plz is pe aik video bana dain
Deepak bhai I am trying to get data on the basis GSTIN and Month using same vlookup and switch functions but the formula evaluates #N/A. Kindly help me in this. Actually I want to get whole data for a particular month and for a particular GSTIN
Sir , mene ek invoice banaya h, formule bhi laga die , mgr drag karne per 0 value aati h, usko hide kese kare.. Mene conditional formatting or data validation ka use bhi kar lia mgr baat nhi bani, numbers me jaake bhi 0;; ye sab karke dekh liya, mgr hide Nhi hota h, ab bar bar colour white karna padhta h or fir black.. Koi solution batao plzzz
मेरे पास दो एक्सेल शीट्स है (१) कॉलम हैडर में स्टाफ का नाम है और निचे पिछले ४ बार के ट्रांसफर ऑफिस का नाम तथा (२) दूसरे शीट में मेरी कंपनी के २४ ऑफिसेस का नाम है। शीट १ के हैडर बाले स्टाफ को पिछले ४ पोस्टिंग ऑफिस को छोड़कर शेष २० ऑफिस में ट्रांसफर किया जाना है. कुल स्टाफ की संख्या ३००+ है और कुल ऑफिस की संख्या २४ है, जिसमे प्रत्येक स्टाफ का स्थानांतरण पिछले ४ पोस्टिंग वाले ऑफिस को छोड़कर रैंडम तरीके से पिछले ४ पोस्टिंग के अतिरिक्त बचे २० ऑफिस में से किसी एक ऑफिस में किया जाना है,
Hi. Need your help. I want to know that, can it be possible to create a button in an userform to delete contents of certain cells with a condition that it should ask for a password before deleting the cell contents? Can you please make a small video for this? That would be so helpful.
Hi how can we keep value under 30 in the multiple of 30. like we write 112 and answer should be 22. (30x3=90, 112-90=22). 154(30x5=150. 154-150=4) answer should be 4.
Sir aisi shorcut key btaye jisse copy krne baad paste baar baar kiya ja ske matlb ek baar copy kiya or paste hota rhe dubara copy krne ki jarurat na pda plz tell me
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें 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
Pls upload video to add visible filtered cells in excel.
Sirji, video bahut Acha h
jbtak m iss channel ke excel videos nhi dekhta tbtak aisa lgta hee nhi ki maine aaj excel sikha
thanks @deepak
🙂🙂🙂🙂
You have an excellent understanding of Excel. There are several good courses available online for learning Excel. But all those courses are in English. Which is very hard to understand for those people who are poor in English. Your videos are very helpful to those who don't understand English. But very sad to say that there is no escape from English in India..
Sir, this is the best video.
Thanks a lot. I have not used switch formula. But after seeing your Video, I found it is a very good and useful formula.
Fantastic!!!! Superb Thanks 🙏
I love tha fact, that how you always show previous methods and the new methods. Where you had shown both previous "if" formula then "switch " formula. This extra effort actually helps me to recollect my previous if formula. Thank u for this effort. I have started to watch your videos just recent days, wonderfully explained. A big Thank u. Hope , your channel will grow better 🙏 😊 ❤️ 👍 💙
Favourite Excel Guru
Was unaware of this formula. Thanks bhai.
Sir आपकी vdo बहुत काम आती ह
आप ऐसे ही अच्छी अच्छी vdo बनाते रहे
म आपकी सभी vdo देखता हूं
Thanks. This was really knowledgeable.
Favorite Channel♥️
Maja aa gaya ......muche excel ki vedio acchi lagti h
Ur Ecxel Expert..
Nice, hope it works in reality with the complexities that we face!
Very useful 👌👌
Just 2 words 🙏🏻Thank you 😊
Sir you made things very easy
Nice bro, so helpful
Nice Video Brother
Thanks deepak sir 🙏🙏🙏
very usefull informations
Very nice Sir
Thanks a lot!!
Thanks brother 👍
outstanding sir .
Very nice switch formula in nested megical use thank you sir
Thanks sir,From Bangladesh
Bahot badiya
Amazing thanks for share this idea
Good video. You can use vlookup with indirect and name also.
Good job Sir ji
Keep it up
First like and comment
Interesting video.
Bahot badhiya sir
Nice teaching
Great vedio
Amazing video
U r great sir u make good vedio
Nice video Sir
thank you dost!
Sir thank you. Sir agar bada file hai those vlookup with switch kaise kaam karega?
Best trick with v lookup
Very nice sir
बहुत गजब
Good one
V.NICE SIR THANKS ALOT.
SIR PLEASE UPLOAD A FULL TUTORIAL ON EXCEL.IM EAGERLY WAITING FOR THAT.
YOU'RE TEACHING IS VERY EASY TO UNDERSTAND.THANKS
Superb🌹
Please make a video on excel all formulas in one video 😍
Sir I have learn many thing in excel viewing ur video lectures thnks.
Once I request to upload the video on auto backup of excel file.plz
Thanks sir
Nice bhai. Sadly not available in office 2013.
thanks for ur supporting and explain spellnumber without macros and vb tq
one more i want for example (530.39) (five hundred thirty point three nine ) in convert to word in excel
Very nice
Thank you sir
Great sir
Sweet Deepak I have old version of excel like 10 what i do please guide me and all viewers
Thanks sir ❤️
Loan management software banakar de sakte hain kayaa
Yesterday I tried it on my work book.
Thanku sir
Nice
Super Tricks
sir please upload a full tutorial on excel....
Sir ek school management software banaye jisme macro, advance filter, pivot table, conditional formatting, hyperlinks, vlookup etc. Use kare jisse ki humlogo ko real sense mai use samaj mai aaye.
Sir please is data par mujhe excel me Sara work krna h please bataye
nice video
cool
Please give the link of column formula video.
In excel 2003 I want to write Rs. before number, pls suggest
you don't need to manually change the column index no. Just type 1 in cell A1, type 2 in cell A2 and type 3 in cell A3, Now, you can mention A1 at column index no and simply drag it till marks.
Excel ka pura ek video baba o sir
Sir मैंने आपके वीडियो से एक्सेल में बहुत कुछ सीखा है। इस लिए मैं आपका ध्यान वाद करता हूं लेकिन मुझे एक्सेल में वलुकुप फॉर्मूला में कोई भी नंबर या टेक्स्ट डाले ऑटोमैटिक उस समय का टाइम ओर उस दिन का डेट बताए एक ही साथ प्लीज sir thank you so much
I ll publish video shortly
nice
Sir jee ऑनलाईन एक्सल पर वीडियो बनाओ
Sir mene Jasco Logistics company mein job k liye apply kiya hua ha aur wo keh rahy hain k hmara accounts ka kam ha...to wahan kesy kam krna hoga plz is pe aik video bana dain
Gjb
sir ek question tha print ke bare main
Deepak bhai maine aapse kuch help maangi thi agar mujhe gstin aur month basis pe data extract karna hai to kaise karei. Kindly help me in that
Choose aur switch formula Maine difference kya hai pls reply
sir sheet k rename ko 12345 me badalne ke liya kya karna chahe
sir loan management ka video bannaye please sir please its an urgent
Deepak bhai I am trying to get data on the basis GSTIN and Month using same vlookup and switch functions but the formula evaluates #N/A. Kindly help me in this. Actually I want to get whole data for a particular month and for a particular GSTIN
Deepak bhai maine aapse kuch help maangi thi agar mujhe gstin aur month basis pe data extract karna hai to kaise karei. Kindly help me in that
Sir , mene ek invoice banaya h, formule bhi laga die , mgr drag karne per 0 value aati h, usko hide kese kare..
Mene conditional formatting or data validation ka use bhi kar lia mgr baat nhi bani, numbers me jaake bhi 0;; ye sab karke dekh liya, mgr hide
Nhi hota h, ab bar bar colour white karna padhta h or fir black..
Koi solution batao plzzz
Me excel me bill banata hu to mujhe bill ka pura format dusre workbook me single click se copy karana ho to kya kare? Any vba coding
In which version it works
At first u put value 1 without inverted commas, later u put value 1 in inverted commas, y..pls explain 🙏
Will it work in window 7
School fee management par video banao.
मेरे पास दो एक्सेल शीट्स है (१) कॉलम हैडर में स्टाफ का नाम है और निचे पिछले ४ बार के ट्रांसफर ऑफिस का नाम तथा (२) दूसरे शीट में मेरी कंपनी के २४ ऑफिसेस का नाम है। शीट १ के हैडर बाले स्टाफ को पिछले ४ पोस्टिंग ऑफिस को छोड़कर शेष २० ऑफिस में ट्रांसफर किया जाना है. कुल स्टाफ की संख्या ३००+ है और कुल ऑफिस की संख्या २४ है, जिसमे प्रत्येक स्टाफ का स्थानांतरण पिछले ४ पोस्टिंग वाले ऑफिस को छोड़कर रैंडम तरीके से पिछले ४ पोस्टिंग के अतिरिक्त बचे २० ऑफिस में से किसी एक ऑफिस में किया जाना है,
Hi. Need your help. I want to know that, can it be possible to create a button in an userform to delete contents of certain cells with a condition that it should ask for a password before deleting the cell contents? Can you please make a small video for this? That would be so helpful.
Qlickview ko b smjao sir ji
Hi how can we keep value under 30 in the multiple of 30. like we write 112 and answer should be 22. (30x3=90, 112-90=22). 154(30x5=150. 154-150=4) answer should be 4.
How to Edit PDF Invoice....Plz Ans me
सर मेरे लैपटॉप मैं स्विच फार्मूला नहीं लग रहा है
This will work in excel 2019
bhai power bi bhi karado jaise excel karaya h vaise hi power bi karado
Hello sir MS word pr complete tutorial kab aa Raha h please sir upload kijiye
Sir aisi shorcut key btaye jisse copy krne baad paste baar baar kiya ja ske matlb ek baar copy kiya or paste hota rhe dubara copy krne ki jarurat na pda plz tell me
New table
like it
Namaste sir 🙏🙏
मेरे प्रॉब्लम आ रही है सर
मेरे पास value तो text है और result के लिए संख्या ह कोई switch जैसा fourmula बताइए
धन्यवाद सर