🏫 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: czcams.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Thank you for this video but I noticed that after collecting the data from the form I cannot do any calculations with these data automatically. Is there a way around this problem ?
Hey Kevin! I want people to fill few columns from the form. While I also have other columns in the same table that I don't want to include in the form. How can I achieve this?
Thank you for these videos! I was able to get a job without having to shell out money for courses. Now to pay it forward, I offer free videos on DIY items!!!
Thanks Kevin, one small tipp to add: I always start putting the Excel file in a subfolder Questionaires. Otherwise you have book1 book2 etc in your root directory. If you later move the Excel sheet to another directory, the online form is always connected to this Excel file.
Muchas Gracias, Kevin! You are an excellent instructor. You enunciate every word clearly, you also deliver your speech succinctly with a perfect speaking rate, yet it is so informative for learners to follow your teaching with ease. Thank you very much for your effects and for sharing your knowledge.
This is great to know! I’ve used Google Forms before, but as an Excel user this looks more robust. I’ll definitely be checking this out for work projects. I wish this was also available for personal use. Thanks for yet another great video!
When Kevin says "Hi Everyone Kevin Here" you know what? I start to feel the vibes the goosebumps the excitement that I'm going to learn something awesome from nothing but a LEGEND! And you prove it every single time! Kevin's thumbnails, videos, jokes, representation and everything is just full of tick marks with 100% on it! The small Element near you in this thumbnail which has a couple of tick marks, you know what? It's you! It's just you! Your excelled in excel than anyone I've seen! Enjoyed watching it!
Thanks Kevin! Very thorough and was able to create a customer questionnaire by following your video. It was very straight forward and easy. This is going to save me and my team a ton of time. Plus, it will help us better actually use the data!!
Kevin, you are a god! You have NO idea how much time and effort this will save me on certain tasks that I have to do at work. Thank you, thank you, THANK YOU!
I've used this feature several times since I watched an earlier video of yours. It's extremely useful and very versatile. This video is an excellent refresher and clarified a couple points for me. Great stuff!
Thank you very much, FROFESSOR! After watching your video, I designed similar forms. Now we are using it in the office and my staff appreciate those forms very much, because they can now organize their tasks easily. We are also beginning to design our VIRTUAL OFFICE so that we could have a platform - where I can monitor their tasks even if am not around our Physical Office. Thank you very much, PROFESSOR! Merry Christmas!
Kevin! You changed my life! I do have a few follow up questions and hopefully someone on this feed can help: 1. Can I connect multiple forms to one data table? 2. For the customer query (submitted through the form), is there an easy way to create a "ticket" to share with a person to process?
Wow...this opened a whole new world to me, so easy to do (of course thanks to your explanation) and it works....where you have been all my life....lol....so really Im your new suscriber from today from Chile
I dont know sht about fcuk when it comes to computers or microsoft but with this video, I was able to create my own excel data entry form. youre a god. stay healthy, i need more of these
Have enjoyed your videos for some time. We're migrating Excel tables into SharePoint. Do you have a video on building custom forms in SharePoint as opposed to the standard forms?
this is very good, but like they have restric to not everyone can use, google is on ahead, on google sheets you have the sheetapp can do it those form, and much more than that. But thank you, is good to know there is another alternatives.
Kevin, thanks for this helpful video. Do you have a video on editing the links between the form question & the table in excel? My data is showing in the wrong column in the table.
Great video Kevin, but what if someone wants to order more than 1 type of cookie? I tried to set up a similar form as a purchase requisition form for my company, but got stuck when trying to allow for an unknown number of items to be requested. Each item will have the same base data (requester, approver, department, etc), but of course different description, part no, quantity etc. Any ideas on how this could be accomplished with MS Forms?
Kevin, can you help? I designed the MS form with Excel to collect my data from a MS form. Numbers appear on the left of their column in excel (indicating text format) rather than on the right (number format). If I go into data/Text to Columns I can change the format of the numbers. Can I set the spreadsheet or form to allow the number to change to the correct format?
I created my form and it links to the new excel and puts the responses in there. However, when new responses come in, they don't show up in that XLS workbook. If I go back to the form, and try to open the XLS from there, it opens the stale XLS workbook (which doesn't have the new responses) with a warning at the top of my excel that says "This form is linked to a different workbook." So then I have to go back to Form, click DISCONNECT and RESYNC in new WORKBOOK and then all the aggregated responses show up in the new workbook. What's wrong? Why isn't it just syncing to the original workbook xls created when I made the form?
Kevin, we need more videos on Power Automate and Power apps. Also, could you please make a video on the expressions used in the email to excel video? Thank you.
Great video. Can someone answer this? I want to do this many times over without having to recreate the form. Multiple Excel workbooks all with the same form to be filled by different users. Is this possible? when I copy an Excel with a Form, the new copied workbook doesn't know it has a form
Great video. Is there a way to search the orders from the spreadsheet and update the a field (like the number of cookies ordered?) Like to do it with a form rather than directly on the spreadsheet? Thx.
Your videos are absolutely amazing and helpful. I finished two advanced units of Microsoft excel last semester at college but no one taught us these contents. 🙏🙏👍👍👍👍👍
Good video, but not quite what I need. I am creating an Excel spreadsheet to record all my crypto activity, I had hoped that "forms" would be the entry solution as I require the abiliity to add new Crypto to the list of cryptos I have. So, I want to have a simple form that will be called whenever I need to add a crypto, so, what EXCEL function will be able to achieve this? Also, each crypto Token will have to record a set of specific data, so, is the solution to create a Base Table template, then use that to record the data, but, that new table data will need to be included with the other Token data already garnered.
Hello, Kevin! Thanks for the video! I have a question: Forms enter numbers in the Excel table only with ' apostrophe. It makes it difficult to work with the data in real-time because you need to get rid of the apostrophe before you apply formulas to analyze data. Do you have any idea how to fix it? Thanks
I love the video however when I used my office version of the browser excel it doesn’t appear to have the form in the insert section but I can create a form through office is there a way the link a form into a new excel?
Hi Kevin, I'm using my personal Office 365 to create the Form. How do I edit or remove the initial form text that says, "Hi, Arnel. When you submit this form, the owner will see your name and email address." Thanks for your excellent method of teaching.
Hello, it is very easy for you to give information about Excel ... but if you give understanding in Hindi language, it can give more understanding to everyone ... thank you
what if i want to change the look of the excel sheet? i want it to look like a decently looking document that i can print that has headers and footers and a company logo for example.
Kevin - I love the videos, they are always a big help. Is there a way to embed the Form into an Outlook email so that people can submit their answers directly from the email?
Enjoy your videos. Have learned quite a bit. One question tho. I have created a spreadsheet to keep track of my part usages and orders. I enter the part number in 1 column then using VLOOKUP, get the description of that part number to populate its description into the next column. Can the VLOOKUP function be used in this data entry procedure?
OMG, I loved it, I've already spent the entire day trying to figure out something like this to make it simple for my estimators to upload their projects. How can this be extended to a list of components for a roofing system? The columns are always the same ID, Cost Code, Title, Unit Price and Unit Type but each rood has several lines, one for the membrane, one for the Cover Board, one For the Insulation, one for Fasteners and so on. I don't see how to use this but instead a Fully Automated Data Entry and the coding is driving me crazy.
I've now seen ways to make fillable forms with Excel, Word and a third party site to make a PDF. version...and now I don't know which I need to use. I don't really have a form preference, I guess. I just want my customer to fill it out and then the data to link to MS Access. What do I use to create the form to link to MS Access?
Is there a New Style data query form ? Similar to entry but the user fills in criteria and it searches then reports on results of query? I know the excel forms has query but it does not retrieve info into a separate space.
Hi Kevin, I hope you are well. Thank you so much for the tutorial. I have managed to create the form, but when filling it up the information doesn't show on ms excel. what could be the challenge here?
🏫 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: czcams.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Your video was good, my problem is with MS Subscriptions. F*K that noise!
👍🙂👍 for your video: 🖕😡🖕 for Microsoft Subscriptions!
Thank you for this video but I noticed that after collecting the data from the form I cannot do any calculations with these data automatically. Is there a way around this problem ?
Hey Kevin!
I want people to fill few columns from the form. While I also have other columns in the same table that I don't want to include in the form. How can I achieve this?
Hello Kevin. I have to fill data on a website which is asking for it to be filled in electronic form. Do you know the deal?
Thank you for these videos! I was able to get a job without having to shell out money for courses. Now to pay it forward, I offer free videos on DIY items!!!
I really like the introduction of Kevin Hi everyone, Kevin here Today..
I don’t
Not today, its "too dayyy" well i like his accent
Thanks Kevin, one small tipp to add: I always start putting the Excel file in a subfolder Questionaires. Otherwise you have book1 book2 etc in your root directory. If you later move the Excel sheet to another directory, the online form is always connected to this Excel file.
Can you put this on sharepoint and then not have versions?
Muchas Gracias, Kevin! You are an excellent instructor. You enunciate every word clearly, you also deliver your speech succinctly with a perfect speaking rate, yet it is so informative for learners to follow your teaching with ease. Thank you very much for your effects and for sharing your knowledge.
Ever since i had e recommendation from CZcams for your videos I have learnt a lot. N I have love MS office more
For personal use, I like using the new Mobile Card view. It works like a form.
This is great to know! I’ve used Google Forms before, but as an Excel user this looks more robust. I’ll definitely be checking this out for work projects. I wish this was also available for personal use.
Thanks for yet another great video!
When Kevin says "Hi Everyone Kevin Here" you know what? I start to feel the vibes the goosebumps the excitement that I'm going to learn something awesome from nothing but a LEGEND! And you prove it every single time! Kevin's thumbnails, videos, jokes, representation and everything is just full of tick marks with 100% on it! The small Element near you in this thumbnail which has a couple of tick marks, you know what? It's you! It's just you! Your excelled in excel than anyone I've seen! Enjoyed watching it!
This is awesome. Now I would like to know how to take the form data, run it through some calculations and spit back a pdf the user can download.
Thank you for the clear and concise videos! I also recommend you to my students!
Thanks Kevin! Very thorough and was able to create a customer questionnaire by following your video. It was very straight forward and easy. This is going to save me and my team a ton of time. Plus, it will help us better actually use the data!!
I get SO MUCH from your CZcams tutorials! Thanks for doing this!!!
Kevin, you are a god! You have NO idea how much time and effort this will save me on certain tasks that I have to do at work. Thank you, thank you, THANK YOU!
Kevin's studio is so nice that sometimes I even wonder whether it is a virtual background. 😀
😂
Dream Studio
I've used this feature several times since I watched an earlier video of yours. It's extremely useful and very versatile.
This video is an excellent refresher and clarified a couple points for me. Great stuff!
Its really great to hear his welcome! Thanks from Brazil, Kevin!
I created a form today that will help me track onboarding new hires. So helpful!
Thank you very much, FROFESSOR! After watching your video, I designed similar forms. Now we are using it in the office and my staff appreciate those forms very much, because they can now organize their tasks easily. We are also beginning to design our VIRTUAL OFFICE so that we could have a platform - where I can monitor their tasks even if am not around our Physical Office. Thank you very much, PROFESSOR! Merry Christmas!
I really like the introduction of Kevin Hi everyone, Kevin here Today.. (2)
Mind blown at the simplicity 🤯
Kevin! You changed my life! I do have a few follow up questions and hopefully someone on this feed can help:
1. Can I connect multiple forms to one data table?
2. For the customer query (submitted through the form), is there an easy way to create a "ticket" to share with a person to process?
u r a life savior Kevin....lots of love from me...thanks a lot.
just completed a simple task for my organization using excel forms .. thx!
this made my life so much easier! my boss is going to be impressed
Kevin you are a genius
Wow...this opened a whole new world to me, so easy to do (of course thanks to your explanation) and it works....where you have been all my life....lol....so really Im your new suscriber from today from Chile
This is much easier than using power automate
Thank Kevin
I dont know sht about fcuk when it comes to computers or microsoft but with this video, I was able to create my own excel data entry form. youre a god. stay healthy, i need more of these
truly your tutorials are awesome very easy to understand
*You don’t need a Work or Education account. I can use my personal account and works perfectly fine.*
I have a paid personal Office 365 account and I don't see the Insert > Form option when I try through Excel on the web or on Excel on the desktop. :(
@@Lost-In-Blank Google MS Forms, then make a new one. Then go to Responses. And click on Open in Excel.
Tell me how exactly , I can’t see the form option anywhere.. help please
Seriously awesome content. And the positivity of Kevin, that's something to learn 👍🏻🙂
hi Kevin, can you post a laptop buying guide video?
Have enjoyed your videos for some time. We're migrating Excel tables into SharePoint. Do you have a video on building custom forms in SharePoint as opposed to the standard forms?
When you said Kevin Cookie Company, the first thing that came to my mind was The Office's Kevin Malone! 😆😆🤣🤣
Brilliant video. Everything was explained so well.
I love you Kevin :) this is what I needed right now. thanks a bunch
this is very good, but like they have restric to not everyone can use, google is on ahead, on google sheets you have the sheetapp can do it those form, and much more than that.
But thank you, is good to know there is another alternatives.
Kevin, thanks for this helpful video. Do you have a video on editing the links between the form question & the table in excel? My data is showing in the wrong column in the table.
Great video Kevin, but what if someone wants to order more than 1 type of cookie? I tried to set up a similar form as a purchase requisition form for my company, but got stuck when trying to allow for an unknown number of items to be requested. Each item will have the same base data (requester, approver, department, etc), but of course different description, part no, quantity etc. Any ideas on how this could be accomplished with MS Forms?
Please do a detailed and complete explanation of using the Excel charts.
Can't wait to play around with this! Thank you!
Wow thanks for your sharing, actually I could created it in my own one but after I watched your vdo, that’s more something to learn
Thanks for your videos. I have gotten more advantages, and I will use it my duty.
Can't believe I've been doing this all wrong for years. Thanks!
Awesome video Kevin. Just solved a lot of issues for me. Thanks for the awesome content as always!
I am learning a lot from your channel. Thank you so much.
thanks sso much Kevin. i love your tutorials because they are engaging
Hi Kevin. I'm from Namibia and I stumbled on your channel. This is just what I was looking for. Great work. Regards Rowan
Thanks ! your tutos really are the bests and seriously help me step up my skills !
Kevin, can you help? I designed the MS form with Excel to collect my data from a MS form. Numbers appear on the left of their column in excel (indicating text format) rather than on the right (number format). If I go into data/Text to Columns I can change the format of the numbers. Can I set the spreadsheet or form to allow the number to change to the correct format?
Same issue.
Is there any way to make the questions dynamic? Ie the next question to show is dependent on the previous answer ?
Yes! Click on the ellipses on a question and you can set up branching with sections.
Hi Kevin, too bad I am retired but it is very interesting, Exel comes this far.
Amazing tutorial that I could create my own professional form now! It would be great if the form enable auto running number for my Invoice.
Man, you are amazing as well as your videos too. They are really helpfull
Thanks Kevin! Can you do a video on creating a form linked to an existing spreadsheet so that admin staff can suggest changes that need to be made?
Your videos are so totally awesome, duuuuuude!!
I created my form and it links to the new excel and puts the responses in there. However, when new responses come in, they don't show up in that XLS workbook. If I go back to the form, and try to open the XLS from there, it opens the stale XLS workbook (which doesn't have the new responses) with a warning at the top of my excel that says "This form is linked to a different workbook." So then I have to go back to Form, click DISCONNECT and RESYNC in new WORKBOOK and then all the aggregated responses show up in the new workbook. What's wrong? Why isn't it just syncing to the original workbook xls created when I made the form?
Awesome video sir. Just solved a lot of issues for me. Thanks for the awesome content as always! Best of luck Forever
Kevin, we need more videos on Power Automate and Power apps. Also, could you please make a video on the expressions used in the email to excel video? Thank you.
Very informative video. Thank u
Great video. Can someone answer this? I want to do this many times over without having to recreate the form. Multiple Excel workbooks all with the same form to be filled by different users. Is this possible? when I copy an Excel with a Form, the new copied workbook doesn't know it has a form
Great video. Is there a way to search the orders from the spreadsheet and update the a field (like the number of cookies ordered?) Like to do it with a form rather than directly on the spreadsheet? Thx.
Is it possible to use multiple dependent dropdown list in this form?
You are amazing, thank you !
Thanks Kevin for another amazing piece of work
Great sir!!
You really grab handy things for us! ❣️.
Thank you
Another great video
wow...... amazing Kevin.
Your videos are absolutely amazing and helpful. I finished two advanced units of Microsoft excel last semester at college but no one taught us these contents.
🙏🙏👍👍👍👍👍
Good video, but not quite what I need. I am creating an Excel spreadsheet to record all my crypto activity, I had hoped that "forms" would be the entry solution as I require the abiliity to add new Crypto to the list of cryptos I have. So, I want to have a simple form that will be called whenever I need to add a crypto, so, what EXCEL function will be able to achieve this? Also, each crypto Token will have to record a set of specific data, so, is the solution to create a Base Table template, then use that to record the data, but, that new table data will need to be included with the other Token data already garnered.
Is Adobe the safest or best previewer to use in MS Outlook, etc.? Thanks. Also, read the article you were featured in CNBC. Congrats
Sounds good but what if a person uses a form and fills in the information incorrectly? Is there a way for them to edit it?
Wonderful video, to feel the power of Microsoft 365. Thanks a lot :)
He speaks English Yes 🙌
U R my new best friend. I Wuv u! Thanks heaps! just what I need wish me luck. Will watch ur other 1 soon, but gotta give it a go xx
Best of luck!
Hello, Kevin! Thanks for the video! I have a question: Forms enter numbers in the Excel table only with ' apostrophe. It makes it difficult to work with the data in real-time because you need to get rid of the apostrophe before you apply formulas to analyze data. Do you have any idea how to fix it? Thanks
I love the video however when I used my office version of the browser excel it doesn’t appear to have the form in the insert section but I can create a form through office is there a way the link a form into a new excel?
What is the difference compared to Google form?
Thanks for this knowledge kavin ,🙏🏻🙏🏻🙏🏻🙏🏻
Hi Kevin, I'm using my personal Office 365 to create the Form. How do I edit or remove the initial form text that says, "Hi, Arnel. When you submit this form, the owner will see your name and email address." Thanks for your excellent method of teaching.
Wow. Can I use this form on my Android Tablet and OFF LINE (in areas with No Internet ) for data collection?
Kevin, when you have a form can the user update there information, for example update a training record?
I would like to know this too, I assume you somehow can. Seriously limiting if not!
Is there an option to avoid duplicate entries at the time of entering into the forms?
Hello, it is very easy for you to give information about Excel ... but if you give understanding in Hindi language, it can give more understanding to everyone ... thank you
Thanks a lot Kevin.
just asking how to fix if the alt code showing different after. example alt253 is squared but shows heart. thanks in advance.
what if i want to change the look of the excel sheet? i want it to look like a decently looking document that i can print that has headers and footers and a company logo for example.
Kevin - I love the videos, they are always a big help. Is there a way to embed the Form into an Outlook email so that people can submit their answers directly from the email?
Enjoy your videos. Have learned quite a bit. One question tho. I have created a spreadsheet to keep track of my part usages and orders. I enter the part number in 1 column then using VLOOKUP, get the description of that part number to populate its description into the next column. Can the VLOOKUP function be used in this data entry procedure?
Yes, thanks build a basic form. Can a field be pulled from a list in excel? Instead of me typing in all the possible entries?
OMG, I loved it, I've already spent the entire day trying to figure out something like this to make it simple for my estimators to upload their projects. How can this be extended to a list of components for a roofing system? The columns are always the same ID, Cost Code, Title, Unit Price and Unit Type but each rood has several lines, one for the membrane, one for the Cover Board, one For the Insulation, one for Fasteners and so on. I don't see how to use this but instead a Fully Automated Data Entry and the coding is driving me crazy.
Thanks for sharing. Good work. How would you add (how many cookies you want per each kind) if you want more than one kind of a cookie?
Thank you can you elaborate a bit more for example multiple cookie types with different order quantities?
I've now seen ways to make fillable forms with Excel, Word and a third party site to make a PDF. version...and now I don't know which I need to use. I don't really have a form preference, I guess. I just want my customer to fill it out and then the data to link to MS Access. What do I use to create the form to link to MS Access?
thanks
Is there a New Style data query form ? Similar to entry but the user fills in criteria and it searches then reports on results of query? I know the excel forms has query but it does not retrieve info into a separate space.
Hi Kevin,
I hope you are well.
Thank you so much for the tutorial. I have managed to create the form, but when filling it up the information doesn't show on ms excel. what could be the challenge here?
Very useful. Thank you.
Yes I could!