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