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

Рет қаралды 538,502

4 жыл бұрын

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 KZfaq
#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.com/open?id=1u6V...
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_course
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/learnmoreindia
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
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 KZfaq 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,

Пікірлер: 1 000

@Learn_More_Pro 2 жыл бұрын

Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Course Website :bit.ly/skill_course 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/

@sripal.jain4 3 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

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.

@user-ot7px1vf1c Жыл бұрын

@kamleshnargawe1 2 жыл бұрын

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 11 ай бұрын

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

@vikashbgs 4 жыл бұрын

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 3 жыл бұрын

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

@mohdtalibkhan3988 4 жыл бұрын

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

@sanjogZimbar 4 жыл бұрын

You correctly find the problem of so many people, why they get bored while learning from KZfaq. 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 👍

@pravinnandanwar7692 3 жыл бұрын

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

@rhythmoflife8272 4 жыл бұрын

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

@rakeshbond009 4 жыл бұрын

Your way of presenting things is very cool and interested

@Naseerkhankhel 3 ай бұрын

kzfaq.info/get/bejne/lbJpY66Dud6uqZc.htmlsi=ZUDqGoabIpWB7TQ0

@sanjogtripathi4192 4 жыл бұрын

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

@ghurahuprasadyadav3798 3 жыл бұрын

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

@zainudheenbadar1094 3 жыл бұрын

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

@Officialgranth 4 жыл бұрын

Thankyou SO much Sir ji 🙏🙏🙏🙏🙏

@shikshathakur483 3 жыл бұрын

🙏

@khanrind0074 4 жыл бұрын

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

@Thukai-Operater 4 жыл бұрын

Hay Kya Sach me balooch Pakistan se Huda hona chahte hai

@utkarshsharma4403 4 жыл бұрын

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

@RahulSingh-zy6mp 4 жыл бұрын

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

@ashwindighe9153 4 жыл бұрын

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 2 жыл бұрын

=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

@dineshvitekar 3 жыл бұрын

Start directly 08:01 and save your 8min

@nareshmishra807 3 жыл бұрын

kzfaq.info/get/bejne/jZmKZbKgzJOzoXk.html

@ajsun9787 2 жыл бұрын

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

@manojjain6610 4 жыл бұрын

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

@satyamthepassionate5430 4 жыл бұрын

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

@C4CCoachingForCareers 4 жыл бұрын

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

@mktechnicalhelpguru3568 4 жыл бұрын

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

@dilsebite2929 4 жыл бұрын

Ek hi chiz baat Baar repeat karo ge toh kya hogaa

@pintu4420 4 жыл бұрын

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

@kishanshah128 3 жыл бұрын

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

@HarishKumar-xj5oo 2 жыл бұрын

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 .

@abhisheksingh-kc1vq 4 жыл бұрын

U r great, completely understandable , 💯 marks for u

@prabhaschannel4633 4 жыл бұрын

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

@jyotshnamayeepriyadarshini603 4 жыл бұрын

Ek dum. Mast laga.. Aise hi bolte raho.. Thank you sir

@Simplysarvani 4 жыл бұрын

Wow, informative along with entertainment... 🙏 👌 👌 👌 👏 👏 👏

@humanlife2484 3 жыл бұрын

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

@arulthiyagararjan4506 4 жыл бұрын

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

@shakeelahmad4488 3 жыл бұрын

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,,,,,

@rajeshshah6758 4 жыл бұрын

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

@shashikantkunjir6733 4 жыл бұрын

Very Interesting & useful for avoiding silly mistakes.

@santsharansahu59 Жыл бұрын

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

@rajeshmishra2882 4 жыл бұрын

Explained the things with entertainment.. thanks Sir.

@bbadri08 3 жыл бұрын

Very nicely explained. Hope to see many interesting excel lessons in future also.

@aryasatvik 3 жыл бұрын

Beautiful presentation dear Thank you so much 🙏💐

@jaysah3885 3 жыл бұрын

Thanks for teaching, KZfaq helped me a lot

@sanjayeducomputer8716 4 жыл бұрын

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

@PriyaSharma-ci2kh 2 жыл бұрын

i love your teaching style it's completely different

@uttamkgulshan 4 жыл бұрын

Great video on data validation!

@shakeelahmad4488 4 жыл бұрын

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

@Pankajsharma-rb3nd Жыл бұрын

You derserve 10/10 rating sir cleared lots of doubts

@gvganeshv001 Жыл бұрын

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

@vinodkamath2057 2 жыл бұрын

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

@LaptopShopee 4 жыл бұрын

Super sirji nice and love it...❤👍

@FunFingersWer Жыл бұрын

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

@selfhindi1631 3 жыл бұрын

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

@prasadnandivadekar9161 4 жыл бұрын

I had a good tym learning dis its funnn thank you

@priyankamavchi6573 3 жыл бұрын

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

@shaileshshukla2324 3 жыл бұрын

10 this is the very use full to me i learned this data validation from your video only so i would like to give you 100 ratting thank you so much and west of luck for your better future us you making our future by making these kind of video.

@naveenkumarsharma9445 4 жыл бұрын

You are amazing sir.. Keep continue

@TejuYogesh2703 6 ай бұрын

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

@Naseerkhankhel 3 ай бұрын

kzfaq.info/get/bejne/lbJpY66Dud6uqZc.htmlsi=ZUDqGoabIpWB7TQ0

@dharmrajisrani 4 жыл бұрын

Thank you for the video... and spending time to make it funny as well.. Good wishes

@kamleshbhayani9723 2 жыл бұрын

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

@letsgooriginal7174 4 жыл бұрын

You are amazing man!! This is the best ever excel channel on You tube

@C4CCoachingForCareers 4 жыл бұрын

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

@neerajsrivastav6488 2 жыл бұрын

Very good sir aap bahut hi ache se samjhate h👌

@rishirohitraj6694 7 ай бұрын

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

@vijayyadav-ur6tv 4 жыл бұрын

Sir super work 💯% rating

@arunkumarsinghark3024 4 жыл бұрын

यह video bahut अच्छा लगा l 🌹🔥 राधे राधे🔥ARK🌹🏹

@durgeshjagtap5173 4 жыл бұрын

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

@gauravkumar-md3nz 4 жыл бұрын

Superb video bahut acha laga

@pompadutta15 2 жыл бұрын

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

@neerudiwakar3261 3 жыл бұрын

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

@rohitrajak5791 4 жыл бұрын

This video is very usefull. Thanks sir

@sharadvishwakarma7273 4 жыл бұрын

You are really so great sir keep it up

@jit8705 2 жыл бұрын

Very helpful video. Thank you Sir.

@varpuikholum1189 4 жыл бұрын

Excellent, God bless you brother.

@govindsfanclub Жыл бұрын

Very nice video… learning with fun… Rating 10👍👍👍👍👍

@diwakarmaurya1754 2 жыл бұрын

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

@AKonly-pb1uu 2 жыл бұрын

Intersting video sir maja aa gaya 🙏

@qadeemmohabbat9906 4 жыл бұрын

U r amazing sir. dhanyawad for ur affort

@SinghDavinder007 4 жыл бұрын

Awesome Sir...Fabulous

@n97709 4 жыл бұрын

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

@vatanmehrotra8222 4 жыл бұрын

Great good going.. thanks for this man

@shubhamshukla7940 2 жыл бұрын

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

@futureonlineguru2879 4 жыл бұрын

Very nice video sir bahut aacha laga ye video

@punitnimesh5750 4 жыл бұрын

You are a great men bro

@santosh1985th 3 жыл бұрын

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

@sharadvishwakarma7273 4 жыл бұрын

I am delighted on you

@sameerjadhav4571 3 жыл бұрын

Very useful. I will rate this video 10 out of 10

@preetiprajapati4631 2 жыл бұрын

Awesome sir🙏 you explained each n everything so nicely🙂

@jitendrabomble2218 2 жыл бұрын

Thanks sir. Very very useful information.

@harinath973 3 жыл бұрын

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

@hightechcomputereducation4735 3 жыл бұрын

Awesome, Satish ji you are great.

@vk-kj2mb 3 жыл бұрын

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

@architpatel8856 4 жыл бұрын

Very Nice Video, I Like it, I Love Excel, Good Work

@girisharya4911 3 жыл бұрын

Thanks. You helped me to solve my problem.

@rameshchalla938 4 жыл бұрын

a very good way of explaining the concepts, with humorous explanation so as to remember them very well. keep it up.

@terriblexd9221 Жыл бұрын

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

@manoharkumarray822 4 жыл бұрын

Thank you Sir Very interested viedo

@junaid2882 4 жыл бұрын

Sir you are awesome 👍 your explanation is superb

@pradeepchaudhary7157 4 жыл бұрын

First of all I would say thanks for making useful video. The way of explanation is also appreciable. Keep it up.

@C4CCoachingForCareers 4 жыл бұрын

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

@prakashbaviskar6032 2 жыл бұрын

Nice learning techniques, Big Thanks

@mukeshmahato4475 4 жыл бұрын

super sir ji tusi great ho.........

@vaibhavpawar3509 4 жыл бұрын

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

@tanavmittal2775 3 жыл бұрын

you are great sir i learned many things from you

@swarnwalia9558 Жыл бұрын

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

@factpointbulaki1098 4 жыл бұрын

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