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
You correctly find the problem of so many people, why they get bored while learning from UA-cam. 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 👍
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
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
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
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,,,,,
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.
fabulous teaching method. pl keep it up. god bless. much benefited - thanks. I am 58, aappka sikaneka tharika muhjey aapka student banadhiya, pranam guruji.
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
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
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
Your videos are so good👍 I learned a lot from your videos...your explanation is so good and you make the things more interesting..thank you so much for uploading interesting excel videos😊 And one more thing your face resembles with Abhijeet sawant☺️
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...
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.
You correctly find the problem of so many people, why they get bored while learning from UA-cam. 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 👍
I'm big fan of you sir, your way of representation is awesome. Thank you so much sir. It helps me a lot.
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
Bahut khoob can't explain sir I have no words to explain thanks a lot
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
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
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
Thanks for teaching us sir...I am big fan of yours...please make video on index- match soon.
Superb Video sir ji........Poore youtube par aisa koi samjhane wala nahi mila.... Hats off to you. All concepts are clear
Retting 10+ sir ji bahut achha video aap aise hi videos banate Rahe aur hum sikhate rahe dhanyavad .
Your way of presenting things is very cool and interested
ua-cam.com/video/_L90KRTxJyc/v-deo.htmlsi=ZUDqGoabIpWB7TQ0
Thankyou SO much Sir ji 🙏🙏🙏🙏🙏
🙏
You are from the planet🌍 of excellence "excel" Satish Sir
Amazing👍🤩 Video
Full Concepts Explained
Awesome, that was the last piece to complete my puzzle... Many Congrats Sir...Thanks
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
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
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,,,,,
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 .
Start directly 08:01 and save your 8min
ua-cam.com/video/W3Z2Oog-OqE/v-deo.html
Sir, how can I get a job in M.N.C?
I am looking for a job.
U can watch ua-cam.com/users/c4ccoachingforcareers for advanced excel in hindi...
इससे अच्छा एक्सप्लेनेशन और नहीं हो सकता। में तो आपका फैन हो गया। बहुत अच्छा।
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.
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
Sir....this word means a lot to a student ....so its fabulous Sir..... Thanks a lot......
fabulous teaching method. pl keep it up. god bless. much benefited - thanks. I am 58, aappka sikaneka tharika muhjey aapka student banadhiya, pranam guruji.
सतीश सर जी आप जितने महान है।
मेरे पास शब्द नहीं है।किस शब्दों में तारीफ करू।
आपसे मैने बहुत कुछ सीखा है।
सहृदय आभार।
U r great, completely understandable , 💯 marks for u
Very nicely explained. Hope to see many interesting excel lessons in future also.
Your teaching style (Tapori) 10, Aap Aise he padate rahiye, bahut maza aaya
Bhout zayda information about data geri
Excellent job
10 rating 👌👍
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
Itni aapki video dekhi but ye sabse hatke videos shandar explain ke sath
Ek dum. Mast laga.. Aise hi bolte raho.. Thank you sir
Excellent Sir. Maza aa gaya video dekh ke. Bahut Badhiya. Your teaching skill is very good. I very very very like your teaching style.
Sir, You are great. Your teaching style is unique and more profound and effective.
मस्त बनाया है एक्सेल को भी फनी कर दिया बेस्ट
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
a very good way of explaining the concepts, with humorous explanation so as to remember them very well. keep it up.
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
*****10*****Rating sirrrr...absolutely Awesome Video on Data Validation.
Thqqqq so much sir ❤❤
Mera data validation ka total option bhut achhe se smjh me aa gya h
U r the best computer teacher on this whole ❤️ UA-cam....😊
Superb.. this a correct way to learn excel.. where u can easily correlate all commands..
Sir, aapka presentation bahut achha hai 🎉
You derserve 10/10 rating sir cleared lots of doubts
Satish bhai .....wah!
Gajab padhate ho ...l do like your excel videos....apse bahut kuch sikhah h ... Thanks a lot 👍
Very Interesting & useful for avoiding silly mistakes.
i love your teaching style it's completely different
First of all I would say thanks for making useful video. The way of explanation is also appreciable. Keep it up.
U can watch ua-cam.com/users/c4ccoachingforcareers for advanced excel in hindi...
Wow, informative along with entertainment... 🙏 👌 👌 👌 👏 👏 👏
Wonderful, Your teaching skills is wonderful. Rating for your video 10
Thank you for the video... and spending time to make it funny as well..
Good wishes
Sir aapki videose amazing hoti hain , kabhi bore nahi hote 👍👍👍
You are amazing man!! This is the best ever excel channel on You tube
U can watch ua-cam.com/users/c4ccoachingforcareers for advanced excel in hindi...
Sir apki videos bahut achhi hoti hai.jaldi our easily samajh me aata hai sab.thanj you so much
ua-cam.com/video/_L90KRTxJyc/v-deo.htmlsi=ZUDqGoabIpWB7TQ0
Sir - You way of teaching awesome and it is more productivity for career
Very nice video… learning with fun… Rating 10👍👍👍👍👍
Explained the things with entertainment.. thanks Sir.
Really nice and perfect way to teach
I learnt many things as a beginner
Nice explanation... Whenever I'm free then I'm watching ur videos
Excellent way of teaching...funny but interesting...God bless you...🍫🎶⚘⚘
Beautiful presentation dear
Thank you so much 🙏💐
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
Kya Mast bolte ho muje bahut Acha lagta Hai padai ke Saat enjoy wow loved ur teaching skills sirji
I had a good tym learning dis its funnn thank you
Sir ap ka ka teching tarka bohat bohat acha hy aur main ap ko is video ka rating point 10 deta ho
Thanks for teaching, UA-cam helped me a lot
Great I am 61...retired Banker...njoyed this session ..regularly watch Learn more ..🙏
Very useful. I will rate this video 10 out of 10
झकास सर जी
👏👏👏👏👏👏
बोले तो एकदम
झकास
Wow ...the way you making this video is absolutely awesome... Keep it up...😀
Very good sir aap bahut hi ache se samjhate h👌
Very useful...thnx
My rating wud b 10 out of 10...Stay blessed buddy !
Video rating 10of 10 thank you so much sir ❤
Very Nice Video, I Like it, I Love Excel, Good Work
बहुत ही शानदार सर जी धन्यवाद 💐
Excellent explanation sir. Kindly keep on doing same way.
Your teaching giri is very joyfull I am also teacher, enjoying teaching.
Awesome sir🙏 you explained each n everything so nicely🙂
You teaching style is fabulous..sir...thank you
Sir you are awesome 👍 your explanation is superb
Your videos are so good👍 I learned a lot from your videos...your explanation is so good and you make the things more interesting..thank you so much for uploading interesting excel videos😊
And one more thing your face resembles with Abhijeet sawant☺️
एकदम धायू विडिओ बनाया है.👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Congrats for 1 million family
Love from jharkhand
यह video bahut अच्छा लगा l
🌹🔥 राधे राधे🔥ARK🌹🏹
Sir sach me ap bhut acha teach krate h
Apki sari video bhut achi h
Awesome video. I give 10 on 10 for this wonderful video
You are amazing sir.. Keep continue
You are really so great sir keep it up
10 point sir...... thanks for your help full data giri
Awesome, Satish ji you are great.
Super sirji nice and love it...❤👍
you are great sir i learned many things from you
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.
mujhe bahot hasi aayi ye error msgs padh k. really enjoyed it :-) :-)
Great video on data validation!
Excellent, God bless you brother.
This video is very usefull.
Thanks sir