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.
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
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
U tube ல நிறைய கம்ப்யூட்டர் படிப்பதற்கு வீடியோ இருந்தாலும் நீங்கள் தமிழில் எளிமையாக சொல்லித்தரும் விதத்தை பாராட்டுகிறேன் உங்கள் முயற்சி தொடரட்டும். மாணவர்களுக்கு மிகவும் உபயோகமானதாக இருக்கும். உங்கள் முயற்சி கம்ப்யூட்டர் படிக்க விரும்பும் எல்லோரையும் போய் சேரவேண்டும்
U tube ல நிறைய கம்ப்யூட்டர் படிப்பதற்கு வீடியோ இருந்தாலும் நீங்கள் தமிழில் எளிமையாக சொல்லித்தரும் விதத்தை பாராட்டுகிறேன் உங்கள் முயற்சி தொடரட்டும். மாணவர்களுக்கு மிகவும் உபயோகமானதாக இருக்கும். உங்கள் முயற்சி கம்ப்யூட்டர் படிக்க விரும்பும் எல்லோரையும் போய் சேரவேண்டும்
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!
ரொம்ப நன்றி அண்ணா எனக்கு இப்படி புரியும்படி யாரும் சொல்லி தந்ததில்ல Ipo part-time job ku இது எனக்கு தெரிஞ்சா தான் வேலையே🥺😢😢😢 உங்களுக்கு கோடி புண்ணியம் அண்ணா
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
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.
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...!
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
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?
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
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
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
Glad to hear that... Everything god's grace... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
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
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🙏
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🎉❤
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
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
Glad it was useful to you and thank you so much for your prayers and support my brother... Keep learning more about MS Word th-cam.com/play/PLLHRrAfRqTbP_WKQaz7pnzR6pkHr1lGRh.html
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
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.
i was wondering why use form to enter data while the watching video. but this explanation makes sense.
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
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
thanks
sir i need some formula, dropdown list, field calculation and date picker can i add for form how to add pls explain
U tube ல நிறைய கம்ப்யூட்டர் படிப்பதற்கு வீடியோ இருந்தாலும் நீங்கள் தமிழில் எளிமையாக சொல்லித்தரும் விதத்தை பாராட்டுகிறேன் உங்கள் முயற்சி தொடரட்டும். மாணவர்களுக்கு மிகவும் உபயோகமானதாக இருக்கும். உங்கள் முயற்சி கம்ப்யூட்டர் படிக்க விரும்பும் எல்லோரையும் போய் சேரவேண்டும்
Thank you so much.... everything god's grace...
😐😇😇😇😇😑🤗😘😘😅😃😄😄🤗🤗😍😍😐😊😗😆😆😆😗😗😆😀🧘🏽😣😣_---//98(!&-;++-*%'&-&''@@EndlessKnowledge DX.
Rx Ffp
Student mark list and salary slip video upload panunga sir.
S
Thaks Sir.
நீங்க போடுற வீடியோஸ் எல்லாம் பயனுள்ளதாக இருக்கிறது சார் நன்றி 🙏🙏🙏
Thank You
Roll number column la Ek nu pottu numbers podrathukke enna reason bro
Na computer class basic kuda theriyama irunthen unga video very useful ippo oralavukku computer knowledge vanthuttu sir thank for ur support
U tube ல நிறைய கம்ப்யூட்டர் படிப்பதற்கு வீடியோ இருந்தாலும் நீங்கள் தமிழில் எளிமையாக சொல்லித்தரும் விதத்தை பாராட்டுகிறேன் உங்கள் முயற்சி தொடரட்டும். மாணவர்களுக்கு மிகவும் உபயோகமானதாக இருக்கும். உங்கள் முயற்சி கம்ப்யூட்டர் படிக்க விரும்பும் எல்லோரையும் போய் சேரவேண்டும்
Now only.....1st time I saw ur video.......Very clear explanation...easy to understand.....Tq broooo....✨👍 Very useful.....
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!
Sir I don't know any computer skills but now watch your videos I am huge of skills in my mind
happy to hear that...
Just watching and keeping in your mind is not enough keep practising
@@iniyavans5617 yes that's what he said.😊
TH-cam ல excel கத்துகிடலாம்னு முதல்லே தெரிஞ்சிருந்தா எப்போமோ கத்துருப்பேன். ரொம்ப நன்றி அண்ணா ரொம்ப ஈசியா இருக்கு
thanks & All the best...
I dont know any computer skills..after seeing ur videos..I am confident ..I can learn well..Thanks sir..
Big salute to u.
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.
I AM LEARNING EXCEL STEP BY STEP BY YOUR WONDERFUL VIDEOS THANK U SIR
Me too sister 😊😊
Bro... Unga video va ippothaan paaththen romba nalla enakku puriyuthu... Thanks to teach.... Thank you
ரொம்ப நன்றி அண்ணா
எனக்கு இப்படி புரியும்படி யாரும் சொல்லி தந்ததில்ல
Ipo part-time job ku இது எனக்கு தெரிஞ்சா தான் வேலையே🥺😢😢😢 உங்களுக்கு கோடி புண்ணியம் அண்ணா
@@Surya-ph8ml what
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
I like your channel name ENDLESS KNOWLEDGE.
Very clearly explaining
Even 5 year old child will work out excel ☺
Puriyadhavangalukku kuda easy ya puriyara maathiri solli tharinga bro super
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
Glad to hear that... Keep learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
I'm a new one in this channel and Its clear bro......
Thanks for giving a new to me sir. Na excel படிகும் பொது இது தெரியாது. U give a lots of information sir. 🙏🙏🙏🙏
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
bro ....romba simple method use panni teach panringa ..
so easy to understand....thanks for your service.
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.
சார் உங்களுடைய குரல் நல்லா இருக்கு சொல்லித்தரும் விதம் அதைவிட அருமையா இருக்கு
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...!
glad to hear that... All the best...
@@EndlessKnowledge totally 23 videos iruka bro in ms excel?
Actually 107 videos 🙂
@@EndlessKnowledge kaduvulae...! I found oly 23...will look for it ...:) thank you for your reply.. Vaalga valamudan!
th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Excellent. Easy to understand. Thank you for a meticulous teaching.
நீங்கள் சொல்லித் தருவது மிகவும் தெளிவாகவும் அனைவருக்கும் புரியும்படியும் உள்ளது மிக்க நன்றி
Glad to hear that... Keep Learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
பணம் கட்டி படித்தாலும் இவ்வளவு தெளிவாக சொல்லித்தர மாட்டார்கள்.
Best teacher in youtuber
I really enjoy the tutorial and very useful . thanks for your tutorial.
Your way of teaching is very useful for me to step up to the next level of my future ,thankyou for teaching this.😊
Excellent work and crisp & clear content... Great bro.... The way of explaining is awesome.. keep doing well...
Thank you so much nanba... Keep watching more videos...
Thank you brother. Simple explanation with clarity.
You are welcome brother... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Sir, Thank You Very Much! I am eagerly awaiting your video about dynamic searchable drop down list.
You explained very clearly ....nd understand pandrathuku easyy ya iruku
How to implement data validation in cells, for example, Roll No should be numeric, Course should be character etc?
Unka explanation very clear and useful sir... And ur voice.... Thanks alot u
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
Very nice bro.Enaku romba pudichatha nenga solli thara classes.
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?
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
Really your way of teaching awesome sir... Clear explanation and to understand easily sir... Thank you so much sir... 🙏
what is the advantage of creating form and entering data instead of directly entering data in the excel sheet
i was thinking the same bro..
its juts an alternate way tats all
Fastness
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
Easily database entrie excel and fast data access to finish your work
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
Glad to hear that... Everything god's grace... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
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
Sir ur teaching is very easy 2 understand n learn quickly
Bro how to costomize print layout as label format, afterwards finish the forms
நீங்கள் சொல்லித்தரும் விதம் எனக்கு மிகவும் பிடித்துள்ளது அண்ணா. புரிந்துகொள்ள மிக எளிமையாக உள்ளது. மிக்க நன்றி....
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🙏
Thanks and welcome
Tq so much Bro🎉its very useful for correct time for me thankyou so much bro❤😊
You're most welcome! I hope this helps you save time on your data entry tasks... th-cam.com/video/dl89dz0LQQY/w-d-xo.html
Most valuable TH-cam channel
Bro thank you roomba naala find pannunen kedaikala,but today I got it.. Thank you so much., Subscribed.
Bro normal ah entery panrathukkum iethukku enna different sollunga
Form LA entry panrathu Vida normal ah entery panna fast pannalam
@@durairaj9454 bro ethula nenga 1000 name list type pannalum ungalukku thevaianathu Mattum easy ah eduthukalam..
அருமை நன்றி.
இப்படிக்கு
நவீன தமிழன் TH-cam Channel
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🎉❤
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
ஐயா வணக்கம் நீங்கள் நடத்துவது மிக மிக எளிமையாக உள்ளது.. நன்கு புரிகின்றது மிக மிக நன்றி
God bless you enoda future eh ithula tha iruku and onum pay panama ivlo therunjukita thank you so much
Thank you so much... All the best...
Sir na 10th tha paduchurukinga ana computer pathi suthamah Theriyathanga ana Neenga podra videos enaku roamba help full ah irukunga sir
Who put dislike for this video is really mentals because it is very helpful for all the people
Super Video.I always watch your videos only
So nice of you... Keep Learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Wow it's very usefull to me and u r teaching is very nice and quickly understood
Your vedio is very useful for freshers thanks to vedio Anna..
Very good teaching bro superior super and video s very usefull cleara sollurenga 👍👍👍👍nice
Neenga best teacher 👍Romba clear ah explain panringa Subscribe pannitan Vid Friends kum share panniruken.. 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
Tq so much sir ...I can understand very easily....
Always welcome
Supr anna... thankyou for ur Tamil speech 😅and also best teaching skill.... keep rocking 😉
Bro its awesome..... really I appreciate you.....its very useful for me...my lab practical as 38 marks scored...... reason for your vedio.... 🤗
glad to hear that brother... Keep learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Fantastic channel for basic beginners...keep teaching and improve our people digital knowledge...
பயனுள்ளதாகவும் தெளிவாகவும் இருந்தது
Ur way of teaching superb Anna..
Thank you so much 🙂
Sir your video presentation was simple & easily understandable both in tamil & english. Thak you sir.
God Bless You Abundantly... 👑👑👑
எனக்கும்கூட, தெளிவா புரியுது . தம்பி!! நன்றி!!!
Glad to hear that... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Thank you kadavul mathiri kapathuninga nandri anna
மிகவும் அருமையான கானொளி பதிவு. நன்றி.
Glad you liked it... Keep Learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Really helpful bro thank you so much❤
Thank you sir … Understanding very clearly
Glad to hear that... Keep learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Very very clear you're explaining sir
Bro neenga romba clear ah soldringa bro super thank u
Simply "best of your video's"
So sweet bro nirata jobku use akum computer la nirya visayam kathakanum asaiya eruku niraya video podunka plez ❤
நீங்கள் சொல்லும் விதம் அருமை நன்றி தோழர்
Bro unga voice nd explanation very supper👌
Ungka video ellam enakku help ahh erukku bro
Glad it was helpful to you my brother... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
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
nee slrathu nala puriyuthu athnala typing class kuda podunga plz.. Keep on anna🥳🔥
Boss neenga Vera level 🎉❤
Sir I am from sri lanka very well sir I am prayer for you in sha allah thanks sir very yousfull me
Glad it was useful to you and thank you so much for your prayers and support my brother... Keep learning more about MS Word th-cam.com/play/PLLHRrAfRqTbP_WKQaz7pnzR6pkHr1lGRh.html
your explanations are very nice, Clear and excellant
Thanks.... Keep watching
Sema Voice Sir Super Explain I Understand to All Your Videos
Thanks Sir
Most welcome 👍...
Thank you sir it's very useful and understandable 🥰🥰🥰🥰😊😊😊
Like ur voice🤩and clear cut....content explanation👌👌👌
Excellent master
Crystal clear
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
Bro niga vera level bro ithu romba help irukum bro
Really Understood Sir... Nice explanation.
Glad to hear that... Keep learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Ithe Pola innum neraiya video podunga.unga coaching very super 👌👌👍. Thank u.
Congratulations... thanks for brief to data entry form
சார் வணக்கம்..... சூப்பர்...
Your explanation very excellent
Unga explanation nalla puriyuthu thanks
your most welcome...
Very clear your explanation thanks bro.....superb
Welcome 👍