Creating Easy Data Entry Forms in Excel

Поділитися
Вставка
  • Опубліковано 7 лип 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...
  • Навчання та стиль

КОМЕНТАРІ • 851

  • @Thumper121234
    @Thumper121234 3 роки тому +92

    Thank you so much. You have a great teaching technique. I am 72 years old and learning so much from your videos.

  • @jalalkphilosophy
    @jalalkphilosophy Рік тому +29

    A lot of people are getting jobs without having much computer knowledge, and this is extremely helpful. Thank you!

  • @andreagilbey5100
    @andreagilbey5100 4 роки тому +52

    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.

  • @deniseparrott9678
    @deniseparrott9678 3 роки тому +57

    Thank you, this is the first Excel tutorial I was able to follow along with exactly, you saved me a ton of work!

  • @ContentMonsters
    @ContentMonsters Рік тому +11

    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  Рік тому +2

      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 Рік тому +3

      @@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 10 місяців тому

      Mircosoft are such numpties.
      Do the people that work there just constantly suck off gates's knob.

    • @jpdemer5
      @jpdemer5 2 місяці тому

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

  • @homesweethome3050
    @homesweethome3050 4 роки тому +127

    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 роки тому +2

      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

  • @ellamitchell1270
    @ellamitchell1270 4 роки тому +11

    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 роки тому +1

      Today good time with Google developers consolas foro profesional Android invermemt marketing foro bitcoin city club

  • @lindsayvu9210
    @lindsayvu9210 4 роки тому +40

    Easy to follow, precise & informative how-to. Thank you.

  • @carlitosgil4866
    @carlitosgil4866 2 роки тому +8

    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.

  • @irlsolidspace
    @irlsolidspace 2 роки тому +50

    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.

  • @dataoutsourcingindiausoffi2568
    @dataoutsourcingindiausoffi2568 2 роки тому +12

    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.

  • @MoviesRecap007
    @MoviesRecap007 3 роки тому +5

    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.

  • @wandagreer9144
    @wandagreer9144 2 роки тому +3

    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.

  • @Longbow06
    @Longbow06 Рік тому +3

    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 роки тому +2

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

  • @icu8202
    @icu8202 4 роки тому +14

    I love his teaching. Thank you for sharing your knowledge. New Patreon member!

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

  • @RJSAMCRO
    @RJSAMCRO 4 роки тому +40

    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?

  • @franneptune8141
    @franneptune8141 3 роки тому +1

    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

  • @Raha-fy1vm
    @Raha-fy1vm 4 роки тому +5

    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.

  • @Mrs.Melanated
    @Mrs.Melanated 4 роки тому +11

    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

  • @khadijatadeiza3711
    @khadijatadeiza3711 3 роки тому +2

    Thank you so much, your tutorials have been valuable.Keep it up👍

  • @vijivijayaraghavan
    @vijivijayaraghavan 4 роки тому +2

    This is awesome to get large data accurately filed in ! Thanks a Ton

  • @dishapatel4633
    @dishapatel4633 3 роки тому +11

    I loved it. It was so easy to understand and very informative as well.

  • @jonestasha901
    @jonestasha901 3 роки тому +5

    This is on point and very informative. Thank you!!

  • @janinakiessling3615
    @janinakiessling3615 3 роки тому

    This is the most valuable video about data entry on the platform. Thank you so much!

  • @jameskyagaba5817
    @jameskyagaba5817 4 роки тому +1

    Plain, precise and audible thanks.

  • @samsonadeyanju9194
    @samsonadeyanju9194 3 роки тому

    Absolutely helpful. You're good teacher to the core

  • @davidrobins4025
    @davidrobins4025 4 роки тому +1

    This is a very useful tool. THANK YOU for showing me how to accomplish this task.

  • @ehab2601
    @ehab2601 Рік тому +1

    That's exactly what I was looking for. The video is directive, simple to understand. And to the point 👉.... good job

  • @violafrancis6992
    @violafrancis6992 3 роки тому +2

    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.

  • @cawkekaynaanmoha4354
    @cawkekaynaanmoha4354 4 роки тому

    Thanks for the helpful tutorial , i am really delighted with your slow motion explaining

  • @edlibretv
    @edlibretv 2 роки тому

    This is one of the best tutorials on ms excel i've seen in UA-cam. Thank you very much for helping us learned more about excel.

  • @nicolecreech3260
    @nicolecreech3260 4 роки тому

    This is very easy to follow and very helpful!

  • @1SGPARKER
    @1SGPARKER Рік тому +4

    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!

  • @tammyjacobs6420
    @tammyjacobs6420 3 роки тому +2

    This is a great tutorial, very thorough and informative

  • @lexminikins
    @lexminikins 3 роки тому

    This has been helpful for me today. Thanks!

  • @henrywoo1668
    @henrywoo1668 4 роки тому

    A big thank you to you for your very clear explanation in the video !

  • @user-gf6sj4eg5n
    @user-gf6sj4eg5n 4 роки тому +2

    Thank you! This is very useful.

  • @markobabic9415
    @markobabic9415 4 роки тому +1

    This is just....WOW no words... Thank You

  • @woosheroes494
    @woosheroes494 8 місяців тому

    Wizardry is afoot. Bravo, thank you so much.
    Love your teaching method and voice.

  • @mohammedalghaili1129
    @mohammedalghaili1129 3 роки тому

    Thank you so much for sharing this information, i was looking for this long time ago.

  • @ernicabrillas
    @ernicabrillas 4 роки тому

    Thank you. I easily made it. Good job!

  • @watchingyou5003
    @watchingyou5003 4 роки тому +12

    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.

  • @Ladyhotfire78
    @Ladyhotfire78 Рік тому

    Awesome videos! I want to watch them all. Great content and directions!

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

  • @manjukodwaney373
    @manjukodwaney373 3 роки тому

    Excellent teaching!! Much appreciated👍

  • @FaysalEasyExcel
    @FaysalEasyExcel 4 роки тому

    Very simple and clear to understand. Thankyou.

  • @piefacegamer4570
    @piefacegamer4570 4 роки тому +6

    Thank I passed my exams because of you.👍🏽👍🏽

  • @puishanng4445
    @puishanng4445 4 роки тому +3

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

  • @bejai1962
    @bejai1962 3 роки тому +1

    Where have you been all my life!!! Some people making learning soooo easy!

  • @vincentchidiebere1652
    @vincentchidiebere1652 4 роки тому +1

    Thank you Sir, you made it easier for me and my work.

  • @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.👍😇

  • @cariestabile9802
    @cariestabile9802 3 роки тому

    Great job! Easy to follow!

  • @jacintaladar6534
    @jacintaladar6534 3 роки тому

    perfect guide as always, thank you

  • @somitmat3177
    @somitmat3177 4 роки тому +6

    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?

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

  • @bill7481
    @bill7481 3 роки тому

    Thank you! Clear. Step-by-step. 👍

  • @flavorfulpalate-wk
    @flavorfulpalate-wk 2 роки тому +1

    Quick, easy & useful tutorial. Thanks for sharing.

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

  • @Naturally.endowed
    @Naturally.endowed Рік тому

    Thank you so much, your pattern of teaching makes it easier to understand. Thumbs up for you👍👍

  • @emadali4833
    @emadali4833 4 роки тому

    That's quite awesome , making people life easier is gift and blessing, thanks alot

  • @khawajaaamir1677
    @khawajaaamir1677 4 роки тому

    This video is very informative. Thanks for sharing your knowledge.

  • @ducttapegarage2571
    @ducttapegarage2571 3 роки тому +34

    Concise! If everyone teaches like this I don’t mind to be a programmer:)

    • @theonef570
      @theonef570 2 роки тому +3

      This is very basic and has nothing to do with programming.

  • @epiff7921
    @epiff7921 3 роки тому

    Thanks so much for this teaching, I learnd it, it was all very understood to me. Top

  • @marceljunioregondi5594
    @marceljunioregondi5594 2 роки тому

    Thanks for the tutorial and bringing out functions excel has that make working on it a whole lot easier.

  • @makingmoves6816
    @makingmoves6816 2 роки тому

    Great information. Thanks!

  • @brofisherman
    @brofisherman Рік тому +1

    I love your channel, it helps a lot newbies like me. Thank u so much

  • @julianzacconievas
    @julianzacconievas 4 роки тому

    Great stuff! Thank you!

  • @user-jd1zi4cr6t
    @user-jd1zi4cr6t 8 місяців тому

    Thank you so much for your teachings🙏👏

  • @c_6951
    @c_6951 3 роки тому

    Clear and easy to follow. Thank you

  • @callmemoe14
    @callmemoe14 2 роки тому

    Very smooth and easy to learn guide, Thank you sir.

  • @coffeeafficionado5726
    @coffeeafficionado5726 2 роки тому

    Thank you. It helps a lot!

  • @christellelafrance3706
    @christellelafrance3706 2 роки тому

    Thank You. It was very helpful.

  • @Kings_New_Clothese
    @Kings_New_Clothese 3 роки тому +1

    A valuable reminder ooff what I needed to know, many thanks.

    • @epiff7921
      @epiff7921 3 роки тому +1

      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.

  • @norshamiemie8587
    @norshamiemie8587 2 роки тому

    Easy to understand & easy to follow up. Thanks.

  • @MyMomma2.0
    @MyMomma2.0 3 роки тому +3

    You have just saved my time!! Thank You!✊

  • @MikeRoeser
    @MikeRoeser 2 роки тому

    Exactly what I needed! Thanks!

  • @NahedKRott
    @NahedKRott Рік тому +6

    Your videos are terrific and extremely helpful. Thank you!

    • @techteachersandstudents
      @techteachersandstudents  Рік тому +1

      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 Рік тому

      @@techteachersandstudents
      It’s my pleasure!

  • @1975ortega
    @1975ortega Рік тому

    Thank you so much for this tutorial. Very useful!

  • @lynnespringer6524
    @lynnespringer6524 2 роки тому

    Excellent tutorial for a novice.Thank you!

  • @alfredcheng5739
    @alfredcheng5739 4 роки тому

    Thank you for your teaching sir!

  • @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❤

  • @cutefunnymoments9459
    @cutefunnymoments9459 3 роки тому

    Wow! you earned my like and subscribed with your informative advance excel!

  • @QueenofCocktailsStacyGarrett
    @QueenofCocktailsStacyGarrett 4 роки тому +2

    This is great, thank you for making this so easy to follow.

  • @belledenuitflower4381
    @belledenuitflower4381 2 роки тому

    Thanks, it's just like magic !!

  • @dennismagbuhos2469
    @dennismagbuhos2469 3 роки тому

    Your brilliant. the best tutorial i've encountered in youtube. thank you man.

  • @niamulbary8162
    @niamulbary8162 3 місяці тому

    Excellent Job!

  • @lawuyfamily7666
    @lawuyfamily7666 2 роки тому

    thank you so much. you explain it well.

  • @TT-dy9qp
    @TT-dy9qp Рік тому +1

    Easy understanding Thanks!

  • @ShivaganeshKota4
    @ShivaganeshKota4 2 роки тому

    It's so helpful. You made my day so easier. Thank you very much...

  • @tubetubepleasure
    @tubetubepleasure Рік тому +1

    wonderful tutorial. thank you

  • @tanisheamiller921
    @tanisheamiller921 2 роки тому

    This is awesome, Thank you.

  • @brittni9305
    @brittni9305 3 роки тому

    This was super helpful!!!! Thank you

  • @riturani1180
    @riturani1180 Рік тому

    Thanks for this video… liked the way explain things 😊

  • @gethaanjali3929
    @gethaanjali3929 Рік тому

    Thank you so much, this helped me a lot

  • @bappidruti1948
    @bappidruti1948 2 роки тому

    Thanks a lot mate. It's working. God bless you 🙏🙏🙂

  • @lsamlee9044
    @lsamlee9044 2 роки тому

    This is really amazing.... Thank you

  • @wandeesthoughts
    @wandeesthoughts Рік тому

    This was so helpful thank you for sharing