MS Excel - Data Validation

Поділитися
Вставка
  • Опубліковано 7 січ 2025

КОМЕНТАРІ • 616

  • @TutorialsPoint_
    @TutorialsPoint_  Рік тому +13

    To Get Certification, Click Here: bit.ly/38Jyu3p
    Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.

    • @user-ho7tg7kb9v
      @user-ho7tg7kb9v Рік тому

      Sir, When I put source data in other sheet for data validation list; any change to it don't appear in the table list. How to solve it?

  • @sheetaluniyal8605
    @sheetaluniyal8605 3 роки тому +358

    No introduction, no promotion, no waste of time just point to point amazing explanation in short time incredible sir !

    • @helloworld2041
      @helloworld2041 2 роки тому +2

      And i saw 4 5 ad in just 11 min

    • @rohanmoharkar
      @rohanmoharkar Рік тому +1

      @@helloworld2041 bhai tum job without salary karte ho kya?

    • @munzhedzimashige5932
      @munzhedzimashige5932 10 місяців тому +1

      Right? Straight to the point. I am a fan of this guy.

    • @lakhi_kant
      @lakhi_kant 9 місяців тому

      ​@@helloworld2041do you work for free?

  • @kapilmalu1475
    @kapilmalu1475 3 роки тому +27

    EXCEL : Best Tool
    UA-cam : Great Plaform
    Tutorials Point : Excellent Videos

  • @johnpaulosalto5685
    @johnpaulosalto5685 4 роки тому +27

    this guy is very much impressive than other tutorial even though he have a different accent, he keep it plain and simple. this channel is the best excel tutorial so far and im starting to have a interest in excel application because of this good guy right here.

    • @Wolf-hd1hr
      @Wolf-hd1hr 4 роки тому

      He is Indian

    • @johnpaulosalto5685
      @johnpaulosalto5685 4 роки тому

      @@Wolf-hd1hr yeah obviously

    • @shivkumarravi6149
      @shivkumarravi6149 Рік тому

      is this tutorial enough to understand the basics of excel considering that i am a beginner

    • @kirant96
      @kirant96 Рік тому

      @@shivkumarravi6149 YES... Just go through his playlist... Dont watch videos randomly

  • @dp6736
    @dp6736 4 роки тому +44

    You have a very natural and effective coaching style. One of the best! Thank you for all of your amazing tutorials.

    • @Aru19997
      @Aru19997 3 роки тому +2

      Yes you are right, not everyone has it

  • @TutorialsPoint_
    @TutorialsPoint_  4 роки тому +30

    Check out latest MS Excel Online Training
    courses on : bit.ly/38Jyu3p
    Use coupon "UA-cam" to get FLAT 10% OFF

    • @MumtazAli-pr9qq
      @MumtazAli-pr9qq 3 роки тому

      Can someone please tell me the name of this teacher or his channel

    • @vaishnavinegi4461
      @vaishnavinegi4461 5 місяців тому

      @@MumtazAli-pr9qq pawan lalwani

  • @johnq3543
    @johnq3543 2 роки тому +9

    Even when I have previously studied a given subject, I still learn something new from your tutorials. Thank you, sir.

  • @bestviews2751
    @bestviews2751 Рік тому +1

    Without any introduction , natural and effective coaching style, no logterm speech, nice explanation in short time Super your the best i sir !

  • @marcuspow
    @marcuspow 5 років тому +3

    Among the UA-cam you are best excel teacher. Loud and clear better than class room.

  • @Lopa-Kitchen
    @Lopa-Kitchen 3 роки тому +3

    Teaching style and voice command perfect. One can easily understand each n every thing. You also look like Sonu Nigam.

  • @vijaydoshi1
    @vijaydoshi1 2 роки тому +4

    You are a natural teacher. Crisp, clear, effective. Keep it up. Love your tutorials.

  • @santhidhanuskodi8668
    @santhidhanuskodi8668 3 роки тому +1

    the best channel for learning. simple, short videos, not too much of talking ...good job

  • @jameszanu3378
    @jameszanu3378 5 років тому +33

    great educator well explained for anyone's understanding. THANK YOU

  • @hamaduddin1248
    @hamaduddin1248 Рік тому

    Thank you sir .I m in Saudi Arabia , tommorrow is my final interview for document controller i learned each and every formula which youhave explained i think this will helpfull to me
    Hats off to you , the way you are explaining is just extra ordinary no one can explain better than you and your accent is also so polite and understandable 👌👌👌👌

  • @sheim-h6l
    @sheim-h6l 2 роки тому +4

    This man is really amazing 🤩, i took up excel course but every time the course i took, this better gave me very clear understanding 🙏hope every excel course learner take his course all time

  • @ivanhernandez6288
    @ivanhernandez6288 3 роки тому

    Just got a just as a data entry clerk and i am asked to do some data validation, so this definitely helped. THANK YOU

  • @RahulThakur-lh8jo
    @RahulThakur-lh8jo 3 роки тому

    I automate many of excel projects through vba. Credit goes to this guy. Thank u sir

  • @sumodmohan9520
    @sumodmohan9520 4 роки тому +11

    Your way of teaching is very interesting & attractive...Never feel to skip the video.Thank you...

  • @rangiroa100
    @rangiroa100 Рік тому +1

    Excellent presentation. Concise and to the point and no unnecessary music or background noise.

  • @mdabdullah4379
    @mdabdullah4379 4 роки тому +2

    That's one hell of a video explanation. One of the best excel tutorials on UA-cam.

  • @santoshkumarvavilala3179
    @santoshkumarvavilala3179 5 років тому +2

    Extraordinary explanation... It makes a sense me that I need not practice at all on my excel sheets. Superb...

  • @onyiekeh5367
    @onyiekeh5367 11 місяців тому

    You are the best , straight to the point and not long boring videos.

  • @renusriram4701
    @renusriram4701 4 роки тому +1

    I never commented on UA-cam..sir hats of to you for your teaching skills..very well explained..

  • @deepakmudhiraj6552
    @deepakmudhiraj6552 Рік тому

    This sir is best than many other sir's to whom we pay for getting certificate online

  • @simm1872
    @simm1872 3 роки тому +2

    Excellent and lovely illustration with clear professional voice, dear Pawan, Tutorials Point
    ( India) Ltd.
    Very clear and useful IT usage especially in the world famous Excel Worksheets.
    Thank you for your great services for the human development in IT, the present and future !

  • @shivanijain6327
    @shivanijain6327 2 роки тому

    ALL THE VIDEOS ARE WONDERFUL........................NO NEED TO STUDY FROM SOMEWHERE ELSE IF WE ARE STUDYING FROM THESE VIDEOS.

  • @aishwaryabhowar
    @aishwaryabhowar 4 роки тому +3

    All your Vlookup , hlookup & now this data valadation video's have helped me alot in my work, Thankyou you explain really well.

  • @moeez-ul-haq8159
    @moeez-ul-haq8159 Рік тому

    Best every video I found on UA-cam regarding data validation thank you brother

  • @shwetamishra5813
    @shwetamishra5813 9 місяців тому +1

    Appreciating you enough sir🙏🏻

  • @govindlal2253
    @govindlal2253 2 роки тому

    No bakwas..sirf kaam ki baat..excellent bhai.👍

  • @regankyeyune1402
    @regankyeyune1402 2 роки тому

    Best excel tutor i have met my whole life… where have u been hiding

  • @akankshapandey6132
    @akankshapandey6132 4 роки тому +1

    Best way of explanation.... U r genius

  • @sameerlalseragu6705
    @sameerlalseragu6705 2 роки тому

    No waste of time just point to point amazing explanation in short time incredible sir and thank you so much sir

  • @padmashreeramamurthy
    @padmashreeramamurthy 2 роки тому

    In 10 mins i understood better than going to class. very useful videos !

  • @kajalchauhan4397
    @kajalchauhan4397 4 роки тому +2

    YOU ARE TOO GOOD SIR .. YOUR TEACHING TACTICS ARE SO AMAMZING HITS THE BRAIN

  • @ramakantpatil2011
    @ramakantpatil2011 3 роки тому

    Very professionally..And very Easy explain ....Great work PAWAN JIII

  • @KrishnamurthyKashyap
    @KrishnamurthyKashyap 5 років тому +9

    Hi Pavan sir, I like your teaching method that too with examples, thanks a lot, please keep updates... I'm following...
    regards

  • @subashazad7995
    @subashazad7995 4 роки тому +1

    Teaching style is very good

  • @aartifaujdar1803
    @aartifaujdar1803 3 роки тому

    1st time i watch this video 🙌
    SO the way of teaching is too good and the digital board make also clear everything

  • @subhambaluni1060
    @subhambaluni1060 2 роки тому +1

    I love your videos, Direct to the topic, no useless ads. thank you 😇

  • @sandeep120100
    @sandeep120100 9 місяців тому +1

    Gajab, best explanation

  • @tlce2023
    @tlce2023 Рік тому

    Good Teaching Method Sir. Very Simple Way Of Teaching. No need to watch again.
    Thank You Very Much sir

  • @aritragoswami4838
    @aritragoswami4838 3 роки тому

    Beautiful expression...very easy to understand which is very helpful... awesome tutor...

  • @Naturalworld5493
    @Naturalworld5493 5 років тому +5

    I love your all videos. Your way of teaching is perfect. we have easily understand your word..we expect more video from you..love it and thanks to spend with us your valuable time.

  • @ordinary_guy_9090
    @ordinary_guy_9090 2 роки тому

    seedi baat no bakwas... short and simple to understand

  • @nehasaxena44
    @nehasaxena44 4 роки тому +1

    Like your videos helps me lot at work 😄😄😄😄😄😄😄😄😄😄😄😄😄😁😁😁

  • @sibikabhardwaz6511
    @sibikabhardwaz6511 6 років тому +8

    I love your tutorial....amazing. you have explained so nicely.

  • @sujatachauhan7998
    @sujatachauhan7998 4 роки тому +1

    Very good teaching method.... thanks alot

  • @gagandreams80
    @gagandreams80 3 роки тому

    Thank you so much sir tomorrow I have practcal exams it helped so much

  • @lordthomasnxumalo4534
    @lordthomasnxumalo4534 2 роки тому

    Thanks you very much lecture Pavan for your good teaching, appreciate a lot it has help me a lot sir keep up the good work may the Lord allmighty bless you and your family. ( from NAMIBIA SWAKOPMUND).

  • @aribamongzar4867
    @aribamongzar4867 3 роки тому

    I should named him Mr. Excel or father of excel.. Just hats off 👍👍

  • @darshan7893
    @darshan7893 5 років тому +8

    Hello Sir
    I am a big fan of you,
    Your videos make me so,
    I want to know what kind of screen you use.

  • @nodiraryanhan9420
    @nodiraryanhan9420 3 роки тому +1

    Salam India ♥️ from Uzbekistan 🇺🇿♥️🇮🇳

  • @paulkirongosi939
    @paulkirongosi939 2 роки тому

    Excellent tutorial , learning from KENYA Africa

  • @samratdutta6213
    @samratdutta6213 Рік тому

    Very nice video. Very informative. No time waste. Thank u.

  • @Mukul_Adhikary
    @Mukul_Adhikary 3 роки тому

    Apni khub sundor kore bojhan...🥰🥰🥰

  • @nasrullah3822
    @nasrullah3822 4 роки тому +1

    Your style of teaching is very impressive. Keep it up. God bless you. Thank you.

  • @deepakkumarcreations7742
    @deepakkumarcreations7742 5 років тому

    Sir you are very professional ...your way of teaching is awesome and unique...thank you sir ..

  • @SaikrishnanMakesh
    @SaikrishnanMakesh 4 місяці тому

    Sir loved the way you thought us. Clear as a crystal!!!!

  • @praneetmane9639
    @praneetmane9639 Рік тому

    Nice content. Tutorials are much understandable without much time wasting

  • @mohammadeifairshad
    @mohammadeifairshad Рік тому +4

    Watching it at 1 Am, Pratical Exam is starts from 9 Am 😢

  • @surajkukreti3392
    @surajkukreti3392 4 роки тому

    Your teaching method is fabulous ..Sir ..Thanks for teaching me this smart trick...... Thank you

  • @ne.divyanshlive8187
    @ne.divyanshlive8187 4 роки тому

    thank you sir i study in 7th grade and tomorrow is my class test and this video will help me surely again thank you

  • @anandpatilbusinessandmanag8660
    @anandpatilbusinessandmanag8660 4 роки тому +1

    Excellent Sir, Very nice of you never seen such a wonderful and simple explination

  • @PV-free123world
    @PV-free123world 3 роки тому +5

    This is excellent! I can even understand the accent :DD

  • @PD_incredible
    @PD_incredible 2 роки тому

    Brilliantly explained - simple example, very simple and clear instructions. Well done.

  • @aushikumari1276
    @aushikumari1276 3 роки тому +1

    Thank you so much sir
    It has helped me a lot for my practical exams .

  • @srinivaspatnaik5329
    @srinivaspatnaik5329 Рік тому

    Really appreciated, very very detailed explanation...Thank you dear.

  • @tamilstoriesinmyvoice3430
    @tamilstoriesinmyvoice3430 4 роки тому

    U r awesome. I started learning advanced excel. I found urs are very helpful n easily understandable. Ur style of teaching is very impressive.. keep up the good work..

  • @t.unnikrishnannair9882
    @t.unnikrishnannair9882 4 роки тому

    Gentle man you are doing well, other than other youtubers because u are using projector and smart board, any body can see clearly the computer screen. others only showing their laptop/desktop screen very long distance, the viewers could not under stand.
    do u you have any vdo on graphic design, I want learn how to prepare gigs creation, logo creation, brucher creation and so on pls commnet .

  • @nagabrahmammaredipudi5222
    @nagabrahmammaredipudi5222 4 роки тому +2

    Really awesome teaching, very simple and easy to understand.
    thank you so much for providing video

  • @kudaravallister
    @kudaravallister 3 роки тому +2

    The list is what I was looking for. Thank you

  • @AmandaM-t9e
    @AmandaM-t9e 2 роки тому

    Thankmyou so much for solving my problem without wasting my time.

  • @krishanbn
    @krishanbn 5 років тому +1

    I am big fan of your videos

  • @amareswarareddy2662
    @amareswarareddy2662 4 роки тому

    Really Superbb. Your way of explaining is soo clear

  • @ikkutech1
    @ikkutech1 3 роки тому

    SIR YOUR VEDIO IS VERRY USEFULL AND ALSO EVERY ONE CAN UNDERSTAND THANKX FOR YOUR INFORMATION

  • @SiddhaandAyurveda
    @SiddhaandAyurveda 5 років тому +1

    I fall short of words to appreciate your explanation.keet it up.

  • @FarhanAslam-b1p
    @FarhanAslam-b1p 10 місяців тому

    Thank you very much for detailed and easy demonstration of Validation.

  • @additionalsp2104
    @additionalsp2104 Рік тому

    I like your way of teaching. You explain the topic very easily...👍👍👏

  • @mohitjain9030
    @mohitjain9030 5 років тому +1

    Your english is so perfect.I liked it very much.

  • @mdazizulislam2498
    @mdazizulislam2498 3 роки тому +1

    Excellent teacher, I've never seen

  • @PAWANKUMAR-gl1by
    @PAWANKUMAR-gl1by 3 роки тому

    Very usefully in this video One of the best couching sir

  • @dihilodukha4442
    @dihilodukha4442 2 роки тому

    Thank you sir.your channel is so informative and helpful for learners like me

  • @srinivasaraom393
    @srinivasaraom393 4 роки тому +1

    Thanks for the informative and useful video

  • @kamranelahi1107
    @kamranelahi1107 6 років тому

    Your teaching way is impeccable sir

  • @shubhamraj-fu7zj
    @shubhamraj-fu7zj 4 роки тому

    Sir this is the best and easy video ever thank you very much sir🤗🤗🥰🥰my all dobout are clear

  • @karankapadia4055
    @karankapadia4055 Рік тому

    Thank you for your information. You have deep knowledge in excel.i see your video & clear my doubt

  • @ansaritausif4754
    @ansaritausif4754 10 місяців тому

    Each and everything I understand easily, Thnks sir

  • @tradesfortrader
    @tradesfortrader 2 місяці тому

    Its a really really amazing way, to learn something ❤❤😊😊

  • @mahalakshmi6271
    @mahalakshmi6271 5 років тому

    You will get thousands of WOWs for all your presentations

  • @ajayjoshi9646
    @ajayjoshi9646 4 роки тому +1

    Learnt a lot..thanks

  • @nnirmalkumar3719
    @nnirmalkumar3719 4 роки тому +1

    Well explained, Pavan!

  • @ChuyenNenLam
    @ChuyenNenLam 2 роки тому

    I Learn something new today. Thank you for your tutoring this lesson.

  • @saumyaranjan1435
    @saumyaranjan1435 2 роки тому

    Your teaching style is very special and it makes the concept so easy and clear. Thank you sir 🙏🙏🙏🙏🙏

  • @Tony_Montana659
    @Tony_Montana659 4 роки тому +1

    Great & easy to understand explaining in a simple way.Thank you.

  • @TEEVLOGS978
    @TEEVLOGS978 Рік тому

    Very well explained!!no waste of time with intro & outro 👍

  • @mprmusicworld7228
    @mprmusicworld7228 2 роки тому

    It's very easy to understand
    Thank you sir.....

  • @mahmoodmunawar1132
    @mahmoodmunawar1132 5 років тому +1

    Hi I m a follower of your xl videos and I really appreciate your efforts to spread knowledge. I need you tutorial on dates range between start & finish given dates like as we work in schedule at last minimum value as start date with actual dates as 1-Feb-19 A and maximum value as finish date 25-Feb-19 A. if u can help me with advance formula to fix dates range between start and finish date it will help me a lot. Thanks in advance Munawar

  • @ammusweety7743
    @ammusweety7743 4 роки тому +1

    Its informative, well explained by the Tutor. Excellent.

  • @shaikmohammadyakhub8657
    @shaikmohammadyakhub8657 4 роки тому

    Like your way of teaching