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