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.
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!
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.
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.
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
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.
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
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.
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.
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.
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
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.
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?
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.
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.
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!
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.
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!!
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?
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
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 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.
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.
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.
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?
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.
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!
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
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
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!
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
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
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!
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
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 :)
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
Bro you are lifesaver Tommorow is my practical of 40 marks now it is complete ❤😊
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.
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
i have been searching this formula on internet but i didnt get though i found your video its more satisfying me thanks alot sir...
The way you teach people is so nice thank you , now I know Excel
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.
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
Where have you been all my life!!! Some people making learning soooo easy!
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
Wizardry is afoot. Bravo, thank you so much.
Love your teaching method and voice.
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 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 video is easy to follow..(most video they assumed all pc have the same spect)..short and precisely explained..thanks so much..
I love your channel, it helps a lot newbies like me. Thank u so much
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.
That's exactly what I was looking for. The video is directive, simple to understand. And to the point 👉.... good job
Thanks for this..I am a begginer in using excel..this will help me a lot
Thank you for this video,,it can help a lot to those people who are just beginners in data encoding
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
Very Very Helpful ... Thaaanx a lot .
Thank you so much, your pattern of teaching makes it easier to understand. Thumbs up for you👍👍
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.
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!
Thankyou so much
The forms were not appearing on my quick access toolbar...your video helped alot
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.
Helpful and I learned something new 😮
Thank I passed my exams because of you.👍🏽👍🏽
This is extremely helpful. Simple and we'll explained, thank you for this wonderful video
You explained it so well ... I wish I could meet you personally and say thankyou.
Thank you so much, was very much useful
Easy to follow, precise & informative how-to. Thank you.
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!!
Your brilliant. the best tutorial i've encountered in youtube. thank you man.
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.
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?
The way you explain its just awesome
All steps are verry clear the way you explain i really appreciated
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
Thanks so much for this--straight to the point. learnt much in a very short time🎉-
It's so helpful. You made my day so easier. Thank you very much...
i have liked your lessons of creating data entry form in excel. thank you very much
so many years using excel as a student and such a useful tool hasn't been introduced to me
Beginner friendly tutorial. Thank you
wonderful tutorial. thank you
I will follow this guy.......so easy to understand.
Awesome! I wish I knew this years back I could have saved my job. U have tot so well. Thanks.
very good presentation...... new learning how to use the data entry form..... thanks
Wow - you just simplified my whole life with data entry. Thank you so much.
You are the best to explained.. I learn a lot from you
Thank you very useful information, I am looking to work at home doing Data entry.
you explain thing in a very simple way .thank for giving me good skill.
Thank You for the tutorial...... very nicely explained and to the point..........
Extremely clear and thorough explanation!! Thanks for your efforts.
That's quite awesome , making people life easier is gift and blessing, thanks alot
This is the most valuable video about data entry on the platform. Thank you so much!
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.👍😇
Thanks very much for this tutorial. 💯👍
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.
This is a very useful tool. THANK YOU for showing me how to accomplish this task.
Quick, easy & useful tutorial. Thanks for sharing.
You are the best teacher ever thank you for this tutorial
Easy understanding Thanks!
Thank you for bringing it down to my level…
It is really helpful thank you 🎉
Awesome - So well presented . Is it possible to have "drop down boxes" in the form
Hi Franco, Did you ever get an answer to this ?
THANK YOU SO MUCH!!! GOD BLESS YOUR FAMILY SIR!
This is awesome to get large data accurately filed in ! Thanks a Ton
As a learner very helpful awesome.
Thanks for the tutorial and bringing out functions excel has that make working on it a whole lot easier.
thanks you so much for great and useful tutorials
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.
Compliment to you dude I like how you have explained it now if I may ask how to do data entry ?
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.
Amazing, I have recommended your videos so many times!
Wow, thank you! I'm glad you like my videos, and thanks for sharing them.
Easy to learn and understand the concept very clearly
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
Excellent tutorial for a novice.Thank you!
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.
Thank you for your tips and I have found it very useful.
Thanks for such a great video! Could you recommend another one that integrates email addresses and allows sorting?
This is SOOOOOOO helpful. Thanks a million!
You're very welcome!
Amazing presentation!!
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?
Thanks a lot mate. It's working. God bless you 🙏🙏🙂
A big thank you to you for your very clear explanation in the video !
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.
👍 simple and easy to understand teaching.
Amazing tutorial . Thanks :)