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 YouTube

#ExcelTips
#ExcelTutorial
#Excel

To Watch Power Query and Power Pivot Visit Ajay Sir Channel :

31 Powerful formula of Excel Must Watch :
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
Complete Technology:✅
Learn more shorts:✅
Satish Tech (Marathi):✅
Tally Tutorial:✅
Exce Tutorial:✅
Learn More:✅
Curiosity: ✅
------------------------------------------------------------------------------------------------------------------------------
My YouTube Gears :

Tags - Learn More, Learn More Channel, Technology Tricks, Computer Tricks,

[sripal.jain]

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

[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....👍👍👍👍👌👌👌

[ghurahuprasadyadav]

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

[santoshth]

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

[kamleshnargawe]

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

[utkarshsharma]

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

[mohdtalibkhan]

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

[manojjain]

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

[sanjogZimbar]

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

[kishanshah]

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

[rakeshbond]

Your way of presenting things is very cool and interested

[jyotshnamayeepriyadarshini]

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

[sanjogtripathi]

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

[rhythmoflife]

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

[dineshvitekar]

Start directly 08:01 and save your 8min

[neerudiwakar]

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

[shubhamshukla]

sirrrr...absolutely Awesome Video on Data Validation.

[ashwindighe]

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

[kamleshbhayani]

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

[khanrind]

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