Creating Easy Data Entry Forms in Excel
HTML-код
- Опубликовано: 11 май 2024
- Learn how to easily create and access data entry forms in Excel that will help you more accurately and quickly enter data. It takes just a few easy steps to create the form, and then you just need to understand the forms features, and you're all set to use your new data entry form. Here's a link to the practice file for this video: bit.ly/employeelistcreatingforms Here's my entire playlist of Excel tutorials: bit.ly/tech4excel
Join this channel to get access to perks:
/ @techteachersandstudents
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... - Хобби
Thank you so much. You have a great teaching technique. I am 72 years old and learning so much from your videos.
Now ur 73 years old
Now you're 74, are you doing alright?
74
God bless you Barry❤️
Now 75
A lot of people are getting jobs without having much computer knowledge, and this is extremely helpful. Thank you!
I love this video, thanks a bunch.
It's always great to be reminded how efficient one can be when using such softwares. Amazing great job.
This is really good.Very simple yet great way of yours to deliver us all this knowledge.Thank You Sir.
I really respect your work and hope you keep delivering us this knowledge.
This is super useful for my job! I'm really enjoying these tutorials, your presenting style is so clear and friendly, and pleasant to listen to, which I find really helps learning and understanding.
Great :)
You get the blue-ribbon for teaching excellence! Thank you for this. Wish I would have found you last year. One thing you did not mention tho leaves me with a question - If one might need to change the table back to the regular version - how? Or is that possible? What would happen to the formatting and/or data? Silly question I guess, but still a tidbit of knowledge that might be helpful to someone someday.
Easy to follow, precise & informative how-to. Thank you.
Thank you, this is the first Excel tutorial I was able to follow along with exactly, you saved me a ton of work!
Glad it helped!
Thanks so much for this tutorial! It will be a huge time saver for the company I helping with their inventory and invoicing. Excellent and straightforward, not a time-suck!
The best part of your teaching is, you explain things in a very simple way. Thank you for making my way easier to know Excel.
AND... your cursor is moved in a calm logical way. When that cursor moves around like an italian womans hands... it is greatly distracting!
He is just a good teacher, and patient
Thanks very much for this tutorial. In fact I love all your tutorials. They are all informative, albeit not always easy to grasp depending on the subject matter but still very good. I am sticking to your channels for all your tutorials in all applications as refreshers now as you deliver very useful tips and /or lessons.
Today good time with Google developers consolas foro profesional Android invermemt marketing foro bitcoin city club
Thanks for the tutorial.
I really appreciate your style of teaching, it's really simple.
Am following from Monrovia, Liberia. Once again, I say thank you!!
Glad I came across this video. It has made my job so much easier and less stressful. Subscribed just because of this video. Thanks so much
Thank you very much, I watched all your video and can't wait for next Monday, Please can you explain more about Vlookup and Macro's too.
This is a very useful tool. THANK YOU for showing me how to accomplish this task.
This is awesome to get large data accurately filed in ! Thanks a Ton
simple database very useful for home users and I searched for nearly 3 hours in google and many confused except you identified at excel itself as so far it is unnoticed - thank you very much
I love his teaching. Thank you for sharing your knowledge. New Patreon member!
Great tutorial, it would be great if the Data-Validation of some fields set as a drop-down reflected in the form. For example in you demo, the list of departments could be a drop-down, but the form does not allow for that.
Very true
This is the most valuable video about data entry on the platform. Thank you so much!
The way you teach people is so nice thank you , now I know Excel
That's exactly what I was looking for. The video is directive, simple to understand. And to the point 👉.... good job
We do this type of work for our clients and all their data-entry work so I can confirm this is a great tutorial for those who want to do it themselves.
Wow nice learning
This is one of the best tutorials on ms excel i've seen in RUclips. Thank you very much for helping us learned more about excel.
Absolutely helpful. You're good teacher to the core
Thank you so much, your tutorials have been valuable.Keep it up👍
Extremely clear and thorough explanation!! Thanks for your efforts.
Plain, precise and audible thanks.
I loved it. It was so easy to understand and very informative as well.
Thanks for the helpful tutorial , i am really delighted with your slow motion explaining
Thank for this helpful information. I'm self educating on a number of different things,it's a crazy hobby that i have to challenge myself . Thanks again. Love peace and Happiness.
It's not a "crazy hobby", it's commonsense lmao
This is on point and very informative. Thank you!!
Thank you for sharing, I have one more skill, it's easy learning and useful in my work. Hope to see more tutorial in the future. Thanks again !!
Beginner friendly tutorial. Thank you
Thank I passed my exams because of you.👍🏽👍🏽
This is FANTASTIC This is gonna make my life so much easier you have no idea
Hi I require to make a maintenance form that would update my road tanker maintenance daily and item replace in stock card (ok different sheets - tanker repair record and stock card) Can that be done?
I give my thanks for creating this tutorial! I hope these helpful tips can be applied to today's Data Entry forms, as I am uncertain whether or not each job has specific requirements on how their want their forms filed.
This video is easy to follow..(most video they assumed all pc have the same spect)..short and precisely explained..thanks so much..
This is very easy to follow and very helpful!
Wizardry is afoot. Bravo, thank you so much.
Love your teaching method and voice.
I watch your tutorial one by one even the old ones, I like the way you teach, you speak clearly and zoom out what you are referring to, so I can see it clearly
Helpful and I learned something new 😮
It is very useful. Thank you! Can you we set auto format; for example, date, are there any ways that we can just click and it shows the calendar for us to chose the date?
That's quite awesome , making people life easier is gift and blessing, thanks alot
Thank you so much for your valuable knowledge and want to know more on MS Excel with MS Access for forms & database. This video of yours makes us feel easier on our work.👍😇
This is a great tutorial, very thorough and informative
Great video.
For my work, we create these forms and then print a screenshot of the form in the vertical view. Is there a way to print all of these forms at once, separately?
There's anywhere from 50-100 tabs we have to screenshot and print a week.
A big thank you to you for your very clear explanation in the video !
Thank you Sir, you made it easier for me and my work.
This has been helpful for me today. Thanks!
This is just....WOW no words... Thank You
Where have you been all my life!!! Some people making learning soooo easy!
This tutorial is very useful and helpful for some beginner like me thank you very much! more videos to watch❤
Thank you so much, your pattern of teaching makes it easier to understand. Thumbs up for you👍👍
Thank you so much for sharing this information, i was looking for this long time ago.
Thanks for the tutorial and bringing out functions excel has that make working on it a whole lot easier.
Thanks so much for this teaching, I learnd it, it was all very understood to me. Top
I love your channel, it helps a lot newbies like me. Thank u so much
Excellent tutorial for a novice.Thank you!
This video is very informative. Thanks for sharing your knowledge.
Quick, easy & useful tutorial. Thanks for sharing.
Thank you. I easily made it. Good job!
Your brilliant. the best tutorial i've encountered in youtube. thank you man.
Often we think that since we've used Excel for decades we know everything. But, alas, it is not true! Too often we have compartmentalized what we are experts in based on the small percentage of Excel functions we use daily.
Thanks for helping me expand my knowledge!
Very smooth and easy to learn guide, Thank you sir.
This is great, thank you for making this so easy to follow.
Very simple and clear to understand. Thankyou.
Thank you! This is very useful.
You have just saved my time!! Thank You!✊
i have been searching this formula on internet but i didnt get though i found your video its more satisfying me thanks alot sir...
perfect guide as always, thank you
Thank you for this video,,it can help a lot to those people who are just beginners in data encoding
AMAZING VIDEO! Thank you! Question? How can I keep a header, or title at the top of the data entry form?
Here's what I need. Everything that is in this video plus a print function for each completed form. Example: entering addresses into data base form then having the ability to print out an address lable with the form's information.
Ctl. P
Thank you!! This has been the best video to follow along to show this I’ve found!
Is there a way to take the information from the excel spreadsheet and automatically have the cells fill out a pdf adobe form or anything like that?
Thankyou so much
The forms were not appearing on my quick access toolbar...your video helped alot
Awesome videos! I want to watch them all. Great content and directions!
Absolutely love these videos. Can you please let me know is there any way to have a particular alpha numeric format and uppercase fields forcefully? For ex - if user enter "hello" and "hello123" in the field it should convert into "HELLO" and "HELLO 123" dynamically when the user press enter. Without using macros? Thanks
Excellent teaching!! Much appreciated👍
Thank you! Clear. Step-by-step. 👍
Hi, thanks for the GREAT video! We're on Excel for Mac version 16.64 and the "forms" button is not available anywhere, even when I search "All Commands". We have a standard Microsoft 365 subscription. Is this some type of upgraded feature? Thanks!
Unfortunately, it's not available in Excel for Mac. I have both regular Excel and Excel for Mac, and I can't use the forms feature in Excel for Mac either.
@@techteachersandstudents Thanks for the update. We solved this riddle last night after realizing this by installing Parallels on the Mac! Thanks again and keep up the great work!
So true,I got to quit my job😢
Mircosoft are such numpties.
Do the people that work there just constantly suck off gates's knob.
@@ContentMonsters Have Parallels, but I have to buy Office all over again to use the Win version. (As if I didn't despise Microsoft enough already...)
It's so helpful. You made my day so easier. Thank you very much...
Teaching method is very clear and well detailed. Great job! Excellent tutorial.. Question though, can i do this in google sheet? How? Or anyway to this in google sheet?
Your videos are terrific and extremely helpful. Thank you!
Glad you like them! Thank you for your kind Super Thanks gift. I'm sorry it took me so long to say "Thanks," but I want you to know I really appreciate it.
@@techteachersandstudents
It’s my pleasure!
May God continue to bless you wisdom and knowledge to share with more people
Thanks for such a great video! Could you recommend another one that integrates email addresses and allows sorting?
Awesome! I wish I knew this years back I could have saved my job. U have tot so well. Thanks.
Very helpful, can I use these forms to filter applications for position vacancies as well ?
A valuable reminder ooff what I needed to know, many thanks.
Here's what I need. Everything that is in this video plus a print function for each completed form. Example: entering addresses into data base form then having the ability to print out an address lable with the form's information.
Concise! If everyone teaches like this I don’t mind to be a programmer:)
This is very basic and has nothing to do with programming.
All steps are verry clear the way you explain i really appreciated
wow, that's a nifty tool I knew not about. thanks for the video, chap!
Thanks for teaching a super convenient skill !! One little question, is there anyone who knows the shortcut key of it?
Wow! you earned my like and subscribed with your informative advance excel!
Wow - you just simplified my whole life with data entry. Thank you so much.
You are the best teacher ever thank you for this tutorial
Easy to understand & easy to follow up. Thanks.
Bro you are lifesaver Tommorow is my practical of 40 marks now it is complete ❤😊
i have liked your lessons of creating data entry form in excel. thank you very much
Thank you very useful information, I am looking to work at home doing Data entry.