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 KZread
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
#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 KZread 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
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
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
Жыл бұрын
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??
@775shahrukh
6 күн бұрын
8 mint ka intro dedia...kia admi hy ye
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
सतीश सर जी आप जितने महान है। मेरे पास शब्द नहीं है।किस शब्दों में तारीफ करू। आपसे मैने बहुत कुछ सीखा है। सहृदय आभार।
You correctly find the problem of so many people, why they get bored while learning from KZread. 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 👍
Bahut khoob can't explain sir I have no words to explain thanks a lot
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
I'm big fan of you sir, your way of representation is awesome. Thank you so much sir. It helps me a lot.
Your way of presenting things is very cool and interested
@Naseerkhankhel
4 ай бұрын
kzread.info/dash/bejne/kYBtkq2LhNuwqcY.htmlsi=ZUDqGoabIpWB7TQ0
Thanks for teaching us sir...I am big fan of yours...please make video on index- match soon.
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
Sir....this word means a lot to a student ....so its fabulous Sir..... Thanks a lot......
Thankyou SO much Sir ji 🙏🙏🙏🙏🙏
@shikshathakur483
3 жыл бұрын
🙏
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
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,,,,,
मस्त बनाया है एक्सेल को भी फनी कर दिया बेस्ट
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
एकदम धायू विडिओ बनाया है.👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Very Interesting & useful for avoiding silly mistakes.
Start directly 08:01 and save your 8min
@nareshmishra807
3 жыл бұрын
kzread.info/dash/bejne/iWeOlLGol5C1oag.html
Sir, how can I get a job in M.N.C? I am looking for a job.
@C4CCoachingForCareers
4 жыл бұрын
U can watch kzread.info for advanced excel in hindi...
Very very nice methods teaching helpful video
U r great, completely understandable , 💯 marks for u
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
fabulous teaching method. pl keep it up. god bless. much benefited - thanks. I am 58, aappka sikaneka tharika muhjey aapka student banadhiya, pranam guruji.
Explained the things with entertainment.. thanks Sir.
Awesome, that was the last piece to complete my puzzle... Many Congrats Sir...Thanks
Thanks for teaching, KZread helped me a lot
Beautiful presentation dear Thank you so much 🙏💐
You are from the planet🌍 of excellence "excel" Satish Sir Amazing👍🤩 Video Full Concepts Explained
Superb Video sir ji........Poore youtube par aisa koi samjhane wala nahi mila.... Hats off to you. All concepts are clear
Wow, informative along with entertainment... 🙏 👌 👌 👌 👏 👏 👏
You derserve 10/10 rating sir cleared lots of doubts
a very good way of explaining the concepts, with humorous explanation so as to remember them very well. keep it up.
Very nicely explained. Hope to see many interesting excel lessons in future also.
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
i love your teaching style it's completely different
Sir apki videos bahut achhi hoti hai.jaldi our easily samajh me aata hai sab.thanj you so much
@Naseerkhankhel
4 ай бұрын
kzread.info/dash/bejne/kYBtkq2LhNuwqcY.htmlsi=ZUDqGoabIpWB7TQ0
Great I am 61...retired Banker...njoyed this session ..regularly watch Learn more ..🙏
Retting 10+ sir ji bahut achha video aap aise hi videos banate Rahe aur hum sikhate rahe dhanyavad .
I had a good tym learning dis its funnn thank you
Itni aapki video dekhi but ye sabse hatke videos shandar explain ke sath
10 point sir...... thanks for your help full data giri
Your teaching style (Tapori) 10, Aap Aise he padate rahiye, bahut maza aaya
Very good sir aap bahut hi ache se samjhate h👌
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 .
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
Great video on data validation!
झकास सर जी 👏👏👏👏👏👏 बोले तो एकदम झकास
U r amazing sir. dhanyawad for ur affort
इससे अच्छा एक्सप्लेनेशन और नहीं हो सकता। में तो आपका फैन हो गया। बहुत अच्छा।
Sir, You are great. Your teaching style is unique and more profound and effective.
Meri tarpse es video ko 10 out top 10 reting point🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙆🙆🙆🙆👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏👑👑👑👑☝
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
Your presentation is very interesting and so easy to learn. Further, I have a data in vertical form. How to create dropdown list?
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.
Thank you for the video... and spending time to make it funny as well.. Good wishes
Thqqqq so much sir ❤❤ Mera data validation ka total option bhut achhe se smjh me aa gya h
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 kzread.info for advanced excel in hindi...
You are amazing sir.. Keep continue
Sir, aapka presentation bahut achha hai 🎉
Sir super work 💯% rating
Ek dum. Mast laga.. Aise hi bolte raho.. Thank you sir
Excellent, God bless you brother.
बहुत ही शानदार सर जी धन्यवाद 💐
वाह सर दिल आ गया तुम्हारी वीडियो पे इतना दिल तो लड़की पे भी नी आता है बहुत धन्यवाद आपका सर 😂😆😆😆😆😂
Super sirji nice and love it...❤👍
यह video bahut अच्छा लगा l 🌹🔥 राधे राधे🔥ARK🌹🏹
Sir - You way of teaching awesome and it is more productivity for career
Sir ap ka ka teching tarka bohat bohat acha hy aur main ap ko is video ka rating point 10 deta ho
Really nice and perfect way to teach I learnt many things as a beginner
Sir you are awesome 👍 your explanation is superb
You are really so great sir keep it up
Your teaching giri is very joyfull I am also teacher, enjoying teaching.
You teaching style is fabulous..sir...thank you
Hats off to this c... For making this unwanted 30 minutes video on such a simple function 😒
U r the best computer teacher on this whole ❤️ KZread....😊
Sir sach me ap bhut acha teach krate h Apki sari video bhut achi h
Sir best teacher you in the world 🌍
*****10*****Rating sirrrr...absolutely Awesome Video on Data Validation.
You are amazing man!! This is the best ever excel channel on You tube
@C4CCoachingForCareers
4 жыл бұрын
U can watch kzread.info for advanced excel in hindi...
Superb.. this a correct way to learn excel.. where u can easily correlate all commands..
Ur all video are very knowledgeable sir
Greetings of the day Sir, and thanks a ton for this full of knowledgeable video. I would like to know if we can use more than 1 validation in cells.
Way of presenting is super
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
you are great sir i learned many things from you
Awesome sir🙏 you explained each n everything so nicely🙂
Thanks. You helped me to solve my problem.
paji tusi great ho,,,,,
Sir aapki videose amazing hoti hain , kabhi bore nahi hote 👍👍👍
Thank you Sir Very interested viedo
Great good going.. thanks for this man
Excellent Sir. Maza aa gaya video dekh ke. Bahut Badhiya. Your teaching skill is very good. I very very very like your teaching style.
I am delighted on you
Hii sir, The way you teach is very interesting & easy understanding. Ty sir for your support.💥✨🎉
@shujaahmed08
4 жыл бұрын
Please Also subscribe me for more Excel ubdates
You are a great men bro
Bhout zayda information about data geri Excellent job 10 rating 👌👍
your way of fun with learning is good