Creating Easy Data Entry Forms in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ก.พ. 2025

ความคิดเห็น • 892

  • @Thumper121234
    @Thumper121234 3 ปีที่แล้ว +116

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

  • @jkphilosophy101
    @jkphilosophy101 ปีที่แล้ว +41

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

  • @NahedKRott
    @NahedKRott ปีที่แล้ว +8

    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!

  • @dataoutsourcingindiausoffi2568
    @dataoutsourcingindiausoffi2568 3 ปีที่แล้ว +14

    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.

  • @homesweethome3050
    @homesweethome3050 5 ปีที่แล้ว +132

    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 ปีที่แล้ว +1

      He is just a good teacher, and patient

  • @1SGPARKER
    @1SGPARKER 2 ปีที่แล้ว +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!

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

  • @IshanviRathi
    @IshanviRathi ปีที่แล้ว

    Bro you are lifesaver Tommorow is my practical of 40 marks now it is complete ❤😊

  • @wazmink2459
    @wazmink2459 2 ปีที่แล้ว

    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

  • @bejai1962
    @bejai1962 3 ปีที่แล้ว +1

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

  • @andreagilbey5100
    @andreagilbey5100 4 ปีที่แล้ว +53

    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.

  • @aulivn4jc
    @aulivn4jc หลายเดือนก่อน

    Trying to prepare for an excell test for a job interview. I have never used excell before so i hope what i learned here is helpful for the test. 🤞

  • @priyankakukreti6404
    @priyankakukreti6404 3 ปีที่แล้ว

    i have been searching this formula on internet but i didnt get though i found your video its more satisfying me thanks alot sir...

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

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

  • @thushnipillay8462
    @thushnipillay8462 4 หลายเดือนก่อน

    Yes it is me again...just watched this video now...where have you been! This was so helpful Technology for Teachers and Students now I really can capture my payments for carefully. I am really grateful for your informative tutorials in Excel..pity i didnt come across it earlier in my career..no matter my appreciation nonetheless❤ Big up to the tutor. Your voice alone is encouragement enough to keep us captivated and readt to learn

  • @ellamitchell1270
    @ellamitchell1270 4 ปีที่แล้ว +12

    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

  • @irlsolidspace
    @irlsolidspace 2 ปีที่แล้ว +52

    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.

  • @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 4 ปีที่แล้ว

      It's not a "crazy hobby", it's commonsense lmao

  • @violafrancis6992
    @violafrancis6992 3 ปีที่แล้ว +2

    The way you teach people is so nice thank you , now I know Excel

  • @jaytamayo4694
    @jaytamayo4694 3 ปีที่แล้ว

    This was never taught in my first job or any her job. In that first job I made many mistakes, not knowing this adds to that. ONLY IF I KNEW this work would be easier. Cuz we enter so many data for that is for insurance companies' insurances. In school this is not part of the curriculum or subject. They better have kinda intense teaching for the students and/or in the company. Yes there are specific features taught but not like this. We could learn it in other office or job but if we learn it earlier work would be easier too. Thank you for this lesson! I actually was searching for video like this.

  • @marsmanherrera4264
    @marsmanherrera4264 3 ปีที่แล้ว

    May God continue to bless you wisdom and knowledge to share with more people

  • @brofisherman
    @brofisherman ปีที่แล้ว +1

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

  • @RJSAMCRO
    @RJSAMCRO 4 ปีที่แล้ว +40

    This is FANTASTIC This is gonna make my life so much easier you have no idea

    • @weimingw3056
      @weimingw3056 3 ปีที่แล้ว

      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?

  • @ksramani8712
    @ksramani8712 4 ปีที่แล้ว

    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

  • @woosheroes494
    @woosheroes494 ปีที่แล้ว

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

  • @racquelebro607
    @racquelebro607 3 ปีที่แล้ว

    Thanks for this..I am a begginer in using excel..this will help me a lot

  • @jessicaperez7956
    @jessicaperez7956 3 ปีที่แล้ว

    Thank you for this video,,it can help a lot to those people who are just beginners in data encoding

  • @FireJach
    @FireJach 2 ปีที่แล้ว

    so many years using excel as a student and such a useful tool hasn't been introduced to me

  • @mandatemandate1591
    @mandatemandate1591 ปีที่แล้ว +1

    Very Very Helpful ... Thaaanx a lot .

  • @FukohZachel-vb8hu
    @FukohZachel-vb8hu ปีที่แล้ว +1

    Hello am grateful to have watched this video.
    Please i wish to ask, how can I keep multiple heading in a table form while scrolling the list of data in the cell while the heading is freezes

  • @ExplorewithNaeem786
    @ExplorewithNaeem786 2 ปีที่แล้ว

    The way you explain its just awesome

  • @edlibretv
    @edlibretv 3 ปีที่แล้ว

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

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

  • @sureshnimonkar9593
    @sureshnimonkar9593 4 หลายเดือนก่อน

    You explained it so well ... I wish I could meet you personally and say thankyou.

  • @marzieanaabrahman7463
    @marzieanaabrahman7463 4 ปีที่แล้ว

    This video is easy to follow..(most video they assumed all pc have the same spect)..short and precisely explained..thanks so much..

  • @joeym.3555
    @joeym.3555 ปีที่แล้ว +1

    Helpful and I learned something new 😮

  • @roberttigges5264
    @roberttigges5264 2 ปีที่แล้ว

    I will follow this guy.......so easy to understand.

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

  • @thecrazymico
    @thecrazymico ปีที่แล้ว

    Beginner friendly tutorial. Thank you

  • @ehab2601
    @ehab2601 ปีที่แล้ว +1

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

  • @theartisticbrushes6055
    @theartisticbrushes6055 ปีที่แล้ว

    Thankyou so much
    The forms were not appearing on my quick access toolbar...your video helped alot

  • @RengiEbon
    @RengiEbon 6 หลายเดือนก่อน

    This is extremely helpful. Simple and we'll explained, thank you for this wonderful video

  • @boskaliscanada-media793
    @boskaliscanada-media793 2 ปีที่แล้ว

    Amazing, I have recommended your videos so many times!

    • @techteachersandstudents
      @techteachersandstudents  2 ปีที่แล้ว

      Wow, thank you! I'm glad you like my videos, and thanks for sharing them.

  • @abdikadirabdi6830
    @abdikadirabdi6830 3 ปีที่แล้ว

    you explain thing in a very simple way .thank for giving me good skill.

  • @Longbow06
    @Longbow06 2 ปีที่แล้ว +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!

  • @davidliz315
    @davidliz315 ปีที่แล้ว +1

    Thank you so much, was very much useful

  • @junrose54
    @junrose54 4 ปีที่แล้ว

    very good presentation...... new learning how to use the data entry form..... thanks

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

  • @dennismagbuhos2469
    @dennismagbuhos2469 3 ปีที่แล้ว

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

  • @ShivaganeshKota4
    @ShivaganeshKota4 3 ปีที่แล้ว

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

  • @yasminel-alfy5076
    @yasminel-alfy5076 4 ปีที่แล้ว

    All steps are verry clear the way you explain i really appreciated

  • @TheTrueTaleChronicles
    @TheTrueTaleChronicles 2 ปีที่แล้ว

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

  • @mukizagodfreyvictor8769
    @mukizagodfreyvictor8769 2 ปีที่แล้ว

    i have liked your lessons of creating data entry form in excel. thank you very much

  • @yongamaquluba5346
    @yongamaquluba5346 2 ปีที่แล้ว

    Compliment to you dude I like how you have explained it now if I may ask how to do data entry ?

  • @joycesmock-vv7ym
    @joycesmock-vv7ym ปีที่แล้ว

    Thank you very useful information, I am looking to work at home doing Data entry.

  • @jeffreymaurer
    @jeffreymaurer ปีที่แล้ว +1

    Thanks for such a great video! Could you recommend another one that integrates email addresses and allows sorting?

  • @charlestoneoyoo
    @charlestoneoyoo 3 หลายเดือนก่อน

    Thanks so much for this--straight to the point. learnt much in a very short time🎉-

  • @joannahatfield4087
    @joannahatfield4087 3 ปีที่แล้ว

    Thank you for bringing it down to my level…

  • @radhekrsna007
    @radhekrsna007 2 ปีที่แล้ว +1

    Thanks for sharing this. Is it possible to have drop down selection in any of the fields , for example I want to select from predefine the department list from the drop down list to avoid spelling mistakes and to keep uniformity.

  • @armyjoypadua2411
    @armyjoypadua2411 3 ปีที่แล้ว

    You are the best to explained.. I learn a lot from you

  • @flavorfulpalate-wk
    @flavorfulpalate-wk 2 ปีที่แล้ว +1

    Quick, easy & useful tutorial. Thanks for sharing.

  • @crisreelse-dayrides8861
    @crisreelse-dayrides8861 3 หลายเดือนก่อน

    thanks you so much for great and useful tutorials

  • @mohammednoormepurath2929
    @mohammednoormepurath2929 3 ปีที่แล้ว

    Thank You for the tutorial...... very nicely explained and to the point..........

  • @tubetubepleasure
    @tubetubepleasure ปีที่แล้ว +1

    wonderful tutorial. thank you

  • @leelopez160
    @leelopez160 2 ปีที่แล้ว +1

    Thanks very much for this tutorial. 💯👍

  • @jong-jongspeaks4224
    @jong-jongspeaks4224 2 ปีที่แล้ว

    THANK YOU SO MUCH!!! GOD BLESS YOUR FAMILY SIR!

  • @JoyfulArtisticAdventures
    @JoyfulArtisticAdventures 3 ปีที่แล้ว

    Awesome! I wish I knew this years back I could have saved my job. U have tot so well. Thanks.

  • @ducttapegarage2571
    @ducttapegarage2571 4 ปีที่แล้ว +34

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

    • @theonef570
      @theonef570 3 ปีที่แล้ว +3

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

  • @fletamason2509
    @fletamason2509 3 ปีที่แล้ว +1

    As a learner very helpful awesome.

  • @RashadSims-bh3zz
    @RashadSims-bh3zz 7 หลายเดือนก่อน

    Thank u I did training for this but it was more sorting out documents putting it in the person mailbox if that makes sense

  • @piefacegamer4570
    @piefacegamer4570 5 ปีที่แล้ว +6

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

  • @jessicamoscho9315
    @jessicamoscho9315 ปีที่แล้ว

    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?

  • @WCoombes
    @WCoombes 5 วันที่ผ่านมา

    Thank you so much - this has helped me so much

  • @wandagreer9144
    @wandagreer9144 3 ปีที่แล้ว +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.

  • @janeahm3698
    @janeahm3698 2 ปีที่แล้ว

    Thank you for sharing. Awesome and helpful video.

  • @orthocare_poonoor
    @orthocare_poonoor 2 ปีที่แล้ว

    Thank you and this is very much helpful for me. May I know if I can take prints directly from this form.

  • @ssbb9636
    @ssbb9636 ปีที่แล้ว +1

    Amazing presentation!!

  • @ShahzadAhmad-nb6si
    @ShahzadAhmad-nb6si 6 หลายเดือนก่อน +1

    You don't need table for doing this if your data is already organized. Just select anywhere in data and click form and it works.

  • @Dhageykerow
    @Dhageykerow 2 ปีที่แล้ว

    Thanks a lot for sharing your knowledge with us.

  • @TT-dy9qp
    @TT-dy9qp ปีที่แล้ว +1

    Easy understanding Thanks!

  • @janinakiessling3615
    @janinakiessling3615 4 ปีที่แล้ว

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

  • @francorenda8700
    @francorenda8700 3 ปีที่แล้ว +3

    Awesome - So well presented . Is it possible to have "drop down boxes" in the form

  • @dizzylasalsera
    @dizzylasalsera 3 ปีที่แล้ว +3

    This is SOOOOOOO helpful. Thanks a million!

  • @lakshmi5538
    @lakshmi5538 2 ปีที่แล้ว

    Extremely clear and thorough explanation!! Thanks for your efforts.

  • @dianantumi2373
    @dianantumi2373 ปีที่แล้ว

    Great tutorial. How do i decide what headers to be displayed on the form provided that I have a lot of headers.

  • @lindsayvu9210
    @lindsayvu9210 5 ปีที่แล้ว +40

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

  • @1234dlkf
    @1234dlkf 3 ปีที่แล้ว

    Thank you for your tips and I have found it very useful.

  • @AustinIC
    @AustinIC ปีที่แล้ว

    Thank you so much Sir.
    You helped me big time

  • @lynng3421
    @lynng3421 2 ปีที่แล้ว

    I create weekly and monthly newsletter. I want to keep formatting in each area, ability to paste in data, but maintain current font, spacing and size.
    Example: think church bulletin.

  • @jhengutual425
    @jhengutual425 ปีที่แล้ว

    Thank for this. It solves my problem

  • @fahadmaqboolsoomro
    @fahadmaqboolsoomro 3 ปีที่แล้ว

    This helped me alot
    Will you please tell me that is there a way to create 2 forms in on sheet?
    Thanks

  • @amrahabbasov5267
    @amrahabbasov5267 2 ปีที่แล้ว

    The very informative lesson, thanks a bunch sir

  • @cathryn4602
    @cathryn4602 3 ปีที่แล้ว +2

    Wow - you just simplified my whole life with data entry. Thank you so much.

  • @lincolns4379
    @lincolns4379 2 ปีที่แล้ว

    thank you. helpful video. can we add a picture against each record? is it possible?

  • @dipakkumarchatterjee8128
    @dipakkumarchatterjee8128 2 ปีที่แล้ว

    Nice explanation very helpful video thanks for sharing

  • @patelarvind005
    @patelarvind005 3 หลายเดือนก่อน

    Hi you have been teaching very well
    I live it.
    I got one question is.
    If i wants to add entry in for exp. 550 number’s raw. Not from beginning of raw like 1,2,3 in which sheets already has data on it.

  • @l.tmichael5706
    @l.tmichael5706 3 ปีที่แล้ว +1

    Helpful video. Does anyone know when you click 'form' button and 'new record' - can you change a setting so that new line goes straight to the top??

  • @cruzinsweetsntreats
    @cruzinsweetsntreats 2 ปีที่แล้ว

    This works fine for desktop, but not mobile (Android). The nice feature of mobile in particular, is that the cell reference position is saved, for when reopening the file. So if you are 400+ Rows down, 5 Columns over, you start there. Example E425 vs A1, standard default position.
    So for entry such as this, then being on desktop is useful, whereas mobile to add, or adjust on the go, is a bit trickier, and a bit slower, yet can be done. I have a daily travel workbook as an Independent Contractor for food delivery, so I have learned that over the past 2 years.

  • @george87235
    @george87235 2 ปีที่แล้ว

    awesome thank you very much, but can i allow access to the form for other people?