How to Create a Data Entry Form in Excel in Tamil

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 เม.ย. 2020
  • Click the Link below to learn. (Subscribe for more upcoming Tutorials)
    Top 10 Excel Shortcuts for Beginners
    • Top 10 Excel Shortcuts...
    Table of Contents in MS Word in Tamil
    • Table of Contents in M...
    List of Tables and Figures in MS Word in Tamil
    • List of Tables and Fig...
    VLOOKUP in Excel in Tamil
    • VLOOKUP in Excel in Tamil
    Recommended Pivot Table in Excel in Tamil
    • Recommended Pivot Tabl...
    Slicer in excel in Tamil
    • Slicer in Excel in Tamil
    MS Excel Pivot Table in Tamil
    • MS Excel Pivot Table i...
    MS Word Translate Document
    • MS Word Translate Docu...
    COUNTIF formula in excel in Tamil
    • COUNTIF formula in exc...
    Signature line in MS Word
    • Signature line in MS W...
    How to Insert Section Break in MS Word Tamil
    • How to Insert Section ...
    Excel Formula Basics in Tamil
    • Excel Formula Basics i...
    Excel Basics for Beginners in Tamil
    • Excel Basics for Begin...
    Excel Printing Page Setup in Tamil
    • Excel Printing Page Se...
    *****************
    Drop your doubts and suggestions in the comments. Don't forget to Like and Share the Video.
    MS Word Tutorial in Tamil
    • Watermark in MS Word i...
    PowerPoint Tutorial in Tamil
    • PowerPoint Animation T...
    ******************

ความคิดเห็น • 1.1K

  • @EndlessKnowledge
    @EndlessKnowledge  4 ปีที่แล้ว +132

    Why we need to use Excel Data Entry Form?
    When a row of data is very wide and requires repeated horizontal scrolling, then use data form to add, edit, find, and delete rows. Because a data form provides a convenient means to enter or display one complete row of information in a range or table without scrolling horizontally. You may find that using a data form can make data entry easier than moving from column to column when you have more columns of data than can be viewed on the screen.

    • @venkat19922000
      @venkat19922000 3 ปีที่แล้ว +8

      i was wondering why use form to enter data while the watching video. but this explanation makes sense.

    • @vickybist
      @vickybist 3 ปีที่แล้ว

      Click the below link to Download Paid version of Excel Bible 2019 for free
      Michael Alexander, Richard Kusleika, John Walkenbach - Excel 2019 Bible (0, Wiley).pdf
      up-load.io/rd6rmtq161jm

    • @rajasekaransundararaj6975
      @rajasekaransundararaj6975 3 ปีที่แล้ว +2

      I agree sir. But, how even Data Form with more entries maybe 100 above, show on display at once. As I am not sure, even with smallest font, full col / row may not fit at once. Pl explain

    • @vijilakshmi1903
      @vijilakshmi1903 3 ปีที่แล้ว

      thanks

    • @krishkrish4785
      @krishkrish4785 3 ปีที่แล้ว +1

      sir i need some formula, dropdown list, field calculation and date picker can i add for form how to add pls explain

  • @sabasettu8017
    @sabasettu8017 3 ปีที่แล้ว +304

    U tube ல நிறைய கம்ப்யூட்டர் படிப்பதற்கு வீடியோ இருந்தாலும் நீங்கள் தமிழில் எளிமையாக சொல்லித்தரும் விதத்தை பாராட்டுகிறேன் உங்கள் முயற்சி தொடரட்டும். மாணவர்களுக்கு மிகவும் உபயோகமானதாக இருக்கும். உங்கள் முயற்சி கம்ப்யூட்டர் படிக்க விரும்பும் எல்லோரையும் போய் சேரவேண்டும்

    • @EndlessKnowledge
      @EndlessKnowledge  3 ปีที่แล้ว +34

      Thank you so much.... everything god's grace...

    • @jyothikag8459
      @jyothikag8459 2 ปีที่แล้ว

      😐😇😇😇😇😑🤗😘😘😅😃😄😄🤗🤗😍😍😐😊😗😆😆😆😗😗😆😀🧘🏽😣😣_---//98(!&-;++-*%'&-&''@@EndlessKnowledge DX.
      Rx Ffp

    • @ashokdeepa4206
      @ashokdeepa4206 2 ปีที่แล้ว +3

      Student mark list and salary slip video upload panunga sir.

    • @jpriya....mostoftamil9312
      @jpriya....mostoftamil9312 2 ปีที่แล้ว

      S

    • @balasupiramaniyank7533
      @balasupiramaniyank7533 10 หลายเดือนก่อน

      Thaks Sir.

  • @narmathadurai2502
    @narmathadurai2502 4 ปีที่แล้ว +132

    நீங்க போடுற வீடியோஸ் எல்லாம் பயனுள்ளதாக இருக்கிறது சார் நன்றி 🙏🙏🙏

    • @EndlessKnowledge
      @EndlessKnowledge  4 ปีที่แล้ว +2

      Thank You

    • @YaroOruvan-tj7li
      @YaroOruvan-tj7li 16 วันที่ผ่านมา

      Roll number column la Ek nu pottu numbers podrathukke enna reason bro

  • @bluebell9375
    @bluebell9375 3 ปีที่แล้ว +68

    Sir I don't know any computer skills but now watch your videos I am huge of skills in my mind

    • @EndlessKnowledge
      @EndlessKnowledge  3 ปีที่แล้ว +9

      happy to hear that...

    • @iniyavans5617
      @iniyavans5617 3 ปีที่แล้ว +4

      Just watching and keeping in your mind is not enough keep practising

    • @kismet29
      @kismet29 ปีที่แล้ว +1

      @@iniyavans5617 yes that's what he said.😊

  • @lakshminarayananvijayakumar
    @lakshminarayananvijayakumar 3 ปีที่แล้ว +4

    I really enjoy the tutorial and very useful . thanks for your tutorial.

  • @appasfacts...5857
    @appasfacts...5857 9 หลายเดือนก่อน +4

    Now only.....1st time I saw ur video.......Very clear explanation...easy to understand.....Tq broooo....✨👍 Very useful.....

  • @mahimahi9650
    @mahimahi9650 2 ปีที่แล้ว +2

    Na computer class basic kuda theriyama irunthen unga video very useful ippo oralavukku computer knowledge vanthuttu sir thank for ur support

  • @maheswariselva9379
    @maheswariselva9379 3 ปีที่แล้ว +2

    Thanks for giving a new to me sir. Na excel படிகும் பொது இது தெரியாது. U give a lots of information sir. 🙏🙏🙏🙏

  • @laxmisarvaesh8566
    @laxmisarvaesh8566 2 ปีที่แล้ว +16

    I AM LEARNING EXCEL STEP BY STEP BY YOUR WONDERFUL VIDEOS THANK U SIR

    • @prabu7965
      @prabu7965 2 ปีที่แล้ว +1

      Me too sister 😊😊

  • @gomathiseenivasan2083
    @gomathiseenivasan2083 3 ปีที่แล้ว +17

    Bro it's awesome. I love the way u teach us. U are teaching us inch by inch. Thanks a lot bro 🙏🙏🙏keep posting valuable videos bro

  • @mosesjael6149
    @mosesjael6149 2 ปีที่แล้ว +1

    Bro... Unga video va ippothaan paaththen romba nalla enakku puriyuthu... Thanks to teach.... Thank you

  • @angulyabharnammadhusudhan1940
    @angulyabharnammadhusudhan1940 4 ปีที่แล้ว +1

    Sir your video presentation was simple & easily understandable both in tamil & english. Thak you sir.

  • @sangavivairamuthu3911
    @sangavivairamuthu3911 3 ปีที่แล้ว +16

    ரொம்ப நன்றி அண்ணா
    எனக்கு இப்படி புரியும்படி யாரும் சொல்லி தந்ததில்ல
    Ipo part-time job ku இது எனக்கு தெரிஞ்சா தான் வேலையே🥺😢😢😢 உங்களுக்கு கோடி புண்ணியம் அண்ணா

  • @rgopilingam
    @rgopilingam ปีที่แล้ว +11

    Hi Mate, I am in Australia and when I look to learn Excel I found your channel which is absolutely awesome. I simply disregarded all the channels in English and started following yours because two main reasons 1. Mother tongue Tamil and 2. Your crystal clear explanations. Kudos to you and God bless you!

  • @jeniferjeni2651
    @jeniferjeni2651 2 ปีที่แล้ว

    Very nice bro.Enaku romba pudichatha nenga solli thara classes.

  • @sathishkumar2585
    @sathishkumar2585 3 ปีที่แล้ว +1

    Fantastic channel for basic beginners...keep teaching and improve our people digital knowledge...

  • @user-me4po5tl5h
    @user-me4po5tl5h 3 ปีที่แล้ว +11

    I like your channel name ENDLESS KNOWLEDGE.
    Very clearly explaining
    Even 5 year old child will work out excel ☺

  • @vigneshselvakumaran4421
    @vigneshselvakumaran4421 3 ปีที่แล้ว +5

    your tutorials are very useful and easy to understand Thank You brother

  • @1980leodte
    @1980leodte 3 ปีที่แล้ว +1

    Thank you so much bro.. Its very useful for us. What a cristal clear explanations..

  • @preethiprincy2677
    @preethiprincy2677 2 ปีที่แล้ว

    Really very useful.....and clear explanation bro🙏😇thank you so much

  • @jptamilsinger6807
    @jptamilsinger6807 3 ปีที่แล้ว +3

    God bless you sir. Because you are doing the sacrifice work that many more hast to grow to all people. All unknown persons will get good and well education by you. Best of luck, and always God will be with you.

    • @munusamyg3076
      @munusamyg3076 2 ปีที่แล้ว

      சார் உங்களுடைய குரல் நல்லா இருக்கு சொல்லித்தரும் விதம் அதைவிட அருமையா இருக்கு

  • @croreguessing6477
    @croreguessing6477 4 ปีที่แล้ว +9

    I'm a new one in this channel and Its clear bro......

  • @abinaya.k8486
    @abinaya.k8486 2 หลายเดือนก่อน +1

    Really helpful bro thank you so much❤

  • @janakiraman9632
    @janakiraman9632 2 ปีที่แล้ว

    I dont know about MS Excel before i not see to your video.Now i am learning watching your video on daily.your teaching is veryyy excellent.

  • @nimmigeorge4890
    @nimmigeorge4890 3 ปีที่แล้ว +6

    I dont know any computer skills..after seeing ur videos..I am confident ..I can learn well..Thanks sir..
    Big salute to u.

  • @sathyanarayanansatagopan9069
    @sathyanarayanansatagopan9069 3 ปีที่แล้ว +5

    Sir, Thank You Very Much! I am eagerly awaiting your video about dynamic searchable drop down list.

  • @hackermrj5033
    @hackermrj5033 ปีที่แล้ว

    Bro thank you so much bro actually naa avlovo tutorial video paathu irukken but ennakku sari understand aagala neeinga explain pannathu ennakku semma ya understanding aachu bro

  • @loveismylife4396
    @loveismylife4396 3 ปีที่แล้ว +2

    TH-cam ல excel கத்துகிடலாம்னு முதல்லே தெரிஞ்சிருந்தா எப்போமோ கத்துருப்பேன். ரொம்ப நன்றி அண்ணா ரொம்ப ஈசியா இருக்கு

  • @kumarkailasanathan961
    @kumarkailasanathan961 3 ปีที่แล้ว +12

    Excellent. Easy to understand. Thank you for a meticulous teaching.

  • @jeniferjeni2651
    @jeniferjeni2651 2 ปีที่แล้ว

    Ithe Pola innum neraiya video podunga.unga coaching very super 👌👌👍. Thank u.

  • @suganyasugan3714
    @suganyasugan3714 ปีที่แล้ว

    Unka explanation very clear and useful sir... And ur voice.... Thanks alot u

  • @sankarraj4093
    @sankarraj4093 2 ปีที่แล้ว +4

    Excellent work and crisp & clear content... Great bro.... The way of explaining is awesome.. keep doing well...

    • @EndlessKnowledge
      @EndlessKnowledge  2 ปีที่แล้ว +1

      Thank you so much nanba... Keep watching more videos...

  • @logesharavindan3848
    @logesharavindan3848 2 ปีที่แล้ว +5

    How to implement data validation in cells, for example, Roll No should be numeric, Course should be character etc?

  • @manishpandya9102
    @manishpandya9102 ปีที่แล้ว

    Puriyadhavangalukku kuda easy ya puriyara maathiri solli tharinga bro super

  • @sandhiyasandrio5364
    @sandhiyasandrio5364 3 ปีที่แล้ว

    Bro neenga romba clear ah soldringa bro super thank u

  • @shanmugapriyan.s2220
    @shanmugapriyan.s2220 ปีที่แล้ว +5

    Hi bro, can we do calculations using formulas in the data entry forms?
    For example, you showed total fees, paid and balance. Can the balance auto populated?

    • @EndlessKnowledge
      @EndlessKnowledge  ปีที่แล้ว +2

      you can but with vba its much more flexible... will try to upload a dedicated video soon... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

  • @gobalakrishnank2262
    @gobalakrishnank2262 3 ปีที่แล้ว +9

    Dear sir
    We have monitoring monthly objective data frm april to march month.
    Some data month on month
    Some data six month once
    Some data yearly once
    Can we explain how to create a graph with target line.
    Thanks for understanding

  • @balac8248
    @balac8248 4 ปีที่แล้ว

    Sir, Realy nice of u video, it is use full for me nice explanation.

  • @nirmalraj8985
    @nirmalraj8985 3 ปีที่แล้ว

    Very Good Explanation Sir. Really Useful. 👌👌👌👌👍👍👍👍👍

  • @lakshminarayanansk5623
    @lakshminarayanansk5623 4 ปีที่แล้ว +8

    what is the advantage of creating form and entering data instead of directly entering data in the excel sheet

    • @ashaxavier236
      @ashaxavier236 4 ปีที่แล้ว +2

      i was thinking the same bro..
      its juts an alternate way tats all

    • @madrasnarayan
      @madrasnarayan 4 ปีที่แล้ว

      Fastness

    • @anandparthiban2209
      @anandparthiban2209 4 ปีที่แล้ว +2

      When your maintaining big data in excel it will be useful bro’s It means finding difficulty to the exact cells which ur entering data regularly u can use this format bro’s ,,,,, it’s really useful for that

    • @sourisouri4470
      @sourisouri4470 4 ปีที่แล้ว +1

      Easily database entrie excel and fast data access to finish your work

  • @sureshmech5064
    @sureshmech5064 ปีที่แล้ว +3

    Bro We are doing manual entry normally in individual cell, using of form tools is same manual entry, there is no time consumption.
    If any difference - Please highlight, this is my kind request

  • @bharathijayamurugan9834
    @bharathijayamurugan9834 ปีที่แล้ว

    Thank you so much for the wonderful tutorial 💐💐

  • @BaluBalu-dv7bk
    @BaluBalu-dv7bk 3 ปีที่แล้ว +2

    Thank you sir it's very useful and understandable 🥰🥰🥰🥰😊😊😊

  • @DineshKumar-nh1ux
    @DineshKumar-nh1ux 4 ปีที่แล้ว +4

    Bro how to costomize print layout as label format, afterwards finish the forms

  • @ohmprakash.b2970
    @ohmprakash.b2970 3 ปีที่แล้ว +1

    Vera level thalaiva

  • @parameshwarip1267
    @parameshwarip1267 3 ปีที่แล้ว

    Wow it's very usefull to me and u r teaching is very nice and quickly understood

  • @Napoleonvlogz
    @Napoleonvlogz 3 ปีที่แล้ว

    bro ....romba simple method use panni teach panringa ..
    so easy to understand....thanks for your service.

  • @Sulthan12325
    @Sulthan12325 3 หลายเดือนก่อน

    Thanks A Lot I clearly understood,,

  • @jayashree06
    @jayashree06 2 ปีที่แล้ว

    You explained very clearly ....nd understand pandrathuku easyy ya iruku

  • @agnesj6625
    @agnesj6625 ปีที่แล้ว

    Super sir thank you for your explanation and very useful and i learning to computer skills thanks you sir yours explanation is very simple and easy understanding for authors

  • @gejalakshmi3417
    @gejalakshmi3417 3 ปีที่แล้ว

    Thank you its useful for the right time

  • @vijayageetha8642
    @vijayageetha8642 9 หลายเดือนก่อน

    Nice and very useful ,thank u

  • @deenasamuel1121
    @deenasamuel1121 3 ปีที่แล้ว

    Truly endless knowledge information sur

  • @vijiviji-kd6gf
    @vijiviji-kd6gf 3 ปีที่แล้ว +2

    Bro unga voice nd explanation very supper👌

  • @daamodharankm7771
    @daamodharankm7771 3 ปีที่แล้ว

    It's really awesome, keep on doing more video s

  • @jisanathahir6703
    @jisanathahir6703 ปีที่แล้ว

    Most valuable TH-cam channel

  • @rameshhariharan2623
    @rameshhariharan2623 2 ปีที่แล้ว

    super sir. good explanation easily understood. this i dont know now understand

  • @swethaqueen8126
    @swethaqueen8126 3 ปีที่แล้ว

    Semma bro really useful thank

  • @D.Nandhini
    @D.Nandhini 8 หลายเดือนก่อน

    So sweet bro nirata jobku use akum computer la nirya visayam kathakanum asaiya eruku niraya video podunka plez ❤

  • @signofshinejobs6391
    @signofshinejobs6391 3 ปีที่แล้ว

    Excellent master
    Crystal clear

  • @ajithmass1364
    @ajithmass1364 4 หลายเดือนก่อน

    Useful video nanpa

  • @ManojKumar-zc5om
    @ManojKumar-zc5om 2 ปีที่แล้ว

    Bro niga vera level bro ithu romba help irukum bro

  • @rathirathu1468
    @rathirathu1468 3 ปีที่แล้ว

    Thank you sir very clear explanation

  • @arunmari1498
    @arunmari1498 3 ปีที่แล้ว

    Thank you so much brother it's very useful to me thanks

  • @RajeshKumar-uh6zi
    @RajeshKumar-uh6zi 2 ปีที่แล้ว

    Your vedio is very useful for freshers thanks to vedio Anna..

  • @mraguraman3062
    @mraguraman3062 2 ปีที่แล้ว

    Sir very nice and excellent teaching sir. Thankyou sir. I want accounting method with excel

  • @nithya6936
    @nithya6936 ปีที่แล้ว

    Super and very useful..thank u

  • @minnahrameez1827
    @minnahrameez1827 2 ปีที่แล้ว

    Very very clear you're explaining sir

  • @keerthukeerthi7086
    @keerthukeerthi7086 3 ปีที่แล้ว +1

    nee slrathu nala puriyuthu athnala typing class kuda podunga plz.. Keep on anna🥳🔥

  • @meenasiva4741
    @meenasiva4741 ปีที่แล้ว

    Super easy a puriyuthu

  • @jpyogeshpillai4077
    @jpyogeshpillai4077 4 ปีที่แล้ว +2

    Thank you. Easy understanding.....

  • @Oranje014
    @Oranje014 ปีที่แล้ว +1

    Thank you brother. Simple explanation with clarity.

    • @EndlessKnowledge
      @EndlessKnowledge  ปีที่แล้ว

      You are welcome brother... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

  • @velmurugan-bl9nx
    @velmurugan-bl9nx 3 ปีที่แล้ว

    Superb bro nice explanation and useful too......

  • @fathimashafna9092
    @fathimashafna9092 ปีที่แล้ว

    Tnq bro it's vry useful clear vdo

  • @pavithrabaskar8748
    @pavithrabaskar8748 3 ปีที่แล้ว

    First time unga video pakuran bro semaya iruku clear explanation in tamil. So many channels are there in you tube but unga videosla clear ah iruku bro thank u so much🙏

  • @musarudeen
    @musarudeen 2 ปีที่แล้ว

    Thank you sir.very useful video

  • @shobyashlynn4276
    @shobyashlynn4276 3 ปีที่แล้ว

    Very gud explanation thank u verymuch

  • @loopsi-vx2ek
    @loopsi-vx2ek 2 ปีที่แล้ว

    Tq, semmaya sollirukkinga👌😍

  • @saranyas9966
    @saranyas9966 4 ปีที่แล้ว

    It's very useful sir..thnk you so much

  • @karthikathangavel5870
    @karthikathangavel5870 3 ปีที่แล้ว

    Thank you it's very useful

  • @punithalatha1218
    @punithalatha1218 ปีที่แล้ว

    Thank you sir .very clarification

  • @priyangakrish2573
    @priyangakrish2573 3 หลายเดือนก่อน

    Thank you kadavul mathiri kapathuninga nandri anna

  • @mohanraje5035
    @mohanraje5035 2 ปีที่แล้ว

    Very good viedio .it's very useful to all thanks

  • @RajaRaja-we9hs
    @RajaRaja-we9hs 3 ปีที่แล้ว

    Your explanation very excellent

  • @akilasuresh1996
    @akilasuresh1996 ปีที่แล้ว

    Very useful vedio sir thanq very much

  • @MegamAjay
    @MegamAjay 2 ปีที่แล้ว

    Thx bro. Very useful..

  • @nandakumargayathiri6353
    @nandakumargayathiri6353 3 ปีที่แล้ว

    Thank bro very useful for me 👌👌👌

  • @praveenrobert4800
    @praveenrobert4800 4 ปีที่แล้ว +2

    Sema Voice Sir Super Explain I Understand to All Your Videos
    Thanks Sir

  • @senthil1976
    @senthil1976 4 ปีที่แล้ว +1

    your explanations are very nice, Clear and excellant

  • @thozhamaivg2308
    @thozhamaivg2308 3 ปีที่แล้ว

    Very clear your explanation thanks bro.....superb

  • @eagleeye8871
    @eagleeye8871 3 ปีที่แล้ว +2

    Thank you so much anna❤️

  • @jebinkutty4545
    @jebinkutty4545 ปีที่แล้ว

    Tq sir its very useful information 💜💯🙌🏻🤞🏻

  • @arjundencing
    @arjundencing 4 ปีที่แล้ว +1

    Thank you Bro!

  • @yasminayub3802
    @yasminayub3802 4 ปีที่แล้ว +1

    Awesome❤️❤️

  • @paramasivam4024
    @paramasivam4024 3 ปีที่แล้ว

    பயனுள்ளதாகவும் தெளிவாகவும் இருந்தது

  • @Stephen_raj7
    @Stephen_raj7 2 ปีที่แล้ว

    Thank you sir was usefull..

  • @sheelaj9480
    @sheelaj9480 ปีที่แล้ว

    Like ur voice🤩and clear cut....content explanation👌👌👌

  • @Nandakumar-km1pc
    @Nandakumar-km1pc 14 วันที่ผ่านมา

    Less timing video but Easily understand and learn everything but another channel video is huge that super but you speech and Teaching skills is Wonderful bro🎉❤

  • @nivethanagarajan3239
    @nivethanagarajan3239 3 ปีที่แล้ว

    Very good teaching bro superior super and video s very usefull cleara sollurenga 👍👍👍👍nice

  • @punisweety3713
    @punisweety3713 3 ปีที่แล้ว +1

    Tq so much sir ...I can understand very easily....