🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Great salute Sir ur my favorite teacher plz I would like to request you to teach VBA from begginer advance and expert plz am waiting that request from you I will appreciate if u do thanks
Dear Kevin, I constructed the MS Form questionnaire and it was fabulous. Now I can incorporate it into Excel. Your instructional videos are fantastic, so thank you.
Kevin! You have no idea how much this would've helped with a project I had a month ago ... there were soooo many columns (and rows)! Now I'm counting down until the next one haha. Thank you!
Wow, Kevin! How did you know I needed this? I was just trying to figure out how to create a form that would allow me to collect data without having to go through forms for some people who I can't access through my business account ...
Thanks for the video, in the past weeks I started feeling that you may have decide to reduce the uploading of new videos on UA-cam. But hey, thanks. Well, this video is also too amazing. I was knowing that how to use Macros but not knowing to edit it from VBA. Again, thanks. :-)
Thanks of this awesome tutorial 🙏, I was able to create a questionaire for my company without stress, linking it to excel and having not to stress myself going to check who responded or who did not on the form. Thanks once again Kevin
It would really be cool to have you as a friend in real life. Having all these knowledge is wayyyyy too awesome. I’ll keep learning from you. By the way you look good and I love cookies too😅 (sugar free cookies, if any😂)
I cannot get it to work on a larger sample. I get the headings for the data entry showing up inside the area where the data entry belongs. I tried replicating yours and it works fine. My column headings are not real long but still shows up in the areas where the data should be input or captured. Any thoughts on what I might be doing wrong?
How will you make a fixed formular in a particular cell for example a1*a2 and it'll auto multiple ones you enter values in both of them without having to type anything again
Dear Kevin, the data entry form in Excel allows up to 32 fields/columns or so, may you have a solution for more than 32 fields? I have around 200 fields... Thank you very much! Also, may you make a video about mirroring data to another excel workbook so that external users can view only while I still edit and the data are updated in both the original file and the mirrored file. Thanks a lot!
Hello Kevin....thank you for videos...I just had a query. I have been using the data form function and data validation and for some reason the validation seems to break the form entry. Upon clicking the retry or cancel button the deletes all other data entered into the form . It forces the user to reenter/ redo that same record
Call me stupid but I`m confused whether you have a real cookie company or not. Anyways can I use this form to create sheet music or tabs. If not would love to see that video. Enjoy your videos and have learned so much. OBS Studio has been great. I downloaded that cause you said you use it.
Hi Kevin Greetings from Malaysia! Am new to your channel.. Your tutorials are easy to follow and learn.. Tips that you shared are fantastic to know 👍😊 Thanks Kevin look forward to more of your tutorials 😊
After you search form and click it microsoft gives you a message saying "microsoft excel cannot determine which row in your list or selection contains column labels" what is the way to solve for this ?
It's evening here in the Philippines, so Good eve Mr. Stratvert. I would like to ask if how can I lock shapes in excel in a way that if I protect it with password, it cannot be moved by any user? Thank you 😁😁
What if I need a field to be the same in my form for several rows, and I don't want that field to type it over and over...I want to only change it when the data in that field will be changed. Example...I'm entering the inventory count for a number of bin locations...one bin location will have many, many items. I want to enter the bin location once, then just type Items and quantities. Eventually, i will need to enter a new bin location, then continue entering items and quantities for the new location.
Is it possible to create a form for data entry that incorporates a calendar for date selection and a dropdown selection list that will allow other fields to be automatically populated? For example, in the form, select a date from the calendar, then from a dropdown list select a customer name, say "Cookie Monster" and have another field say Customer ID automatically populated with a predefined number.
Kevin thanks so much for your videos and the help you provide. You are a great teacher. Is there a way to modify which header columns show on the form? For example, I want only some of all the header columns available to the form for data entry, not all of them.
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Great salute Sir ur my favorite teacher plz I would like to request you to teach VBA from begginer advance and expert plz am waiting that request from you I will appreciate if u do thanks
Perfect😄
Help. I tried on my excel in my Microsoft 365 but I cannot find “form” on my MAC is it not available on Mac ?
Always a pleasure to watch your videos.😊 Going to watch the Modern From video now.
Dear Kevin, I constructed the MS Form questionnaire and it was fabulous. Now I can incorporate it into Excel. Your instructional videos are fantastic, so thank you.
Kevin, your videos are awesome!!!!
I am highly obsessed with these thumbnails.
Next going to start loving the delicious cookies of the KCC 😁
Todayyyyyyyyyyyyyy, Kevin, your video is splendid. Can you make a video on 2D ANIMATION?
Kevin! You have no idea how much this would've helped with a project I had a month ago ... there were soooo many columns (and rows)! Now I'm counting down until the next one haha. Thank you!
Agree … I would’ve liked a mention of how to use a form to perform data entry/modification on a group of columns in a large spreadsheet.
love your videos, best i've seen so far on youtube
This is great, much simpler than creating a user form via VBA
TODAY! You save my life again!
Great video Kevin!
I Agree! 😉🤩
You’re a genius!!!! Thank you so much!!!❤
You're an absolute genius! Thank you.
Kevin is an amazing UA-camr
Great video+Amazing thumbnail too!
You’re such an inspiration Kevin!
Wow, Kevin! How did you know I needed this? I was just trying to figure out how to create a form that would allow me to collect data without having to go through forms for some people who I can't access through my business account ...
Always educative contents! This will help a lot!
Wow! I’ve been doing this for years and didn’t know how to do this! Thank you!
"I’ve been doing this for years and didn’t know how to do this"
Linda is a bot. Is she beginning to self-realize?
wow!!! thank you!!!
Super lesson!!!
Thanks for the video, in the past weeks I started feeling that you may have decide to reduce the uploading of new videos on UA-cam. But hey, thanks. Well, this video is also too amazing. I was knowing that how to use Macros but not knowing to edit it from VBA. Again, thanks. :-)
Thank you so much you have helped me in designing work data,Much appreciated
Make complex things simple and easy. Constructive and mininize workload. GREAT!!!
Thank You So Much, it helps me a lot
"I just wanna give you different options" I just really felt
0:00 - Hi Kevin. 👋
10:48 - 468th thumbs up from me. 👍 Cheers.
Simply amazing!!! Exactly what I was looking for. Leila explain thia function but she didn’t teach the VBA part.
Great job, Kevin!
Cannot wait to use this tomorrow.
Thank you very much! The way you explained the process was great! Seem-to-be-compllicated steps/functions were very easy to understand.
Thank you
Its really helpful. How about if I want to input more than 1 cookie type in 1 form? Is it possible?
So there is no way to incorporate a dropdown list into the form? LOVE your videos!!
THANKs for the tutorial. would it be possible in the google sheets online? tia
Thank you so much indeed. Could you also make beginner Vba/ macro videos in the future? It would be amazing!!
Thanks of this awesome tutorial 🙏, I was able to create a questionaire for my company without stress, linking it to excel and having not to stress myself going to check who responded or who did not on the form.
Thanks once again Kevin
Thanks Kevin, Do you have a video that shows how this work in excel for mac ?
Thanks kevin
Awesome Kevin , Can you give a tutorial for Adobe premiere pro or adobe photoshop
i luv your narratives
You are a creative person!! In my case, I don't even get good ideas for my school activity 😁
It would really be cool to have you as a friend in real life. Having all these knowledge is wayyyyy too awesome.
I’ll keep learning from you.
By the way you look good and I love cookies too😅 (sugar free cookies, if any😂)
Is using the Form feature available through MAC Excel? I can't seem to find it through the search field.
I'm in the same situation.
Greater Share, brother
Great info Kevin, I already put it to good use
Great!
which version of excel have this features?
Great video Kevin! It's really helpful and you are my inspiration 😁, I even started a UA-cam channel because of you and I'm doing tech tutorials! 😁😁
Great video Kevin
I also liked your dashboard video
Tried it myself - was fun doing it
Great help!
I cannot get it to work on a larger sample. I get the headings for the data entry showing up inside the area where the data entry belongs. I tried replicating yours and it works fine. My column headings are not real long but still shows up in the areas where the data should be input or captured. Any thoughts on what I might be doing wrong?
Thanks for helping me out
Super helpful!
it's great, I follow the instructions & it was very easy & helpful form me to fill up data in excel, thankyou Kevin
Mixing things up and jumping straight to the toooooodaaaaaay
Useful. Thanks.
Please is it possible to include a dropdown list in the form?
How will you make a fixed formular in a particular cell for example a1*a2 and it'll auto multiple ones you enter values in both of them without having to type anything again
Dear Kevin, the data entry form in Excel allows up to 32 fields/columns or so, may you have a solution for more than 32 fields? I have around 200 fields... Thank you very much!
Also, may you make a video about mirroring data to another excel workbook so that external users can view only while I still edit and the data are updated in both the original file and the mirrored file. Thanks a lot!
Nice video
Very useful video,
Does this work on Microsoft office excel 365?
Hello Kevin....thank you for videos...I just had a query. I have been using the data form function and data validation and for some reason the validation seems to break the form entry. Upon clicking the retry or cancel button the deletes all other data entered into the form . It forces the user to reenter/ redo that same record
Does data validation work with the data forms
is it possible to create a form that will be saved as individual files instead of saved into a table?
Call me stupid but I`m confused whether you have a real cookie company or not. Anyways can I use this form to create sheet music or tabs. If not would love to see that video. Enjoy your videos and have learned so much. OBS Studio has been great. I downloaded that cause you said you use it.
thx you
Hi Kevin Greetings from Malaysia! Am new to your channel.. Your tutorials are easy to follow and learn.. Tips that you shared are fantastic to know 👍😊 Thanks Kevin look forward to more of your tutorials 😊
Can tell few whiteboard with arrow and text
Would this be possible to use excel on a cell pone as an API to collect the data from the forms ?
Hi Kevin, form cannot be found on my Excel for Mac, how do I get the form feature?
Please, the search tab is missing on my excel, how can I get
Is it applicable to microsoft excel phone? Do you have tutorial ?how to do data entry using phone?
Thanks
Thanks 🐶
After you search form and click it microsoft gives you a message saying "microsoft excel cannot determine which row in your list or selection contains column labels" what is the way to solve for this ?
It's evening here in the Philippines, so Good eve Mr. Stratvert. I would like to ask if how can I lock shapes in excel in a way that if I protect it with password, it cannot be moved by any user? Thank you 😁😁
Brilliant video as always!! Is it possible to use a data entry form to add data to a protected work sheet?
What if I need a field to be the same in my form for several rows, and I don't want that field to type it over and over...I want to only change it when the data in that field will be changed. Example...I'm entering the inventory count for a number of bin locations...one bin location will have many, many items. I want to enter the bin location once, then just type Items and quantities. Eventually, i will need to enter a new bin location, then continue entering items and quantities for the new location.
Is it possible to create a form for data entry that incorporates a calendar for date selection and a dropdown selection list that will allow other fields to be automatically populated? For example, in the form, select a date from the calendar, then from a dropdown list select a customer name, say "Cookie Monster" and have another field say Customer ID automatically populated with a predefined number.
wow 😎
Pls teacher tell us which excel did you use it.
Can this be done similarly to an output in SharePoint?
it is very good
Hi Kevin, many thanks. Can we add drop down list in this form feature?
You’ll need to create a custom user form to include a drop down. I’ll add to my list of upcoming videos. Cheers!
@@KevinStratvert can you paste a link to that video?
hey kevin pls clarify more on zoom tool of boisvert lab if possible
What is the equivalent of this in Google Sheet?
For the command for Forms, I had to press ALT+D+O+O. I think i'm using Excel 2016.
Kevin thanks so much for your videos and the help you provide. You are a great teacher. Is there a way to modify which header columns show on the form? For example, I want only some of all the header columns available to the form for data entry, not all of them.
Learn this just a few days back in my ICT class😂
I tried using it, but there was an error message saying "too many fields in the data form"
Where is "Hi Everyone...kevin here"? Only today...
Hi Kevin, could you make a video showing us how to make a forum for free (I’ve heard of some software called phpBB)? Great work as always, Thank you!
Probably some other UA-cam videos out there for that
Spot on Kelvin,
is there a way we can use calculations to display results on the form as we input numbers? like (=A5 + B5)
Great video as usual. All in agreement, let’s see your hand
Kevin? Can you please make a Leave tracker ? The other UA-cam videos dont explain it well.
Thanks for the suggestion! I’ll add to my list. What tool would you want to use for the leave tracker?
@@KevinStratvert thank you so much. tool should be excel. but without any use of VBA.
Sir make it in google sheets
NICE!
How can I solve the error 1004? help me please
I was not able to get the macro to work 😕
Hi Kevin
Please can you do an intermediate-level video for python? The beginner video for python was epic. Thanks