🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

@sandeepulhe5044

5 жыл бұрын

Sir,you are teaching very well. Thanks a lot sir.

@legaldiary5401

4 жыл бұрын

Bhai mein excel mein ZERO tha,but apke vedio dekh dekh kr accha excel operate kr leta hu...Uppr wala aapki umar lambi krein,aur hum jaise logo ko sikhate rhe,mere pass fee k paise nhi hote the computer sikhne k liye .jab main student tha,but ab aap jaise bhaiyo ki wajah se hi sikha h,jo kuch bhi aata h...thanks a lot...may God bless u

@soumyajit3931

4 жыл бұрын

Sir, can you please help me regarding a particular data validation topic, if the data is such that the first five characters will be alphabets only (A to Z) Sir, I can not use the istext function because istext function considers special characters also as text only. So how can I ensure that only alphabets are entered and not any thing else ? Sir, one more question, is there any function for special characters like isnumber or istext ? Thanking you

Thanks sir Aap hr option Bahut achhi tarah se clear krte hai

namstey deepak sir ji aapke saare videos maine dekhe, sach mai mujhe excel nahi aata tha, lekin videos dekhne k baad mujhe excel aa gaya. thanks

Deepak sir very very nice . You are a great teacher the method of teaching is very very good

Aapka Explain Karne ka tarika bahut acha hai. Aapka ye video muje bahut acha laga. Thank You deepak bhai.

@DeepakEduWorld

6 жыл бұрын

+Pankaj Patil :)

Very nice method of explaining & it ensures clarity. Thanks for good efforts towards spreading knowledge to all needy.

Sir apki video very knowledge wali video hai or apne video me bhot easly explain kiya hai thanku sir

Very nice video sir bahut jabarjast trick hai sir ji thanku sir

Deepak ji , Excellent your teaching method in KZread Easily to understand . I am extremely glad for your tutorial

Aap bahut aache samjhte hai sir

Bhai tu bhot acche se smjhata h..thanks yaar...

@DeepakEduWorld

6 жыл бұрын

wlcm bro

Thanx sir ap bhut achha explain krte hain....

Jabardast Deepak sir..really very good

Aachi videoo kch nya shikhne ko mila thnx

Very helpful video Deepak thanks...

Bhut accha smghaya

Veryhelpful sir thank you

Thank you Deepak Ji, Very useful

Thank you sir ,this is very usefull video 🙏🙏

Thank you so much for your video..❤ aaeise hi video banate raho..🤗

@DeepakEduWorld

4 жыл бұрын

😊😊

Marbulous video sir Thanks for uploading video

Thank you very much

love you sir... ❤🌻🥰

Very Useful Video Sir

Thanks Deepak ji.

Sir ur teaching style is very very good. Ur Every video is under stand able.very helpfull for me.

Bahut achcha laga.

thanks deepak it will help alot

Nice tutorial video...... Thanks

@DeepakEduWorld

4 жыл бұрын

😊😊

sir the video is very useful . . i have learned so many things. i am a teacher. kindly tell me about which type of questions are asked in advance excel interview

great video sir thanku so much for this

Mast he bro...thnx and keep on...

@DeepakEduWorld

6 жыл бұрын

thanks

An excellent video.

Excellent👍

V nyc explanation

Many many thanks to u sir

Very useful, thanks

@DeepakEduWorld

5 жыл бұрын

kzread.info/dash/bejne/mKSnztqJoJbFc9o.html watch it.. You may get an idea.. How to do it

Deepak bhai the way of yr teaching is very unique n excellent lot of things n formulas have learnt from u , i drsire to know how v can put the specific numbers in a specific text that always indicate with that text ..... thank

@DeepakEduWorld

4 жыл бұрын

Custom number formatting 👍

Very good video

Sir, You have excellent explaining skills. Your videos are very helpful for my day to day work in office. I have encountered a doubt. The validation cell/column is ignoring the validation when pasted other data. The cell should prevent and say that "the value you entered can not be allowed". Plz. clarify. Regards.

@ahmadomar1832

Жыл бұрын

i have the same question

Thanks deepak sir

Thx sir very very nice video.

@DeepakEduWorld

5 жыл бұрын

😊

Your video very beautiful friend

Very healthful sir

I really really appreciate with your explanation and very much clarity. Thanks for you effort and knowledge sharing. But, I have a question, In case if user wan't to enter the character like CRC0002001, CRC0002002 etc. Its like your company code, employee code or anything similar. Can we do this using data validation or we have to use VBA.

Excellent

Great 👌

nice video sir

thank you so much sir could you please add 1 videos how would be fix the capital letter in the cells of excel.

Sir, How alphanumeric like PAN No. can be entered in a cell in this process?

Super Deepak

Muje sir cell me 1g,3kg,3ton allow karna he par... Only 1,2,3 digit enter kare to error dikhani hey... To me kya karu.... Please inform me...

Nice video

Good job

very usefull

very good.

great sir

Thanks sir

THAN'S

Thank you

thanks sir

great

Nyc sir..👍 Aapki sari video superb h....👏 But mera bhi 1 *questions* h ki Sir jb text & numberic value 1 saath ho.. --> as232mf56df8 Agr aisa format ho to kya formula lagega ? Plz solve & Send video..🙏

Thanku sir

Thanks

Sir agar name ke saath koi digit enter karne se bhi true hi dikha raha hai... Wo kaise thik kare...?????

Nice Bro

Great tricks........on the line... Sir can you new file....... " Condition formatting & consolidate sheet ..........," Plz make it.............. 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

would you be able to share the custom validation to enter characters eg: 123L (Three number and one Alphabet)

Sir lekin meye istext function use Kar raha hu aur cell meye "a123abc" lekh rakha hu Tb accept Kar raha hai ..tab Koi error msg show Nahi Kar raha.. Sirf only alphabet ke leye kya Karna hoga... Please help...

@DeepakEduWorld

4 жыл бұрын

A12fg4. Agar alphabet's ke sath kuch bhi mix hota hai.. koi bhi number ya symbol.. to wo text hi mana jata hai

Sir, आप gst invoice का video upload करेंगे. ओ भी उसका data और sr no और के हिसाबसे backup के साथ

@kamrulzoha9223

6 жыл бұрын

prabhakar pawar Aap isey 2way me Kar sakte hai 1st aap sirf Data to Table me badal de 2offest see

Please make video on How to make a monthly report on bills prepares in a month and at the end it show total amount of all bills and if there is any correction in any bill it will automatically update in report.

@DeepakEduWorld

6 жыл бұрын

okay .... as soon as possible

Sir man lijiye ki mob. No. Do types ke h, ek 7 digit ka or ek 10 digit ka toh aise condition me kaise is formula ko update krenge.. mtlb mob. No 7 digit ka accept kre ya fir 10 digit ka.. dono ke bich ka bhi digit accept na ho? I tried by using "OR" in the place of "AND" but it didn't work

(?) hi bro , and len furmala is working only if we select one cell iit is not working on column of 12 cell, but if wee drag thatt one cell than it is working , can you please tell me how this and len formula working on multiple selection at one time . because i have tried this on 1 cell than its working , but when i gave it range of (a2:a12) than this formula is not working . please reply me.

Hello sir i liked your all tutorials. And i have one question to ask that is i have 10 alphanumeric values in first column and on the second column i want to enter some values but there should be a condition that is.It takes or enter only between that 10 alphanumeric values which are given in a first column. And Can't take duplicate values or can't take double enter of any values which are present in a first column.

सर एक ऐसा वीडियो चाइए जिसमे मैक्रो रिकॉर्ड करके डाटा 2एनडी शीट पर जाए, लिकिन वह एंट्री तभी हो जब सभी सेल फिल है अन्यथा एंट्री ना हो। सर प्लीज बना दीजिए।🙏🙏🙏

Dynamic dropdown list without duplicates.Suggest your videos

Sir how do you work in zooming screen. During screen recording

Sir excel me custom data validation by pan card number kaise enter karein

सर आप table autoupdate dropdown list ka video upload karo please

@DeepakEduWorld

6 жыл бұрын

sure... as soon as possible

Sir ek error he Jab ham omprakash name type karte he to Jab ham o ke sthan pe zero (0) type kar dete he to bhi results true aata he

Please teach us npv n regression in Excel

Sir koi Negative Sign Number and brackets remove excel sheet ka video banaye.

@DeepakEduWorld

6 жыл бұрын

okay ji... publish as soon as possible

👍

Please share same process for google online sheet

Conditional formating main kase ak symbol use karte hai, please ak video bano do, plz sir ji

@DeepakEduWorld

5 жыл бұрын

G

power point par video banaiye

Sir I want to know if data is in row position some data in below row but 1st 4 col blank & same in remaining row as it's and I want a data in another sheet except 1st row data wants & come out from 3rd row col no.6 ka data out come in another sheet lookup value in 1st row like 1st row and 1st col.

Sir agar 10 number lete hai or enter karte hai sahi chalta hai par data ko delete kar du to error deta hai ye kaise sahi hoga agar koi number dala 5-7 digit ka to error data hai Jo sahi par us data ko hata diya or phir enter kiya to error dene lagta hai massage dene lagta hai aisa kyo

Sir ,welcom, deta entry ka kaam main jo heading hota hai usko requirment ke hisab se make karna parta ha ya apne se khud heading banana parta hai ek videos main deta entry ke headin ke bare main video banaye kya kya aur kaisa kaisa heading hota hai plzzz explain it Ok thanks sir

@DeepakEduWorld

5 жыл бұрын

🤗

Assalam o alikum sir thanks for you nice information plz btaye k number or alphabet ka aik sath validation rule kaise bnayae

@DeepakEduWorld

5 жыл бұрын

Plz video poora dekhiye dhyan se 👍

@wajidkhawaja4141

5 жыл бұрын

Nhi sir mean k hm aik aisa validation rule bnana chahey jis mai alphabets or numbers k ilawa or kuch agr hm apni file mai enter krna chahey tu wo excel hmey error dai dai

Sir please tell me permanently set word formula in excel all work book..

Hi bro How r u, hope you are well. I have a doubt. How to set automatically sms or message to WhatsApp in excel if due date completed? Kindly advise to me.. Thanks

Sir Mujhe Excel Switch Formula Me ek Video banaeye

Niceee

Dear brother, Please how to enter mobile no start fro 0 in data validation. Please show public formulas

Niceeeeeeee

@DeepakEduWorld

4 жыл бұрын

🤗🤗

Sir esme font pr bhi data validation lga sakte hai kya?

sir mujhe ye bhi apko batana tha ki is video ke neeche jo custom data validation & number ki jagah numbes kiha hai.

Deepak ji ifsc code me 11 text+digit milakar hote he to hum kese 4 text aur 7 digit set kr skte he...Plz btaye