MS Excel - Data Validation

Поделиться
HTML-код
  • Опубликовано: 2 авг 2024
  • MS Excel - Data Validation
    Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
    Check out the latest MS Excel Online Training courses on bit.ly/38Jyu3p
    Use coupon "RUclips" to get FLAT 10% OFF at Checkout.
    Check out latest Video Courses and eBooks : www.tutorialspoint.com/market...
    In this video check How to use Data Validation in Excel - Data Validation in Excel Tips and Tricks?
    For more updates on courses and tips follow us on:
    Facebook: / tutorialspointindia
    Twitter: / tutorialspoint
    LinkedIn: / tutorialspoint

Комментарии • 610

  • @TutorialsPoint_
    @TutorialsPoint_  Год назад +5

    To Get Certification, Click Here: bit.ly/38Jyu3p
    Use coupon "RUclips12" 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 2 года назад +326

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

    • @helloworld2041
      @helloworld2041 Год назад +1

      And i saw 4 5 ad in just 11 min

    • @rohanmoharkar
      @rohanmoharkar 9 месяцев назад +1

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

    • @munzhedzimashige5932
      @munzhedzimashige5932 5 месяцев назад +1

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

    • @lakhi_kant
      @lakhi_kant 4 месяца назад

      ​@@helloworld2041do you work for free?

  • @kapilmalu1475
    @kapilmalu1475 3 года назад +15

    EXCEL : Best Tool
    RUclips : Great Plaform
    Tutorials Point : Excellent Videos

  • @dp6736
    @dp6736 4 года назад +43

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

    • @Aru19997
      @Aru19997 2 года назад +2

      Yes you are right, not everyone has it

  • @johnpaulosalto5685
    @johnpaulosalto5685 4 года назад +24

    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 3 года назад

      He is Indian

    • @johnpaulosalto5685
      @johnpaulosalto5685 3 года назад

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

  • @vijaydoshi1
    @vijaydoshi1 2 года назад +3

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

  • @marcuspow
    @marcuspow 5 лет назад +3

    Among the RUclips you are best excel teacher. Loud and clear better than class room.

  • @Pafavor20262
    @Pafavor20262 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

  • @mdabdullah4379
    @mdabdullah4379 4 года назад +2

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

  • @johnq3543
    @johnq3543 2 года назад +8

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

  • @simm1872
    @simm1872 3 года назад +3

    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 !

  • @bestviews2751
    @bestviews2751 9 месяцев назад +1

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

  • @santoshkumarvavilala3179
    @santoshkumarvavilala3179 5 лет назад +2

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

  • @santhidhanuskodi8668
    @santhidhanuskodi8668 3 года назад +1

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

  • @rangiroa100
    @rangiroa100 Год назад +1

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

  • @jameszanu3378
    @jameszanu3378 5 лет назад +33

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

  • @KrishnamurthyKashyap
    @KrishnamurthyKashyap 4 года назад +9

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

  • @hamaduddin1248
    @hamaduddin1248 9 месяцев назад

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

  • @nasrullah3822
    @nasrullah3822 4 года назад +1

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

  • @nagabrahmammaredipudi5222
    @nagabrahmammaredipudi5222 4 года назад +2

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

  • @onyiekeh5367
    @onyiekeh5367 5 месяцев назад

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

  • @subhambaluni1060
    @subhambaluni1060 Год назад +1

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

  • @PD_incredible
    @PD_incredible 2 года назад

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

  • @RahulThakur-lh8jo
    @RahulThakur-lh8jo 2 года назад

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

  • @SiddhaandAyurveda
    @SiddhaandAyurveda 5 лет назад +1

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

  • @yr5096
    @yr5096 5 лет назад +1

    The list is what I was looking for. Thank you

  • @ivanhernandez6288
    @ivanhernandez6288 2 года назад

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

  • @kajalchauhan4397
    @kajalchauhan4397 3 года назад +2

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

  • @tamilstoriesinmyvoice3430
    @tamilstoriesinmyvoice3430 3 года назад

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

  • @mohitjain9030
    @mohitjain9030 5 лет назад +1

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

  • @saumyaranjan1435
    @saumyaranjan1435 2 года назад

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

  • @pallavisingh9570
    @pallavisingh9570 6 лет назад +4

    Very useful & well explained

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

  • @aartifaujdar1803
    @aartifaujdar1803 2 года назад

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

  • @deepakkumarcreations7742
    @deepakkumarcreations7742 4 года назад

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

  • @mustafaanwar8778
    @mustafaanwar8778 4 года назад +1

    Very helpful and easy explanation, Appreciate a lot!

  • @sameerlalseragu6705
    @sameerlalseragu6705 Год назад

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

  • @Lopa-Kitchen
    @Lopa-Kitchen 2 года назад +2

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

  • @anandpatilbusinessandmanag8660
    @anandpatilbusinessandmanag8660 4 года назад +1

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

  • @ammusweety7743
    @ammusweety7743 3 года назад +1

    Its informative, well explained by the Tutor. Excellent.

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

  • @somashekharbhumannavar982
    @somashekharbhumannavar982 5 лет назад

    Absolutely rocking Bro... clean and clear information.. Thanks

  • @sibikabhardwaz6511
    @sibikabhardwaz6511 5 лет назад +8

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

  • @moeez-ul-haq8159
    @moeez-ul-haq8159 10 месяцев назад

    Best every video I found on RUclips regarding data validation thank you brother

  • @aishwaryabhowar
    @aishwaryabhowar 3 года назад +3

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

  • @vishnusharma7285
    @vishnusharma7285 5 лет назад

    Sir u r great. I salute u r way of teaching. Great great

  • @mahalakshmi6271
    @mahalakshmi6271 5 лет назад

    You will get thousands of WOWs for all your presentations

  • @surajkukreti3392
    @surajkukreti3392 4 года назад

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

  • @shaiknazeerahamed6126
    @shaiknazeerahamed6126 5 лет назад

    Thank you sir
    Your videos are very useful and in Understanding way

  • @mdazizulislam2498
    @mdazizulislam2498 3 года назад +1

    Excellent teacher, I've never seen

  • @susanmartinlara2705
    @susanmartinlara2705 4 года назад

    Great Video! Thank you so much for providing this.

  • @padmashreeramamurthy
    @padmashreeramamurthy Год назад

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

  • @sandeep120100
    @sandeep120100 4 месяца назад +1

    Gajab, best explanation

  • @rohitkatarey9878
    @rohitkatarey9878 6 лет назад +11

    I liked your videos, as it helped me a lot for my work.
    I have a query, can I change the worksheet name in a particular formula/function automatically.

  • @akankshapandey6132
    @akankshapandey6132 4 года назад +1

    Best way of explanation.... U r genius

  • @govindlal2253
    @govindlal2253 2 года назад

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

  • @b.k.choudhary1057
    @b.k.choudhary1057 3 года назад

    Very nice explanations with in easy english word. Thank a lot for your super educational video. 👌🙏

  • @samratdutta6213
    @samratdutta6213 Год назад

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

  • @karankapadia4055
    @karankapadia4055 8 месяцев назад

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

  • @umerkayani79
    @umerkayani79 4 года назад

    Thanks Sir
    Your videos are very informative for us. May Allah bless you n your families n friends..Ameen

  • @praneetmane9639
    @praneetmane9639 Год назад

    Nice content. Tutorials are much understandable without much time wasting

  • @meditation125
    @meditation125 6 лет назад

    your explanation is very simple and sweet brother. keep it up

  • @bennysebastian5316
    @bennysebastian5316 5 лет назад

    So..... nice Explanation...... THAAAANKSSSSS...........

  • @ChuyenNenLam
    @ChuyenNenLam 2 года назад

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

  • @TEEVLOGS978
    @TEEVLOGS978 Год назад

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

  • @aritragoswami4838
    @aritragoswami4838 2 года назад

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

  • @cheenu5498
    @cheenu5498 4 года назад

    Excellent presentation and very useful tips. Thank you very much

  • @user-uf8fc4zf6s
    @user-uf8fc4zf6s 4 месяца назад

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

  • @PV-free123world
    @PV-free123world 3 года назад +5

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

  • @kadwanie
    @kadwanie 5 лет назад +4

    Very well elaborated & perfect delivery! Thumbs up Sir.

  • @lakshminarayana5998
    @lakshminarayana5998 3 года назад

    Thank you so much..you are my life saver..keep up the good work👍

  • @paulkirongosi939
    @paulkirongosi939 Год назад

    Excellent tutorial , learning from KENYA Africa

  • @viddongmalualruot7909
    @viddongmalualruot7909 4 года назад +1

    Today i learned an interesting lesions on excel

  • @additionalsp2104
    @additionalsp2104 Год назад

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

  • @mahbubmamun9338
    @mahbubmamun9338 4 года назад

    VERY GOOD AND USEFUL TUTORIAL. THANKS A LOT.

  • @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).

  • @srinivaspatnaik5329
    @srinivaspatnaik5329 Год назад

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

  • @imranomar207
    @imranomar207 4 года назад

    I am very thankful to you give a great knowledge about excel thanks

  • @traveltripper49
    @traveltripper49 4 года назад +5

    Wow, today I learnt some interesting things in excel....Thanks Sir

  • @ramakantpatil2011
    @ramakantpatil2011 3 года назад

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

  • @nnirmalkumar3719
    @nnirmalkumar3719 3 года назад +1

    Well explained, Pavan!

  • @deepakmudhiraj6552
    @deepakmudhiraj6552 Год назад

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

  • @sabalemi480
    @sabalemi480 2 года назад

    Thank you for this best tutorial .God bless

  • @muhammadhamza9166
    @muhammadhamza9166 2 года назад

    Great Sir!
    Very effective way of Teaching 😍
    Respect from Pakistan

  • @ansaritausif4754
    @ansaritausif4754 4 месяца назад

    Each and everything I understand easily, Thnks sir

  • @kamranelahi1107
    @kamranelahi1107 5 лет назад

    Your teaching way is impeccable sir

  • @ikkutech1
    @ikkutech1 2 года назад

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

  • @tlce2023
    @tlce2023 Год назад

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

  • @regankyeyune1402
    @regankyeyune1402 2 года назад

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

  • @arpitadey9245
    @arpitadey9245 4 года назад

    The way you explain is so easy to understand

  • @jyotiprakashpanda7938
    @jyotiprakashpanda7938 5 лет назад

    the way you teaching ...beautiful......

  • @abdulmalekat.9517
    @abdulmalekat.9517 5 лет назад +1

    man you are great . thank you sooo much

  • @smaartwork8798
    @smaartwork8798 5 лет назад

    Your videos are really useful. Thank you

  • @dineshkumarsharmadps589
    @dineshkumarsharmadps589 6 лет назад

    Everything video Outstanding 👌👌

  • @barkath005
    @barkath005 5 лет назад

    Perfect and crystal clear

  • @lerouxjulien6209
    @lerouxjulien6209 5 лет назад

    superb excellent very usefull, i want learn to excel expert

  • @dihilodukha4442
    @dihilodukha4442 2 года назад

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

  • @binduahuja1104
    @binduahuja1104 4 года назад

    Your way of teach ing is excellent sir.

  • @nimeshengg
    @nimeshengg 2 года назад

    crisp and to the point info,,,,great video

  • @srinivasaraom393
    @srinivasaraom393 3 года назад +1

    Thanks for the informative and useful video