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!!!! ✔ ✔ ✔ ✔ ✔
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
@@DeepakEduWorld sir excel mein toh bahot sare formule hai .......toh koun kounsa formula acche se sikh le ...jisse excel mein expert bana jaye ....plz sir reply dijiyega .....?
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.
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.
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
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.
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
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
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 🙂.
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, 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.
Sir ur way of teaching z superb plus u say very energetically" Mai hu Deepak, aapka dost, so let's begin this topiiiccccc....."👍👍👍
Finally, aaj samjh aaya hai mujhe choose as an array function
Im your fan from Pakistan, Great work Sir...
Go beg
Okk sir ho gaya clear
Made it easier. Thanks!
Thanks Sir
Thanks for your support as always. Excellent way of teaching.
शुक्रिया सर जी धन्यवाद् 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Very nice training ability
Genius has come ....thanks
Very helpful videos.
Thank you Sir.
Awesome..... nice trick... thank you sir
I found it very useful. ?Thankyou sir
Thank you sir!!
MIND BLOWING SIR..
Maja aagaya guru ji 🥰
Good video
Thank You!
Very good nice Sir like this video
Very very thanks
Thaaaaaaaanku sir......
Sab upar se gya bhai
Lovely sir
Great sirji👍👍
I love it ideas 😍
Super knowledge
Bahot usefull video sir
दीपक सर, मेरे पास दो एक्सेल शीट्स है (१) कॉलम हैडर में स्टाफ का नाम है और निचे पिछले ४ बार के ट्रांसफर ऑफिस का नाम तथा (२) दूसरे शीट में मेरी कंपनी के २४ ऑफिसेस का नाम है। शीट १ के हैडर बाले स्टाफ को पिछले ४ पोस्टिंग ऑफिस को छोड़कर शेष २० ऑफिस में ट्रांसफर किया जाना है. कुल स्टाफ की संख्या ३००+ है और कुल ऑफिस की संख्या २४ है, जिसमे प्रत्येक स्टाफ का स्थानांतरण पिछले ४ पोस्टिंग वाले ऑफिस को छोड़कर रैंडम तरीके से पिछले ४ पोस्टिंग के अतिरिक्त बचे २० ऑफिस में से किसी एक ऑफिस में किया जाना है, इसके लिए फार्मूला क्या होगा कृपया बताएं।
Good
टेक्निकल गुरु जी - तो चलिए शुरू करते है
दीपक sir - दोस्तो exel मैं ना ,,,
Are you agree
🤗🙂😃
🤗🤗☺️👏🏻
Very Helpful
I am not using Choose function but I think it may be useful than other function
Thanks bhai 👍
fantastic.............
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!!!! ✔ ✔ ✔ ✔ ✔
Wonderful 😊❤️
Outstanding
Awesome
Mind blowing sir
E commerce sales data management in exel pr tutorial bna dijiye please sir 🙏🙏
Tod he nahi hai bhaiya aapka....
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
@Deepak EduWorld
Sir ek entry ko delete karna hai per vo vahi rehni chahiye aur total weight mai minus honi chahiye
प्लीज सर जितनी जल्दी हो सके बना लेना
𝒲𝑜𝓌 𝒻𝒶𝓃𝓉𝒶𝓈𝓉𝒾𝒸 𝓋𝒾𝒹𝑒𝑜.... 𝒮𝒾𝓇 𝓎𝑜𝓊 𝒶𝓇𝑒 𝑔𝓇𝑒𝒶𝓉...👌🏻👌🏻👏🏻💐☺️🤗🤗
Super
Sir , please make a video on formula =LAMBDA() and use of it with example.
Sir please make video with sigma function
Nice video 🙏
1st like & cmnt🤗🙏
🤗🤗🤗🤗🙂
Best
Choose formula sumif me use kr skte hai kya
Please discuss about xlookup & index match
Let's begin this topic...:)
🙂
@@DeepakEduWorld sir excel mein toh bahot sare formule hai .......toh koun kounsa formula acche se sikh le ...jisse excel mein expert bana jaye ....plz sir reply dijiyega .....?
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, 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.
I am already write the comments
Sir can you explain why you take 1,2 in curly bracket in choose formula
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.
Very very helpful video.
Thanks a lot.
Can you please explain what is the function of { } brackets in excel.
WOW BEST TRICK
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
Deepak sir plz tell me that how to eraze empty cell or rows colum in excel sheet.
Google Sheets per formula hide karke dikhao, wo bhi dusre dekh na paye aissa
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
Sir i have some questions so can u solve this
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".
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 lookup value bhi right me kijiye
NSE WEBSITE KE DATA EXCEL KESE LATE USKA VIDEO BSNAO NA PLEASE.
Different worksheet se ye formula lga kar btaye
How to maintain ledger from Daybook and sale register
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
Dear, have small question on how to apply conditional formatting on 3 columns with the help of if and or
Or u can say I need to get cell color changed if I apply conditional formatting for 3 columns
sir agr excel me kuch data jo ki = krke liya ho usi data ko bina copy kiye uske sath yog kar skte he kya
Sir g..ye kam tou xlook se v kam kr sakte hai
Sir Kisi word ki jagah uski value ko kaise put kare
सर मुझे एक्सेल मे बच्यत का 10 आदमी का accunt फॉर्म्युला चाहीये तो प्लिज विडिओ बना दि जीए ना
Please tell how to preview Excel files without opening them.
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
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
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 🙂.
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....
Nice Sir, Ctrl +T se Google sheet me Table creat nahi hota hai.. Google sheet me Table Kaise creat kare..
how does work vlookup formula if cell contains in time format. Sir
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
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 excel 2007 vs 2010 vs 2016 & 2019 mai kya anter hai
Great, pls share advance DGET formula to drag down other Name/multiple value to overcome its deficiency.
Also share mail id and.mobil No
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
Sir ji aap ko bola kuch problem hai usko sahi kar do lekin aap ko time nahi hai
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
hello sir how to automatically change date while using cout if or sum if ?
Mujhe samajh nai aaya ache se.... Choose function