How to Create a Data Entry Form in Excel in Tamil

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

[@EndlessKnowledge]

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]

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

[@vickybist]

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]

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]

thanks

[@krishkrish4785]

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

[@sabasettu8017]

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

[@EndlessKnowledge]

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

[@jyothikag8459]

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

[@ashokdeepa4206]

Student mark list and salary slip video upload panunga sir.

[@jpriya....mostoftamil9312]

S

[@balasupiramaniyank7533]

Thaks Sir.

[@narmathadurai2502]

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

[@EndlessKnowledge]

Thank You

[@YaroOruvan-tj7li]

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

[@mahimahi9650]

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

[@bkcinimascopeofficial]

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

[@bluebell9375]

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

[@EndlessKnowledge]

happy to hear that...

[@iniyavans5617]

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

[@kismet29]

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

[@loveismylife4396]

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

[@EndlessKnowledge]

thanks & All the best...

[@appasfacts...5857]

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

[@lavanyas4563]

I worked in tcs before 6 years.. Left job.. I'm a home maker.. Dint try for job...im not updated with computer knowledge n even other facts since I m engaged with family...
Now next week I'm gonna attend interview in cts referred by my husband.. They need a person well versed in excel...
I found ur videos are very helpful.. Learnt all videos in excel in endless knowledge.. Thank you
Vaalga valamudan...!

[@EndlessKnowledge]

glad to hear that... All the best...

[@lavanyas4563]

@@EndlessKnowledge totally 23 videos iruka bro in ms excel?

[@EndlessKnowledge]

Actually 107 videos 🙂

[@lavanyas4563]

@@EndlessKnowledge kaduvulae...! I found oly 23...will look for it ...:) thank you for your reply.. Vaalga valamudan!

[@EndlessKnowledge]

ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

[@rgopilingam]

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!

[@sangavivairamuthu3911]

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

[@sangavivairamuthu3911]

@@Surya-ph8ml what

[@laxmisarvaesh8566]

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

[@prabu7965]

Me too sister 😊😊

[@nimmigeorge4890]

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

[@lakshminarayananvijayakumar]

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

[@janakiraman9632]

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.

[@alwaysbehappy-o1h]

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

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

[@malarvizhis8883]

பணம் கட்டி படித்தாலும் இவ்வளவு தெளிவாக சொல்லித்தர மாட்டார்கள்.

[@maheswariselva9379]

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

[@gomathiseenivasan2083]

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

[@manishpandya9102]

Puriyadhavangalukku kuda easy ya puriyara maathiri solli tharinga bro super

[@croreguessing6477]

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

[@mosesjael6149]

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

[@jptamilsinger6807]

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]

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

[@hephzibahrubym.a8331]

Sir ur teaching is very easy 2 understand n learn quickly

[@kumarkailasanathan961]

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

[@dianaroslinandrews5729]

I'm searching if I have any doubts. There is lots of video came. But I'm scrolling for endless knowledge. I'm became your student now

[@EndlessKnowledge]

Glad to hear that... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

[@Napoleonvlogz]

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

[@vigneshselvakumaran4421]

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

[@shenbagamd3212]

Really your way of teaching awesome sir... Clear explanation and to understand easily sir... Thank you so much sir... 🙏

[@sathyanarayanansatagopan9069]

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

[@abinaya.k8486]

Really helpful bro thank you so much❤

[@logesharavindan3848]

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

[@jeniferjeni2651]

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

[@sankarraj4093]

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

[@EndlessKnowledge]

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

[@murugananthamselvam2587]

நீங்கள் சொல்லித் தருவது மிகவும் தெளிவாகவும் அனைவருக்கும் புரியும்படியும் உள்ளது மிக்க நன்றி

[@EndlessKnowledge]

Glad to hear that... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

[@shanmugapriyan.s2220]

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]

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

[@Oranje014]

Thank you brother. Simple explanation with clarity.

[@EndlessKnowledge]

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

[@gobalakrishnank2262]

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

[@lakshminarayanansk5623]

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

[@ashaxavier236]

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

[@madrasnarayan]

Fastness

[@anandparthiban2209]

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]

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

[@pavithrabaskar8748]

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🙏

[@EndlessKnowledge]

Thanks and welcome

[@sureshmech5064]

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

[@jayanthijayanthi6110]

Hii sir I am not having a computer sense but now I am a good position in one company it's all about you sir I watched your video daily I improved my self thank you so much sir

[@EndlessKnowledge]

Glad to hear that... Everything god's grace... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

[@DineshKumar-nh1ux]

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

[@BaluBalu-dv7bk]

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

[@Nandakumar-km1pc]

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🎉❤

[@angulyabharnammadhusudhan1940]

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

[@nivethanagarajan3239]

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

[@shenbagamd3212]

God Bless You Abundantly... 👑👑👑

[@tamilsongs108]

ஐயா வணக்கம் நீங்கள் நடத்துவது மிக மிக எளிமையாக உள்ளது.. நன்கு புரிகின்றது மிக மிக நன்றி

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

[@suganyasugan3714]

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

[@keerthukeerthi7086]

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

[@vijiviji-kd6gf]

Bro unga voice nd explanation very supper👌

[@vijayavijayalakshmi578]

Thank you anna explanation clear ahh இருந்திச்சி.

[@EndlessKnowledge]

glad it was useful to you... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

[@jayashree06]

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

[@tamilmalavan6725]

Ungka video ellam enakku help ahh erukku bro

[@EndlessKnowledge]

Glad it was helpful to you my brother... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

[@D.Nandhini]

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

[@sathishkumar2585]

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

[@Arunkumar-uc6kd]

Boss neenga Vera level 🎉❤

[@jeniferjeni2651]

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

[@gokulaprabu9474]

God bless you enoda future eh ithula tha iruku and onum pay panama ivlo therunjukita thank you so much

[@EndlessKnowledge]

Thank you so much... All the best...

[@punisweety3713]

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

[@EndlessKnowledge]

Always welcome

[@வாழ்கவளமுடன்-ய2ண]

அருமை நன்றி.
இப்படிக்கு
நவீன தமிழன் UA-cam Channel

[@parameshwarip1267]

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

[@vijayanagaraj9725]

Sir na 10th tha paduchurukinga ana computer pathi suthamah Theriyathanga ana Neenga podra videos enaku roamba help full ah irukunga sir

[@devi3676]

Bro super clear explanation but ore oru kurai data entry pana soninga atha epdi save pantrathunu soningana romba clear ah irukum computer panthi onume theriyatha ena mathiri atakaluku romba useful ah irukum

[@jisanathahir6703]

Most valuable UA-cam channel

[@STUDIOTAMIL-VSD]

Unga explanation nalla puriyuthu thanks

[@EndlessKnowledge]

your most welcome...

[@rokesh.r4700]

Super Video.I always watch your videos only

[@EndlessKnowledge]

So nice of you... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

[@jpriya....mostoftamil9312]

Bro its awesome..... really I appreciate you.....its very useful for me...my lab practical as 38 marks scored...... reason for your vedio.... 🤗

[@EndlessKnowledge]

glad to hear that brother... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

[@aswitharanjith9168]

Ur way of teaching superb Anna..

[@EndlessKnowledge]

Thank you so much 🙂

[@sandhiyasandrio5364]

Bro neenga romba clear ah soldringa bro super thank u

[@bhavithrapnp7554]

Anna U r video everyone is superb and clear explanation. I need video about e-commerce like Amazon , Flipkart like that. How to work e-commerce in excel sheet. Please put videos anna

[@nanthalalks8618]

எனக்கும்கூட, தெளிவா புரியுது . தம்பி!! நன்றி!!!

[@EndlessKnowledge]

Glad to hear that... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

[@thingstotakeoff4777]

Who put dislike for this video is really mentals because it is very helpful for all the people

[@svk451]

நீங்கள் சொல்லும் விதம் அருமை நன்றி தோழர்

[@paramasivam4024]

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

[@sajithabarveenshahulhameed9946]

Thank you sir … Understanding very clearly

[@EndlessKnowledge]

Glad to hear that... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

[@vijayasingamlukshanth7872]

Hi bro , your videos are very good to learning thanks for that..
can you upload All shortcuts formulas in exel.

[@pavithrabalaraman2588]

God bless u always💚💙

[@1980leodte]

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

[@Sakthivel-qg4yr]

Bro thank you roomba naala find pannunen kedaikala,but today I got it.. Thank you so much., Subscribed.

[@durairaj9454]

Bro normal ah entery panrathukkum iethukku enna different sollunga

[@durairaj9454]

Form LA entry panrathu Vida normal ah entery panna fast pannalam

[@Sakthivel-qg4yr]

@@durairaj9454 bro ethula nenga 1000 name list type pannalum ungalukku thevaianathu Mattum easy ah eduthukalam..

[@praveenrobert4800]

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

[@EndlessKnowledge]

Most welcome 👍...

[@RajeshKumar-uh6zi]

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

[@amjathamjath2669]

Sir I am from sri lanka very well sir I am prayer for you in sha allah thanks sir very yousfull me

[@EndlessKnowledge]

Glad it was useful to you and thank you so much for your prayers and support my brother... Keep learning more about MS Word ua-cam.com/play/PLLHRrAfRqTbP_WKQaz7pnzR6pkHr1lGRh.html

[@sheelaj9480]

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

[@prakathishwarans1622]

Simply "best of your video's"

[@priyangakrish2573]

Thank you kadavul mathiri kapathuninga nandri anna

[@Srinivasan-q1h]

This was awesome. Thank you. One clarification. If there are plenty of Entries, example 100 or 200 to be filled, how to load it, i mean, is there any easy way? And is there anything like advance Data entry?

[@nmanikandan866]

Your voice so nice brother it's very useful.

[@EndlessKnowledge]

Thanks and welcome

[@raniselvaraj9544]

Romba thanks na easy ah solli kuduthutenge

[@marimuthu9038]

சார் வணக்கம்..... சூப்பர்...

[@ohmprakash.b2970]

Vera level thalaiva

[@dayanandannatarajan4882]

வணக்கம். நீங்கள் மிக தெளிவாக பயிற்றுவிக்கும் விதம் தனித்துவம் சார்ந்து உள்ளது. முதலில் இதற்கு வாழ்த்து. அடுத்து புதிய தகவல் வேண்டும். ஒவ்வொரு முறையும் தனித்தனி FILES Create ஆன பின்னர் அவற்றின்இயக்கங்களுக்கும் மீண்டும் மீண்டும் புதிய Data Entry Form தயார் செய்ய வேண்டுமா?
தயவுசெய்து தெரிவிக்க வேண்டும் படி கேட்டுக்கொள்கிறேன். நன்றி.

[@minnahrameez1827]

Very very clear you're explaining sir

[@damaaldumeeltamil6987]

Your voice is very very clear

[@EndlessKnowledge]

thanks... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

[@bharathijayamurugan9834]

Thank you so much for the wonderful tutorial 💐💐

[@HD-gb7xl]

Neenga best teacher 👍Romba clear ah explain panringa Subscribe pannitan Vid Friends kum share panniruken.. 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍

[@Muthumari82]

Super brother tq for your vedio ☺️