MS Excel - Data Validation

Поділитися
Вставка
  • Опубліковано 3 сер 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 "UA-cam" 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 "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 2 роки тому +327

    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
    UA-cam : 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

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

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

  • @TutorialsPoint_
    @TutorialsPoint_  3 роки тому +31

    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 2 роки тому

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

    • @vaishnavinegi4461
      @vaishnavinegi4461 10 днів тому

      @@MumtazAli-pr9qq pawan lalwani

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    The list is what I was looking for. Thank you

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Very helpful and easy explanation, Appreciate a lot!

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

    Its informative, well explained by the Tutor. Excellent.

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

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

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

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

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

    Great Video! Thank you so much for providing this.

  • @moeez-ul-haq8159
    @moeez-ul-haq8159 10 місяців тому

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

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

    You will get thousands of WOWs for all your presentations

  • @pallavisingh9570
    @pallavisingh9570 6 років тому +4

    Very useful & well explained

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

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

    Dear tutor ji i really respect and thank you for your depth of knowldge and the subject command and the way you teach and communicate.SIMPLY EXTRAORINARY.....Loads of respect to you

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

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

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

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

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

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

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

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

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

    Thanks for the informative and useful video

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

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

  • @user-uf8fc4zf6s
    @user-uf8fc4zf6s 4 місяці тому

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

  • @b.k.choudhary1057
    @b.k.choudhary1057 3 роки тому

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

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

  • @traveltripper49
    @traveltripper49 4 роки тому +5

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

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

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

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

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

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

    Gajab, best explanation

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

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

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

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

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

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

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

    Very well elaborated & perfect delivery! Thumbs up Sir.

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

    Excellent presentation and very useful tips. Thank you very much

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

    Nice content. Tutorials are much understandable without much time wasting

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

    Excellent teacher, I've never seen

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

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

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

    Today i learned an interesting lesions on excel

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

    Excellent tutorial , learning from KENYA Africa

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

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

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

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

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

    VERY GOOD AND USEFUL TUTORIAL. THANKS A LOT.

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

    very nice

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

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

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

    I really appreciate you taking the time to share your knowledge.

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

    Your videos are really useful. Thank you

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

    Your teaching way is impeccable sir

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

    I am big fan of your videos

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

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

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

    superb excellent very usefull, i want learn to excel expert

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

    Everything video Outstanding 👌👌

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

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

  • @abdulmalekat.9517
    @abdulmalekat.9517 5 років тому +1

    man you are great . thank you sooo much

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

    Each and everything I understand easily, Thnks sir

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

    Appreciating you enough sir🙏🏻

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

    Thank you so much for your amazing videos, dear sir

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

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

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

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

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

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

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

    Your way of teach ing is excellent sir.

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

    Hi sir I found your tutorial were useful, kindly help me to clarify my doubt
    In excel, how to extract data from the main "sheet1" and list/report in different sheets as per respective datasets.
    For example if receipts and payments are entered in sheet1 , and datas of different account heads must get posted in respective account head sheets automatically as and when the entries entered in main sheet.

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

    Sir, your all videos are very useful for us... please make a video on GOTO Special.....