Creating Easy Data Entry Forms in Excel

  Рет қаралды 2,972,501

Technology for Teachers and Students

Technology for Teachers and Students

Күн бұрын

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

Пікірлер: 849
@Thumper121234
@Thumper121234 3 жыл бұрын
Thank you so much. You have a great teaching technique. I am 72 years old and learning so much from your videos.
@pronoob6587
@pronoob6587 Жыл бұрын
Now ur 73 years old
@helpmereach1ksubswithoutan171
@helpmereach1ksubswithoutan171 Жыл бұрын
Now you're 74, are you doing alright?
@bryanimam
@bryanimam Жыл бұрын
74
@Larahhhx
@Larahhhx Жыл бұрын
God bless you Barry❤️
@arnabsaha9219
@arnabsaha9219 Жыл бұрын
Now 75
@jalalkphilosophy
@jalalkphilosophy Жыл бұрын
A lot of people are getting jobs without having much computer knowledge, and this is extremely helpful. Thank you!
@homesweethome3050
@homesweethome3050 4 жыл бұрын
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.
@vickijohnson3203
@vickijohnson3203 3 жыл бұрын
AND... your cursor is moved in a calm logical way. When that cursor moves around like an italian womans hands... it is greatly distracting!
@AustinIC
@AustinIC 7 ай бұрын
He is just a good teacher, and patient
@andreagilbey5100
@andreagilbey5100 4 жыл бұрын
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.
@georgeaboh
@georgeaboh 2 жыл бұрын
Great :)
@deniseparrott9678
@deniseparrott9678 3 жыл бұрын
Thank you, this is the first Excel tutorial I was able to follow along with exactly, you saved me a ton of work!
@techteachersandstudents
@techteachersandstudents 3 жыл бұрын
Glad it helped!
@ellamitchell1270
@ellamitchell1270 4 жыл бұрын
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.
@raulrivero7097
@raulrivero7097 4 жыл бұрын
Today good time with Google developers consolas foro profesional Android invermemt marketing foro bitcoin city club
@carlitosgil4866
@carlitosgil4866 Жыл бұрын
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.
@tubetubepleasure
@tubetubepleasure Жыл бұрын
wonderful tutorial. thank you
@mandatemandate1591
@mandatemandate1591 Жыл бұрын
Very Very Helpful ... Thaaanx a lot .
@lindsayvu9210
@lindsayvu9210 4 жыл бұрын
Easy to follow, precise & informative how-to. Thank you.
@dataoutsourcingindiausoffi2568
@dataoutsourcingindiausoffi2568 2 жыл бұрын
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.
@densadiasa3489
@densadiasa3489 2 жыл бұрын
Wow nice learning
@ContentMonsters
@ContentMonsters Жыл бұрын
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!
@techteachersandstudents
@techteachersandstudents Жыл бұрын
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.
@ContentMonsters
@ContentMonsters Жыл бұрын
@@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!
@YHWH69
@YHWH69 Жыл бұрын
So true,I got to quit my job😢
@NZTechArc
@NZTechArc 9 ай бұрын
Mircosoft are such numpties. Do the people that work there just constantly suck off gates's knob.
@jpdemer5
@jpdemer5 Ай бұрын
@@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...)
@MoviesRecap007
@MoviesRecap007 3 жыл бұрын
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.
@Longbow06
@Longbow06 Жыл бұрын
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!
@princekollie4807
@princekollie4807 4 жыл бұрын
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!!
@jameskyagaba5817
@jameskyagaba5817 4 жыл бұрын
Plain, precise and audible thanks.
@franneptune8141
@franneptune8141 3 жыл бұрын
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
@janinakiessling3615
@janinakiessling3615 3 жыл бұрын
This is the most valuable video about data entry on the platform. Thank you so much!
@joeym.3555
@joeym.3555 Жыл бұрын
Helpful and I learned something new 😮
@vijivijayaraghavan
@vijivijayaraghavan 4 жыл бұрын
This is awesome to get large data accurately filed in ! Thanks a Ton
@violafrancis6992
@violafrancis6992 3 жыл бұрын
The way you teach people is so nice thank you , now I know Excel
@lakshmi5538
@lakshmi5538 Жыл бұрын
Extremely clear and thorough explanation!! Thanks for your efforts.
@davidrobins4025
@davidrobins4025 4 жыл бұрын
This is a very useful tool. THANK YOU for showing me how to accomplish this task.
@NahedKRott
@NahedKRott Жыл бұрын
Your videos are terrific and extremely helpful. Thank you!
@techteachersandstudents
@techteachersandstudents 11 ай бұрын
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.
@nahedrott3215
@nahedrott3215 11 ай бұрын
@@techteachersandstudents It’s my pleasure!
@samsonadeyanju9194
@samsonadeyanju9194 3 жыл бұрын
Absolutely helpful. You're good teacher to the core
@icu8202
@icu8202 4 жыл бұрын
I love his teaching. Thank you for sharing your knowledge. New Patreon member!
@ehab2601
@ehab2601 Жыл бұрын
That's exactly what I was looking for. The video is directive, simple to understand. And to the point 👉.... good job
@Mrs.Melanated
@Mrs.Melanated 4 жыл бұрын
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.
@mansamusa6505
@mansamusa6505 3 жыл бұрын
It's not a "crazy hobby", it's commonsense lmao
@RJSAMCRO
@RJSAMCRO 4 жыл бұрын
This is FANTASTIC This is gonna make my life so much easier you have no idea
@weimingw3056
@weimingw3056 2 жыл бұрын
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?
@edlibretv
@edlibretv 2 жыл бұрын
This is one of the best tutorials on ms excel i've seen in KZbin. Thank you very much for helping us learned more about excel.
@ksramani8712
@ksramani8712 3 жыл бұрын
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
@jonestasha901
@jonestasha901 3 жыл бұрын
This is on point and very informative. Thank you!!
@khadijatadeiza3711
@khadijatadeiza3711 3 жыл бұрын
Thank you so much, your tutorials have been valuable.Keep it up👍
@cawkekaynaanmoha4354
@cawkekaynaanmoha4354 4 жыл бұрын
Thanks for the helpful tutorial , i am really delighted with your slow motion explaining
@dishapatel4633
@dishapatel4633 2 жыл бұрын
I loved it. It was so easy to understand and very informative as well.
@nicolecreech3260
@nicolecreech3260 4 жыл бұрын
This is very easy to follow and very helpful!
@irlsolidspace
@irlsolidspace 2 жыл бұрын
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.
@anitaabaraonye
@anitaabaraonye Жыл бұрын
Very true
@wandagreer9144
@wandagreer9144 2 жыл бұрын
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.
@markobabic9415
@markobabic9415 4 жыл бұрын
This is just....WOW no words... Thank You
@piefacegamer4570
@piefacegamer4570 4 жыл бұрын
Thank I passed my exams because of you.👍🏽👍🏽
@henrywoo1668
@henrywoo1668 3 жыл бұрын
A big thank you to you for your very clear explanation in the video !
@woosheroes494
@woosheroes494 7 ай бұрын
Wizardry is afoot. Bravo, thank you so much. Love your teaching method and voice.
@lexminikins
@lexminikins 3 жыл бұрын
This has been helpful for me today. Thanks!
@emadali4833
@emadali4833 4 жыл бұрын
That's quite awesome , making people life easier is gift and blessing, thanks alot
@brofisherman
@brofisherman Жыл бұрын
I love your channel, it helps a lot newbies like me. Thank u so much
@bejai1962
@bejai1962 2 жыл бұрын
Where have you been all my life!!! Some people making learning soooo easy!
@lynnespringer6524
@lynnespringer6524 2 жыл бұрын
Excellent tutorial for a novice.Thank you!
@Raha-fy1vm
@Raha-fy1vm 4 жыл бұрын
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.
@vincentchidiebere1652
@vincentchidiebere1652 4 жыл бұрын
Thank you Sir, you made it easier for me and my work.
@tammyjacobs6420
@tammyjacobs6420 3 жыл бұрын
This is a great tutorial, very thorough and informative
@wazmink2459
@wazmink2459 Жыл бұрын
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
@FaysalEasyExcel
@FaysalEasyExcel 4 жыл бұрын
Very simple and clear to understand. Thankyou.
@1SGPARKER
@1SGPARKER Жыл бұрын
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!
@marzieanaabrahman7463
@marzieanaabrahman7463 3 жыл бұрын
This video is easy to follow..(most video they assumed all pc have the same spect)..short and precisely explained..thanks so much..
@khawajaaamir1677
@khawajaaamir1677 3 жыл бұрын
This video is very informative. Thanks for sharing your knowledge.
@manjukodwaney373
@manjukodwaney373 3 жыл бұрын
Excellent teaching!! Much appreciated👍
@ernicabrillas
@ernicabrillas 4 жыл бұрын
Thank you. I easily made it. Good job!
@flavorfulpalate-wk
@flavorfulpalate-wk 2 жыл бұрын
Quick, easy & useful tutorial. Thanks for sharing.
@dennismagbuhos2469
@dennismagbuhos2469 3 жыл бұрын
Your brilliant. the best tutorial i've encountered in youtube. thank you man.
@callmemoe14
@callmemoe14 2 жыл бұрын
Very smooth and easy to learn guide, Thank you sir.
@jacintaladar6534
@jacintaladar6534 3 жыл бұрын
perfect guide as always, thank you
@Naturally.endowed
@Naturally.endowed Жыл бұрын
Thank you so much, your pattern of teaching makes it easier to understand. Thumbs up for you👍👍
@leelopez160
@leelopez160 Жыл бұрын
Thanks very much for this tutorial. 💯👍
@user-gf6sj4eg5n
@user-gf6sj4eg5n 4 жыл бұрын
Thank you! This is very useful.
@bill7481
@bill7481 3 жыл бұрын
Thank you! Clear. Step-by-step. 👍
@mohammedalghaili1129
@mohammedalghaili1129 3 жыл бұрын
Thank you so much for sharing this information, i was looking for this long time ago.
@thecrazymico
@thecrazymico 9 ай бұрын
Beginner friendly tutorial. Thank you
@c_6951
@c_6951 2 жыл бұрын
Clear and easy to follow. Thank you
@norshamiemie8587
@norshamiemie8587 2 жыл бұрын
Easy to understand & easy to follow up. Thanks.
@alfredcheng5739
@alfredcheng5739 4 жыл бұрын
Thank you for your teaching sir!
@epiff7921
@epiff7921 3 жыл бұрын
Thanks so much for this teaching, I learnd it, it was all very understood to me. Top
@ShivaganeshKota4
@ShivaganeshKota4 2 жыл бұрын
It's so helpful. You made my day so easier. Thank you very much...
@marceljunioregondi5594
@marceljunioregondi5594 2 жыл бұрын
Thanks for the tutorial and bringing out functions excel has that make working on it a whole lot easier.
@mskiara18
@mskiara18 Жыл бұрын
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.
@Ladyhotfire78
@Ladyhotfire78 Жыл бұрын
Awesome videos! I want to watch them all. Great content and directions!
@TT-dy9qp
@TT-dy9qp Жыл бұрын
Easy understanding Thanks!
@ducttapegarage2571
@ducttapegarage2571 3 жыл бұрын
Concise! If everyone teaches like this I don’t mind to be a programmer:)
@theonef570
@theonef570 2 жыл бұрын
This is very basic and has nothing to do with programming.
@balamuthu29
@balamuthu29 2 жыл бұрын
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.👍😇
@yasminel-alfy5076
@yasminel-alfy5076 4 жыл бұрын
All steps are verry clear the way you explain i really appreciated
@Kings_New_Clothese
@Kings_New_Clothese 3 жыл бұрын
A valuable reminder ooff what I needed to know, many thanks.
@epiff7921
@epiff7921 3 жыл бұрын
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.
@fannysalgaming1.079
@fannysalgaming1.079 2 жыл бұрын
This tutorial is very useful and helpful for some beginner like me thank you very much! more videos to watch❤
@puishanng4445
@puishanng4445 4 жыл бұрын
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 !!
@davidliz315
@davidliz315 Жыл бұрын
Thank you so much, was very much useful
@mohammednoormepurath2929
@mohammednoormepurath2929 2 жыл бұрын
Thank You for the tutorial...... very nicely explained and to the point..........
@1975ortega
@1975ortega Жыл бұрын
Thank you so much for this tutorial. Very useful!
@ExplorewithNaeem786
@ExplorewithNaeem786 Жыл бұрын
The way you explain its just awesome
@MyMomma2.0
@MyMomma2.0 3 жыл бұрын
You have just saved my time!! Thank You!✊
@mrs.e.carlton4810
@mrs.e.carlton4810 2 жыл бұрын
Starting a new job, & need to learn more about excel. You made it so easy to understand. I’ve never subscribed, but was glad to do it w/you so I can learn more. Thanks so much.
@cariestabile9802
@cariestabile9802 3 жыл бұрын
Great job! Easy to follow!
@spindeworld
@spindeworld Жыл бұрын
Amazing tutorial . Thanks :)
@marsmanherrera4264
@marsmanherrera4264 2 жыл бұрын
May God continue to bless you wisdom and knowledge to share with more people
@1234dlkf
@1234dlkf 3 жыл бұрын
Thank you for your tips and I have found it very useful.
@jong-jongspeaks4224
@jong-jongspeaks4224 2 жыл бұрын
THANK YOU SO MUCH!!! GOD BLESS YOUR FAMILY SIR!
@ssbb9636
@ssbb9636 Жыл бұрын
Amazing presentation!!
@QueenofCocktailsStacyGarrett
@QueenofCocktailsStacyGarrett 3 жыл бұрын
This is great, thank you for making this so easy to follow.
@MikeRoeser
@MikeRoeser 2 жыл бұрын
Exactly what I needed! Thanks!
@julianzacconievas
@julianzacconievas 4 жыл бұрын
Great stuff! Thank you!
@cutefunnymoments9459
@cutefunnymoments9459 3 жыл бұрын
Wow! you earned my like and subscribed with your informative advance excel!
@seanphang4477
@seanphang4477 3 жыл бұрын
👍 simple and easy to understand teaching.
@roberttigges5264
@roberttigges5264 Жыл бұрын
I will follow this guy.......so easy to understand.
Fixing Common Excel Errors - Part 1: DIV/0, N/A, & NAME?
14:27
Technology for Teachers and Students
Рет қаралды 124 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 268 М.
Each found a feeling.#Short #Officer Rabbit #angel
00:17
兔子警官
Рет қаралды 7 МЛН
Sprinting with More and More Money
00:29
MrBeast
Рет қаралды 174 МЛН
🍟Best French Fries Homemade #cooking #shorts
00:42
BANKII
Рет қаралды 59 МЛН
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 5 МЛН
Apa yg di Bawa Aa Randika & Rafie 😉 #anaksantri #anakpondok
0:53
Randika Rafie GAMING
Рет қаралды 8 М.
Most important tools in Excel -  Malayalam Tutorial
17:04
XL n CAD Malayalam
Рет қаралды 649 М.
Fully Automated Data Entry User Form in Excel - Step By Step Tutorial
35:41
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 181 М.
Advanced Excel - Creating Pivot Tables in Excel
13:11
Technology for Teachers and Students
Рет қаралды 2,4 МЛН
Google Sheets Form for Data Entry - Apps Script
59:47
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 324 М.
Try this 🤣  #funny #trending
0:14
Dung ABC
Рет қаралды 23 МЛН
Туристы и шведский стол
0:31
Сабина Хайрова
Рет қаралды 7 МЛН
Тайна голубого озера😱
0:35
FilmBytes
Рет қаралды 8 МЛН
Disposable large bath towel, easy to use for outdoor play
0:43