🏫 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 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 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. :-)
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 😊
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😂)
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.
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.
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?
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
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 😁😁
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!
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
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.
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.
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 ?
🏫 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 ?
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.
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.
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 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 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. :-)
Make complex things simple and easy. Constructive and mininize workload. GREAT!!!
This is great, much simpler than creating a user form via VBA
Thank you so much indeed. Could you also make beginner Vba/ macro videos in the future? It would be amazing!!
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?
Kevin is an amazing UA-camr
Thank you very much! The way you explained the process was great! Seem-to-be-compllicated steps/functions were very easy to understand.
Simply amazing!!! Exactly what I was looking for. Leila explain thia function but she didn’t teach the VBA part.
So there is no way to incorporate a dropdown list into the form? LOVE your videos!!
You're an absolute genius! Thank you.
TODAY! You save my life again!
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! 😁😁
Thank you so much you have helped me in designing work data,Much appreciated
You’re such an inspiration Kevin!
You are a creative person!! In my case, I don't even get good ideas for my school activity 😁
"I just wanna give you different options" I just really felt
it's great, I follow the instructions & it was very easy & helpful form me to fill up data in excel, thankyou Kevin
You’re a genius!!!! Thank you so much!!!❤
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 😊
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😂)
Cannot wait to use this tomorrow.
Thanks kevin
Mixing things up and jumping straight to the toooooodaaaaaay
love your videos, best i've seen so far on youtube
Great video+Amazing thumbnail too!
Awesome Kevin , Can you give a tutorial for Adobe premiere pro or adobe photoshop
Kevin, your videos are awesome!!!!
Always educative contents! This will help a lot!
Great video Kevin!
I Agree! 😉🤩
wow!!! thank you!!!
Thank You So Much, it helps me a lot
Great video Kevin
I also liked your dashboard video
Tried it myself - was fun doing it
Super lesson!!!
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.
Its really helpful. How about if I want to input more than 1 cookie type in 1 form? Is it possible?
Thanks Kevin, Do you have a video that shows how this work in excel for mac ?
Great info Kevin, I already put it to good use
Thanks for helping me out
thx you
Great!
Greater Share, brother
Great job, Kevin!
i luv your narratives
THANKs for the tutorial. would it be possible in the google sheets online? tia
0:00 - Hi Kevin. 👋
10:48 - 468th thumbs up from me. 👍 Cheers.
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.
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.
Brilliant video as always!! Is it possible to use a data entry form to add data to a protected work sheet?
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?
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
Useful. Thanks.
Very useful video,
Super helpful!
wow 😎
Thanks
Great help!
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
Learn this just a few days back in my ICT class😂
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 😁😁
Hi Kevin
Please can you do an intermediate-level video for python? The beginner video for python was epic. Thanks
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!
Great video as usual. All in agreement, let’s see your hand
Thanks 🐶
Is it applicable to microsoft excel phone? Do you have tutorial ?how to do data entry using phone?
it is very good
For the command for Forms, I had to press ALT+D+O+O. I think i'm using Excel 2016.
Nice video
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
is it possible to create a form that will be saved as individual files instead of saved into a table?
Would this be possible to use excel on a cell pone as an API to collect the data from the forms ?
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.
Spot on Kelvin,
is there a way we can use calculations to display results on the form as we input numbers? like (=A5 + B5)
Sir make it in google sheets
NICE!
Pls teacher tell us which excel did you use it.
Can this be done similarly to an output in SharePoint?
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.
hey kevin pls clarify more on zoom tool of boisvert lab if possible
Hi Kevin, form cannot be found on my Excel for Mac, how do I get the form feature?
Does this work on Microsoft office excel 365?
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?
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 ?
which version of excel have this features?
What is the equivalent of this in Google Sheet?
💚💚💚
I tried using it, but there was an error message saying "too many fields in the data form"
Please, the search tab is missing on my excel, how can I get
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.
Can tell few whiteboard with arrow and text
Where is "Hi Everyone...kevin here"? Only today...
Where can I buy Kevin Cookies bro?
How can I solve the error 1004? help me please
I was not able to get the macro to work 😕