Complete Data Validation in Excel Every Excel user must know this.

I have put my best to make this video of excel data validation, here i have explain what is the use of data validation in excel?, This is what i called for it Data Giri in Excel tutorial, so if you don't know what is the use of data validation in excel then you must watch this complete video, one more thing as i told you to work properly on data you need to learn Power query and Power Pivot to learn this please do check the Ajay Kumar Channel on KZbin
Attend Satish sir's Online Webinar Free: courses.skillc...
#ExcelTips
#ExcelTutorial
#Excel
To Watch Power Query and Power Pivot Visit Ajay Sir Channel :
/ @ajaykumarparmar
To Download File for Practical Visit Below Website and Find the Download link : drive.google.c...
31 Powerful formula of Excel Must Watch :
• 31 Excel Powerful Form...
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_c...
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Telegram channel: telegram.me/le...
Check our latest blogs: learnmoreindia...
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Exce Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My KZbin Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu
Excel Amazing Features - • समय बचाना है तो सीखो य...
Excel Advance 100 Videos - • Excel Introduction In ...
Excel VBA Series in Hindi- • What is VBA in Excel? ...
Excel MIS Videos - • ये सीखने के बाद एक्सेल...
AUTOCAD SERIES : • ऑटोकैड सीरीज अब हिंदी ...
Technology Videos - • Interview Preparation ...
Computer Hardware in Hindi - • कंप्यूटर रिपेरिंग सीखन...
Tags - Learn More, Learn More Channel, Technology Tricks, Computer Tricks,

[@Learn_More_Pro]

Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/

[@sripal.jain4]

Concerned topics are explained very well. At my age of 70, these videos are helping me a lot to improve my EXCEL skill, I wish to continue learning...

[@sharmajiclasses7509]

Sir I have feeling inspiration having look your concentration your age is septuagenarian but having look your concentration I woke up and will doing go ahead in own future

[@somya102]

Sir aap 70 saal ki umar ma bhi kaam kar rahe ho issa badi nakamyabi aur kya ho sakti hai

[@vinitthakur302]

@@somya102 sikhne ki koi umar nahi hoti dear koi 70 ki age me sikh raha hai to woh kamyab nahi kis tarah ka mindset he aapka

[@zdrashdi]

@@somya102 aap kamyabi ko shayad jaldi men ghalti se nakamyabi likh gae haen.

[@AshishJha-f2t]

[@vikashbgs]

Main yah sikhne liye institute ko 5000 paid kiya fir v nhi sikh paya, Lekin aapke video se free me sikh gya. Thanks sir....👍👍👍👍👌👌👌

[@aligyoutuber_420]

Bilkul sahi,,,q ki wanha sirf passa chahiye Or thoda bht basic sikha dete hain

[@kamleshnargawe1]

01:33 Data validation introduction 08:20 Condition 1 10:00 Text (Validation for Name) 11:20 Text length (Mobile No.) 12:45 Duplicate Number (Aadhar No.) 15:15 Date Validation (DOB) 17:00 Time Validation (Time) 18:05 Custom Data validation (Age) 18:36 List Data validation (City) 21:20 Input Message (Landline No.) 22:12 Decimal Validation 22:40 whole Number (Rating Point) 24:24 Indirect Validation 27:42 Name Manager 👇Plz Like This Comment

[@gaurishankarmehta248]

Thanks

[@KSSV]

Indirect wala formula work nahi kar raha. kya karein??

[@775shahrukh]

8 mint ka intro dedia...kia admi hy ye

[@ghurahuprasadyadav3798]

सतीश सर जी आप जितने महान है। मेरे पास शब्द नहीं है।किस शब्दों में तारीफ करू। आपसे मैने बहुत कुछ सीखा है। सहृदय आभार।

[@sanjogZimbar]

You correctly find the problem of so many people, why they get bored while learning from KZbin. You are doing really good job as making learning interesting by creating in-depth video's for people who seriously want to learn. Your videos which related to Pivot table helped me a lot in my work and that's why I am here writing this to say you a , Big Thanx 👍

[@sanikachipkar4655]

Sir, aapka presentation bahut achha hai 🎉

[@vinodkamath2057]

Great I am 61...retired Banker...njoyed this session ..regularly watch Learn more ..🙏

[@mohdtalibkhan3988]

Bahut khoob can't explain sir I have no words to explain thanks a lot

[@rhythmoflife8272]

इससे अच्छा एक्सप्लेनेशन और नहीं हो सकता। में तो आपका फैन हो गया। बहुत अच्छा।

[@rakeshbond009]

Your way of presenting things is very cool and interested

[@Naseerkhankhel]

kzbin.info/www/bejne/lX2cYX6Iid19r8Usi=ZUDqGoabIpWB7TQ0

[@utkarshsharma4403]

Superb Video sir ji........Poore youtube par aisa koi samjhane wala nahi mila.... Hats off to you. All concepts are clear

[@sanjogtripathi4192]

Thanks for teaching us sir...I am big fan of yours...please make video on index- match soon.

[@kishanshah128]

Itni aapki video dekhi but ye sabse hatke videos shandar explain ke sath

[@Officialomyadav03]

Thankyou SO much Sir ji 🙏🙏🙏🙏🙏

[@shikshathakur483]

🙏

[@manojjain6610]

मस्त बनाया है एक्सेल को भी फनी कर दिया बेस्ट

[@dineshvitekar]

Start directly 08:01 and save your 8min

[@nareshmishra807]

kzbin.info/www/bejne/jWS9Y4KlnJKCp6c

[@vaibhavpawar3509]

एकदम धायू विडिओ बनाया है.👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@khanrind0074]

Ateeesh sir i like your excel vdos my name is khan rind from pakistan ,balochistan khuzdar from education deppt

[@Thukai-Operater]

Hay Kya Sach me balooch Pakistan se Huda hona chahte hai

[@TejYogLifeStyle]

Sir apki videos bahut achhi hoti hai.jaldi our easily samajh me aata hai sab.thanj you so much

[@Naseerkhankhel]

kzbin.info/www/bejne/lX2cYX6Iid19r8Usi=ZUDqGoabIpWB7TQ0

[@ashwindighe9153]

Hello sir, your lesseons are very informative and very helpful, thank you for all the efforts you are taking. I have one query in your data validation video You gave an example of adhaar card where you have put a restriction on duplicate values, can we have 2 validations for the same field that it data cannot be less than 12 numbers. Kindly guide, the same can apply for Pan number also. Thank you

[@atulcomputerworld2105]

=AND(COUNTIF(D:D,D1)=1,LEN(D1)=12) check this out...you will get your answer

[@elithelabrador]

@@atulcomputerworld2105 wow its amazing i tried this formula good job man

[@pravinnandanwar7692]

I'm big fan of you sir, your way of representation is awesome. Thank you so much sir. It helps me a lot.

[@satyamthepassionate5430]

Sir, how can I get a job in M.N.C? I am looking for a job.

[@C4CCoachingForCareers]

U can watch kzbin.info for advanced excel in hindi...

[@priyankamavchi6573]

Aap plzz asehi video bnavo dekhne me bhi maja aarha he bor nhi hota ase sikhne me🙏🙏 tx bohot achese sumj aata he aapka video

[@mktechnicalhelpguru3568]

Dislike ka to koi matlb hi nai banta kon h jo kr deta h bhai ji....

[@dilsebite2929]

Ek hi chiz baat Baar repeat karo ge toh kya hogaa

[@vaibhavpawar3509]

Meri tarpse es video ko 10 out top 10 reting point🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙆🙆🙆🙆👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏👑👑👑👑☝

[@santosh1985th]

Excellent Sir. Maza aa gaya video dekh ke. Bahut Badhiya. Your teaching skill is very good. I very very very like your teaching style.

[@comparativestudy8607]

Sir best teacher you in the world 🌍

[@kamaltiwari2974]

The video deserves rating 10/10

[@humanlife2484]

You are from the planet🌍 of excellence "excel" Satish Sir Amazing👍🤩 Video Full Concepts Explained

[@pintu4420]

Retting 10+ sir ji bahut achha video aap aise hi videos banate Rahe aur hum sikhate rahe dhanyavad .

[@FunFingersWer]

U r the best computer teacher on this whole ❤️ KZbin....😊

[@shakeelahmad4488]

MANY MANY MANY ,,,,,PRAYERS AND LOVE FROM ( PAKISTAN ) ,,,,,,, THEY WAY YOU ARE TEACHING IS ABSOLUTELY BRILLIANT AND FULL OF NEW INFORMATION AND FULL OF GREAT KNOWLEDGE,,, AND PLEASE KEEP WORKING HARD AND KEEP YOUR SPIRIT HIGH,,,,,

[@riddhisharma5]

Best computer teacher in the world 🎉🎉

[@arulthiyagararjan4506]

fabulous teaching method. pl keep it up. god bless. much benefited - thanks. I am 58, aappka sikaneka tharika muhjey aapka student banadhiya, pranam guruji.

[@naseemahmed6759]

Itni Jabardast Informative Video Ke Liye 1 Like To Banta hai Jabardast ,Shandaar ,Jaandar ,Jindabad, Thank you Very Much Sir Mujhe Ek Stock Management Ka Video Chahiye Sir ..... Godown Stock Maintain In, Out Basis ... Thank you Very Much Sir

[@terriblexd9221]

Hats off to this c... For making this unwanted 30 minutes video on such a simple function 😒

[@rishirohitraj6694]

Thqqqq so much sir ❤❤ Mera data validation ka total option bhut achhe se smjh me aa gya h

[@Pankajsharma-rb3nd]

You derserve 10/10 rating sir cleared lots of doubts

[@dhruvil_techwell9379]

Thanks For Creating This Video, My Rating Is: 10/10.

[@shortfacts3802]

Congrats for 1 million family Love from jharkhand

[@ksrazmi281]

Thanks sir very good

[@gvganeshv001]

Sir, You are great. Your teaching style is unique and more profound and effective.

[@rajeshshah6758]

Your teaching style (Tapori) 10, Aap Aise he padate rahiye, bahut maza aaya

[@vk-kj2mb]

बहुत सुन्दर सर जी 👌 रेटिंग 10

[@lalitkumar-ef7vv]

Satish bhai .....wah! Gajab padhate ho ...l do like your excel videos....apse bahut kuch sikhah h ... Thanks a lot 👍

[@uundlasrehman554]

I am from Pakistanand leave in saudia i like you Good style

[@selfhindi1631]

Sir aapki videose amazing hoti hain , kabhi bore nahi hote 👍👍👍

[@kamleshbhayani9723]

superb the style of your talking dadagiri and datagiri ...... aye hein to chai pike jaye....aapkey tutorials ko dekne me samajne me majaa aata hein aur knowledge bhi milta hein

[@rajanphadke]

bahut khub majak bhi aur sikh bhi- thanks a lot

[@shubhamshukla7940]

*****10*****Rating sirrrr...absolutely Awesome Video on Data Validation.

[@PriyaSharma-ci2kh]

i love your teaching style it's completely different

[@ajit01singh]

Ha sir karte raha karo majak or hamko koi problem nahi hoti or maja ata hai sir 😊😊😊❤❤

[@kamlakar786]

Kya Mast bolte ho muje bahut Acha lagta Hai padai ke Saat enjoy wow loved ur teaching skills sirji

[@purnimayadav00]

Video rating 10of 10 thank you so much sir ❤

[@Noukari456]

I have give your video 10 points out of Ten.

[@technicalnomanwalhari]

Sir ap ka ka teching tarka bohat bohat acha hy aur main ap ko is video ka rating point 10 deta ho

[@sachinsarwade9763]

व्हिडिओमध्ये माहिती फार छान, हसत खेळत माहिती दिली आहे. 👍

[@RahulSingh-zy6mp]

I am really so great full to you sir , By your all videos m getting more confidance at my work place ,Speed knowleadge ,Triks all are awsm , now onwards you are my guru ji.Thank you again sir

[@prabhaschannel4633]

Sir....this word means a lot to a student ....so its fabulous Sir..... Thanks a lot......

[@ZBperoor]

Super sir, i enjoyed ur class so much fun and knowledge.. when ever i want to learn anything in excel i will search for ur videos only in you tube

[@shravansahu8375]

Thank you so so much For making this video

[@meenushukla9250]

Your teaching giri is very joyfull I am also teacher, enjoying teaching.

[@factpointbulaki1098]

really recently i saw your video i think you are great teacher sir pls ese hi mauj masti ke sath padaya kre bahut kre apki lamvi video bhi kb pura dhek lete hai pta nahi chalta

[@HarishKumar-xj5oo]

Amazing video sir jee Enjoy this special video Maza aa gaya Or aapka videos hi dekhta hu mast or ek dum easy trick se batate h aap .

[@ashvinkallee143]

Very unique explanation with humour

[@ANURAGMISHRA-wz7vb]

Rating=10 Thank you so much...

[@Tween_Jodi]

Sir sach me ap bhut acha teach krate h Apki sari video bhut achi h

[@DeepakRajput-hj2us]

वाह सर दिल आ गया तुम्हारी वीडियो पे इतना दिल तो लड़की पे भी नी आता है बहुत धन्यवाद आपका सर 😂😆😆😆😆😂

[@shakeelahmad4488]

Bhout zayda information about data geri Excellent job 10 rating 👌👍

[@neerajsrivastav6488]

Very good sir aap bahut hi ache se samjhate h👌

[@ajsun9787]

Awesome, that was the last piece to complete my puzzle... Many Congrats Sir...Thanks

[@sanjayeducomputer8716]

झकास सर जी 👏👏👏👏👏👏 बोले तो एकदम झकास

[@tanavmittal2775]

you are great sir i learned many things from you

[@dipaksingh4673]

Your teaching Very Nice👌👌

[@n97709]

10 point sir...... thanks for your help full data giri

[@archanasingh2552]

Nice sir Sir aap ki aavaj bahut acha lagta h Sir aap ke padhne ka andaj jhakas h

[@swarnwalia9558]

Really nice and perfect way to teach I learnt many things as a beginner

[@rizwanarif7397]

WELL EXPLAINED WITH FUN

[@RupeshKumar-ug5ib]

Wow mst trick hai my dear sir

[@faizjaved8994]

presentation is nice keep it up.... way of teaching is also excellent...

[@archanakashyap240]

Very very nice methods teaching helpful video

[@diwakarmaurya1754]

You teaching style is fabulous..sir...thank you

[@neerudiwakar3261]

Nice explanation... Whenever I'm free then I'm watching ur videos

[@loveforimrankhan43]

I am your new subscriber ma Pakistan say hio ma ny 6 month ka course keya ha liekn muje us say zaida samaj aa gai sirf ap ke vedio deak kar keeep it up bro ak vedio exel ke settings pr bna do ku k default settings pr Kuch command hidden hoty hs

[@harinath973]

Sir - You way of teaching awesome and it is more productivity for career

[@sumantv9515]

jo log apke chanel mein ayenge wo bina subscribe kiye nehin jayege. yeh mera biswas hain. love u sir ji... but sir I hv a question.....

[@prakashacharya5005]

excellent and easiest coaching

[@abhisheksingh-kc1vq]

U r great, completely understandable , 💯 marks for u

[@santsharansahu59]

बहुत ही शानदार सर जी धन्यवाद 💐

[@shravansahu8375]

100 out of 10 😊

[@manishagnihotri5084]

Learner does not bore of your teaching type

[@gauravkumar-md3nz]

Superb video bahut acha laga

[@Pritambhatt17]

Aapka tutorial interesting hota

[@archanasingh2552]

Maja aata h Sir ja aise padhte h

[@arvindbhatibhati3410]

Very nice video

[@subhasmita7475]

Thank you so much sir class is very intresting ❤❤❤❤❤❤❤

[@pompadutta15]

Excellent way of teaching...funny but interesting...God bless you...🍫🎶⚘⚘

[@nshariprasad1931]

Sir, This video is very good , by copying the file in to another computers, in some cases data validation does not work please give tips.

[@durgeshjagtap5173]

Superb.. this a correct way to learn excel.. where u can easily correlate all commands..