Complete Data Validation in Excel Every Excel user must know this.
HTML-код
- Опубликовано: 20 ноя 2019
- 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 RUclips
#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 RUclips 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 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/
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...
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
Sir aap 70 saal ki umar ma bhi kaam kar rahe ho issa badi nakamyabi aur kya ho sakti hai
@@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
@@somya102 aap kamyabi ko shayad jaldi men ghalti se nakamyabi likh gae haen.
Main yah sikhne liye institute ko 5000 paid kiya fir v nhi sikh paya,
Lekin aapke video se free me sikh gya.
Thanks sir....👍👍👍👍👌👌👌
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 RUclips. 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
इससे अच्छा एक्सप्लेनेशन और नहीं हो सकता। में तो आपका फैन हो गया। बहुत अच्छा।
एकदम धायू विडिओ बनाया है.👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Your way of presenting things is very cool and interested
ruclips.net/video/_L90KRTxJyc/видео.htmlsi=ZUDqGoabIpWB7TQ0
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
Thanks
Indirect wala formula work nahi kar raha. kya karein??
8 mint ka intro dedia...kia admi hy ye
Sir apki videos bahut achhi hoti hai.jaldi our easily samajh me aata hai sab.thanj you so much
ruclips.net/video/_L90KRTxJyc/видео.htmlsi=ZUDqGoabIpWB7TQ0
Very very nice methods teaching helpful video
Ateeesh sir i like your excel vdos my name is khan rind from pakistan ,balochistan khuzdar from education deppt
Hay Kya Sach me balooch Pakistan se Huda hona chahte hai
Thanks for teaching us sir...I am big fan of yours...please make video on index- match soon.
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
Superb Video sir ji........Poore youtube par aisa koi samjhane wala nahi mila.... Hats off to you. All concepts are clear
Thankyou SO much Sir ji 🙏🙏🙏🙏🙏
🙏
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 .
Excellent Sir. Maza aa gaya video dekh ke. Bahut Badhiya. Your teaching skill is very good. I very very very like your teaching style.
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
=AND(COUNTIF(D:D,D1)=1,LEN(D1)=12) check this out...you will get your answer
@@atulcomputerworld2105 wow its amazing i tried this formula good job man
Start directly 08:01 and save your 8min
ruclips.net/video/W3Z2Oog-OqE/видео.html
Ek dum. Mast laga.. Aise hi bolte raho.. Thank you sir
Sir ap ka ka teching tarka bohat bohat acha hy aur main ap ko is video ka rating point 10 deta ho
Sir, how can I get a job in M.N.C?
I am looking for a job.
U can watch ruclips.net/user/c4ccoachingforcareers for advanced excel in hindi...
Dislike ka to koi matlb hi nai banta kon h jo kr deta h bhai ji....
Ek hi chiz baat Baar repeat karo ge toh kya hogaa
Very good sir aap bahut hi ache se samjhate h👌
वाह सर दिल आ गया तुम्हारी वीडियो पे इतना दिल तो लड़की पे भी नी आता है बहुत धन्यवाद आपका सर 😂😆😆😆😆😂
Itni aapki video dekhi but ye sabse hatke videos shandar explain ke sath
Retting 10+ sir ji bahut achha video aap aise hi videos banate Rahe aur hum sikhate rahe dhanyavad .
Hats off to this c... For making this unwanted 30 minutes video on such a simple function 😒
Nice explanation... Whenever I'm free then I'm watching ur videos
I'm big fan of you sir, your way of representation is awesome. Thank you so much sir. It helps me a lot.
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
Great I am 61...retired Banker...njoyed this session ..regularly watch Learn more ..🙏
Sir sach me ap bhut acha teach krate h
Apki sari video bhut achi h
Wonderful, Your teaching skills is wonderful. Rating for your video 10
You are from the planet🌍 of excellence "excel" Satish Sir
Amazing👍🤩 Video
Full Concepts Explained
Meri tarpse es video ko 10 out top 10 reting point🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙆🙆🙆🙆👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏👑👑👑👑☝
सुंदर शैली आहे शिकवण्याची!
सतत कार्यरत रहा अशीच दीपावली शुभेच्छा!
Thanks Vivek bhau
*****10*****Rating sirrrr...absolutely Awesome Video on Data Validation.
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
बहुत सुन्दर सर जी 👌
रेटिंग 10
बहुत ही शानदार सर जी धन्यवाद 💐
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
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
Thqqqq so much sir ❤❤
Mera data validation ka total option bhut achhe se smjh me aa gya h
Wow mst trick hai my dear sir
Thanks For Creating This Video, My Rating Is: 10/10.
Sir best teacher you in the world 🌍
U r great, completely understandable , 💯 marks for u
Sir, aapka presentation bahut achha hai 🎉
Awesome, that was the last piece to complete my puzzle... Many Congrats Sir...Thanks
Sir....this word means a lot to a student ....so its fabulous Sir..... Thanks a lot......
Wow, informative along with entertainment... 🙏 👌 👌 👌 👏 👏 👏
Bhout zayda information about data geri
Excellent job
10 rating 👌👍
Very Interesting & useful for avoiding silly mistakes.
Thank you so so much
For making this video
10 point sir...... thanks for your help full data giri
U r the best computer teacher on this whole ❤️ RUclips....😊
Kya Mast bolte ho muje bahut Acha lagta Hai padai ke Saat enjoy wow loved ur teaching skills sirji
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,,,,,
You derserve 10/10 rating sir cleared lots of doubts
jhakaas video hai satish sir
Video rating 10of 10 thank you so much sir ❤
Explained the things with entertainment.. thanks Sir.
I have give your video 10 points out of Ten.
Bhut badiya bhai
bahut khub majak bhi aur sikh bhi- thanks a lot
Your teaching style (Tapori) 10, Aap Aise he padate rahiye, bahut maza aaya
यह video bahut अच्छा लगा l
🌹🔥 राधे राधे🔥ARK🌹🏹
fabulous teaching method. pl keep it up. god bless. much benefited - thanks. I am 58, aappka sikaneka tharika muhjey aapka student banadhiya, pranam guruji.
Thanks sir very good
Congrats for 1 million family
Love from jharkhand
Best computer teacher in the world 🎉🎉
Sir super work 💯% rating
Sir aapki videose amazing hoti hain , kabhi bore nahi hote 👍👍👍
Superb video bahut acha laga
Intersting video sir maja aa gaya 🙏
i love your teaching style it's completely different
Great video on data validation!
Sir I am very happy because you very easy this question told me sir pranam
Thanks for teaching, RUclips helped me a lot
Very nicely explained. Hope to see many interesting excel lessons in future also.
Beautiful presentation dear
Thank you so much 🙏💐
Satish bhai .....wah!
Gajab padhate ho ...l do like your excel videos....apse bahut kuch sikhah h ... Thanks a lot 👍
presentation is nice keep it up.... way of teaching is also excellent...
Ha sir karte raha karo majak or hamko koi problem nahi hoti or maja ata hai sir 😊😊😊❤❤
Very nice video
The video deserves rating 10/10
Sir, You are great. Your teaching style is unique and more profound and effective.
you are great sir i learned many things from you
Rating=10
Thank you so much...
Nice learning techniques, Big Thanks
झकास सर जी
👏👏👏👏👏👏
बोले तो एकदम
झकास
Chalti hai bhai masti bindas
Best sir
Very nice video sir bahut aacha laga ye video
I had a good tym learning dis its funnn thank you
Intresting teaching way👌🏻
I am from Pakistanand leave in saudia i like you
Good style