Bhai main aapka bahut bada fan hun main aapke pure video dekhta hun aur like tu bhai mujhe ek laptop chahie yaar mujhe kya tum laptop de sakte ho main to main uski kimat dunga please reply dena theek
Great, great, great. Very much useful. In fact I was nil in excel and started watching your videos and keep learning with every video you post. Thanks a lot. Kindly reply all those who are in doubts.
Thank You, Deepak, I have a video request!! ✔ Please make a video on - "How to organize your workstation", How to organizes your data files on PC, How to manage, share, your data while your multiple PCs and Laptops to access data remotely. Please include- Effective Uses of Onedrive, Google Drive. and other free resources to use to increase your productivity. Thank you in Advance!!!! ✔ ✔ ✔ ✔ ✔
दीपक सर, मेरे पास दो एक्सेल शीट्स है (१) कॉलम हैडर में स्टाफ का नाम है और निचे पिछले ४ बार के ट्रांसफर ऑफिस का नाम तथा (२) दूसरे शीट में मेरी कंपनी के २४ ऑफिसेस का नाम है। शीट १ के हैडर बाले स्टाफ को पिछले ४ पोस्टिंग ऑफिस को छोड़कर शेष २० ऑफिस में ट्रांसफर किया जाना है. कुल स्टाफ की संख्या ३००+ है और कुल ऑफिस की संख्या २४ है, जिसमे प्रत्येक स्टाफ का स्थानांतरण पिछले ४ पोस्टिंग वाले ऑफिस को छोड़कर रैंडम तरीके से पिछले ४ पोस्टिंग के अतिरिक्त बचे २० ऑफिस में से किसी एक ऑफिस में किया जाना है, इसके लिए फार्मूला क्या होगा कृपया बताएं।
Hi Deepak... I like the way you explain all the excel formulas but would like to suggest you to kindly improve the way you start your video specially the way you speak "Let's begin this topic". Kindly keep it simple & don't make it unnecessarily childish 🙂.
Sir, u r lessons are so good Sir, pls help me for fetching TXT and num value from query fn. I hav both value in single column. Query fn. Fetches NUM value but TXT value not. Pls help me.
Hello sir can you plz help me I want to add value of different cells by apply different condition how do I do it , I try by using sumifs but this not working
Can the same be performed... Keeping Range 1 and 2 with drop down... Say if data is huge... One cannot type everything.. Please advise.. However I appreciate your teaching skills... It's phenomenal
in attendance sheet, kindly tell how to restrict/lock data entry in sunday column .... in other days data validation work. but dont want list in sunday coulmns.
Master, how to sort out workers monthky shift schedule (drop list by date) pls..... I mean.. If i select a date from drop list need result the worker name by shift....
Agr ham excel mai cash book ya bank book type krty hain to us Kay ledger kay say defferent ledger deferent sheet mai kay say manage ho saky gay wi TB Kay sath
Agar 8.90 +8.90+ 8.90=26.70 Agar mai ye numbers column me likhta hu jaise k I 8 I 90 I I 8 I 90 I I 8 I 90 I I ? I ? I => Formula kya aayega? Total I 26 I 70 I aana chahiye
Hi, Sir, i am solving every excel problem from your videos but now I stuck on one thing can you please make a video on it. I just want to use or maintain data in sheet. purchase order received order and remaining order by order numbers in diffrenet colour(White,black,pink,mustard) and different sizes of garments like (s,m,l,xl) IN FIIFO method so i can track in how much quantity is pending from which order number.
@@DeepakEduWorld okk kal try krungi... Or aapne koi playlist ni bnayi basic to advance excel ki.? Muje excel sikhna h agar koi playlist h toh please link yha share kr dijiye
Google Sheets per formula hide karke dikhao, wo bhi dusre dekh na paye aissa
@Deepak EduWorld
Sir ek entry ko delete karna hai per vo vahi rehni chahiye aur total weight mai minus honi chahiye
Mujhe samajh nai aaya ache se.... Choose function
Sir ji aap ko bola kuch problem hai usko sahi kar do lekin aap ko time nahi hai
NSE WEBSITE KE DATA EXCEL KESE LATE USKA VIDEO BSNAO NA PLEASE.
Sir Kisi word ki jagah uski value ko kaise put kare
Choose formula sumif me use kr skte hai kya
टेक्निकल गुरु जी - तो चलिए शुरू करते है
दीपक sir - दोस्तो exel मैं ना ,,,
Are you agree
🤗🙂😃
🤗🤗☺️👏🏻
प्लीज सर जितनी जल्दी हो सके बना लेना
Xlookup se ho jayega easy
Sir plz share some real time mis reporting data
How find dublicates worksheets , please tell me sir. I request speisly sir
Sir i have some questions so can u solve this
Bhai main aapka bahut bada fan hun main aapke pure video dekhta hun aur like tu bhai mujhe ek laptop chahie yaar mujhe kya tum laptop de sakte ho main to main uski kimat dunga please reply dena theek
Dipak sir muje aapka mobile number chahiye
Great, great, great. Very much useful. In fact I was nil in excel and started watching your videos and keep learning with every video you post. Thanks a lot.
Kindly reply all those who are in doubts.
Plz help me sir.....
Thank You, Deepak, I have a video request!! ✔
Please make a video on - "How to organize your workstation", How to organizes your data files on PC, How to manage, share, your data while your multiple PCs and Laptops to access data remotely.
Please include- Effective Uses of Onedrive, Google Drive. and other free resources to use to increase your productivity.
Thank you in Advance!!!! ✔ ✔ ✔ ✔ ✔
Sir ur way of teaching z superb plus u say very energetically" Mai hu Deepak, aapka dost, so let's begin this topiiiccccc....."👍👍👍
E commerce sales data management in exel pr tutorial bna dijiye please sir 🙏🙏
Thanks Sir
Good video
दीपक सर, मेरे पास दो एक्सेल शीट्स है (१) कॉलम हैडर में स्टाफ का नाम है और निचे पिछले ४ बार के ट्रांसफर ऑफिस का नाम तथा (२) दूसरे शीट में मेरी कंपनी के २४ ऑफिसेस का नाम है। शीट १ के हैडर बाले स्टाफ को पिछले ४ पोस्टिंग ऑफिस को छोड़कर शेष २० ऑफिस में ट्रांसफर किया जाना है. कुल स्टाफ की संख्या ३००+ है और कुल ऑफिस की संख्या २४ है, जिसमे प्रत्येक स्टाफ का स्थानांतरण पिछले ४ पोस्टिंग वाले ऑफिस को छोड़कर रैंडम तरीके से पिछले ४ पोस्टिंग के अतिरिक्त बचे २० ऑफिस में से किसी एक ऑफिस में किया जाना है, इसके लिए फार्मूला क्या होगा कृपया बताएं।
शुक्रिया सर जी धन्यवाद् 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Hi Deepak...
I like the way you explain all the excel formulas but would like to suggest you to kindly improve the way you start your video specially the way you speak "Let's begin this topic". Kindly keep it simple & don't make it unnecessarily childish 🙂.
सर मुझे एक्सेल मे बच्यत का 10 आदमी का accunt फॉर्म्युला चाहीये तो प्लिज विडिओ बना दि जीए ना
Im your fan from Pakistan, Great work Sir...
Go beg
Did u copy from exel is fun?
😂😂😂😂
Good
𝒲𝑜𝓌 𝒻𝒶𝓃𝓉𝒶𝓈𝓉𝒾𝒸 𝓋𝒾𝒹𝑒𝑜.... 𝒮𝒾𝓇 𝓎𝑜𝓊 𝒶𝓇𝑒 𝑔𝓇𝑒𝒶𝓉...👌🏻👌🏻👏🏻💐☺️🤗🤗
Koi fayda ni hua ye video dekha kr😞😞😞😞😞😞
Sir , please make a video on formula =LAMBDA() and use of it with example.
Thaaaaaaaanku sir......
Whenever I m copying the formula down, it says you cannot change part of an array. Why is it so?? . But same error doesn't come when I drag down
I am already write the comments
Why you write 12 in curly brackets ? {1,2}???
Sir lookup value bhi right me kijiye
Tuna badhiya nahi hai
Kaise 🙂 ?
How to maintain ledger from Daybook and sale register
If table is made on a sheet like alpha, gamma and vita, each table has different name some name are same name then how do we solve it by select
Sir please make video with sigma function
Sir, can I use alternate criteria for sumifs function? I want to sum the value if the criteria is "a" or "b". Not for criteria "a" and "b".
Sir, u r lessons are so good
Sir, pls help me for fetching TXT and num value from query fn. I hav both value in single column. Query fn. Fetches NUM value but TXT value not. Pls help me.
how does work vlookup formula if cell contains in time format. Sir
Different worksheet se ye formula lga kar btaye
Sir i want to make excel video can u tell me how (my channel : learn with raj yadav)
Hello sir can you plz help me I want to add value of different cells by apply different condition how do I do it , I try by using sumifs but this not working
Sir can you explain why you take 1,2 in curly bracket in choose formula
This formula is not working in google sheets.
I found it very useful. ?Thankyou sir
Can the same be performed... Keeping Range 1 and 2 with drop down... Say if data is huge... One cannot type everything..
Please advise.. However I appreciate your teaching skills... It's phenomenal
in attendance sheet, kindly tell how to restrict/lock data entry in sunday column ....
in other days data validation work. but dont want list in sunday coulmns.
Sir g..ye kam tou xlook se v kam kr sakte hai
अपनी mail id please share किजिये कुछ excel queries है सर please
Master, how to sort out workers monthky shift schedule (drop list by date) pls..... I mean.. If i select a date from drop list need result the worker name by shift....
Great, pls share advance DGET formula to drag down other Name/multiple value to overcome its deficiency.
Also share mail id and.mobil No
Okk sir ho gaya clear
Please tell how to preview Excel files without opening them.
Very good nice Sir like this video
Thanks for your support as always. Excellent way of teaching.
Awesome..... nice trick... thank you sir
I am not using Choose function but I think it may be useful than other function
Tod he nahi hai bhaiya aapka....
Maja aagaya guru ji 🥰
Very helpful videos.
Wonderful 😊❤️
Very nice training ability
Very very thanks
AOA sir i am already request to you sir KINDLY ms Excel ka full video bna dey request sir
Yes sir pls full video of excel like other teachers pl Do it
Genius has come ....thanks
Sab upar se gya bhai
Made it easier. Thanks!
Thank you sir!!
Agr ham excel mai cash book ya bank book type krty hain to us Kay ledger kay say defferent ledger deferent sheet mai kay say manage ho saky gay wi TB Kay sath
Thank you Sir.
I love it ideas 😍
Agar 8.90 +8.90+ 8.90=26.70
Agar mai ye numbers column me likhta hu jaise k
I 8 I 90 I
I 8 I 90 I
I 8 I 90 I
I ? I ? I => Formula kya aayega? Total
I 26 I 70 I aana chahiye
Hi, Sir, i am solving every excel problem from your videos but now I stuck on one thing can you please make a video on it.
I just want to use or maintain data in sheet. purchase order received order and remaining order by order numbers in diffrenet colour(White,black,pink,mustard) and different sizes of garments like (s,m,l,xl) IN FIIFO method so i can track in how much quantity is pending from which order number.
Bahot usefull video sir
Mind blowing sir
sir i work in hotel store will you make any video related to this and DPR as much as daily dispense material costing should come
sir anko me likha hua 220 two hundred twenty esa likha hua autometic aa skata he kya jisko ank dalne per word me v copy ho jaye
Super knowledge
excel me agar paydata banate he to julay me increment lgata he esa koi option he kya sir ki automatic incriment lga jaye acountable qu
Nice Sir, Ctrl +T se Google sheet me Table creat nahi hota hai.. Google sheet me Table Kaise creat kare..
Lovely sir
Thank You!
sir agr excel me kuch data jo ki = krke liya ho usi data ko bina copy kiye uske sath yog kar skte he kya
fantastic.............
Awesome
Super
Best
MIND BLOWING SIR..
Abc
Very Helpful
Sir excel 2007 vs 2010 vs 2016 & 2019 mai kya anter hai
L
Deepak sir plz tell me that how to eraze empty cell or rows colum in excel sheet.
Outstanding
hello sir how to automatically change date while using cout if or sum if ?
Mene enter kiya toh error aara h
Ctrl press karke rakho... Fir enter kro dear...
@@DeepakEduWorld okk kal try krungi...
Or aapne koi playlist ni bnayi basic to advance excel ki.?
Muje excel sikhna h agar koi playlist h toh please link yha share kr dijiye