Top 25 Microsoft Forms tips and tricks

[@anthonygikuri]

Oh no, I cant believe you covered an entire course for just a couple of minutes!!!! This is marvelous!!! Thank you so much for sharing!!!

[@MimKhatun-u1k]

Such as digitalsoftwarekey

[@tarakinsell6202]

I cannot begin to express how excited I was to find this. I sat through a really sad demonstration today - being kind. I was so frustrated after it. Then I did a quick search and found this! Wow!!!!!!

[@kiranp551]

Thanks. MS needs to add signature option on the forms.

[@diyhell8712]

Great video - particularly appreciate that you took the time to add a table of contents so I could skip to the tips new to me: thanks!

[@MikeTholfsen]

Awesome, thank you!

[@deltons1000]

Wow flipping awesome!😯 I have been using MS Forms now and I learnt A LOT! Thanks!

[@MikeTholfsen]

Glad it helped!

[@SeemaRamdev]

Fastastic Skills Mike.. this was worth the time watching. Thank you for making it

[@loriwaggoner7129]

Excellent. Quick, clear, highly informative!

[@Zwinilea]

Awesome. You have made something easier for me than a form editor. Keep up the good work!!!

[@rosinator6740]

superhelpful video! Thanks a lot 👍

[@itucsok]

Very helpful! Thank you for creating such a great material!

[@tindikamwetu2134]

This was super informative. I got a ton of tips to use with my classes. Fav tip of all was number 25. Being able to view a video and check on comprehension at the same time is brilliant! :)

[@MikeTholfsen]

Glad it was helpful

[@stanleyds]

Tip 21 was great! Sometimes I forget to look for cross-app features.

[@hazokichan2843]

That was beneficial! Thank you 🙏🏻

[@isagerl8603]

great video, didn't answer my question, but gave me some great ideas. Thx a lot.

[@DTrainsWife01]

Thanks for such a well-organized, clear and informative video! You shown me a tool I had honestly forgotten about. Now I'm ready to take my use of forms back to the office. I'm excited to use these tips!

[@sathyanarayananswaminathan6860]

Hey, This's a definitive guide on Office Forms. But nowhere you've shown how to collect the email address without filling manually! Ideally this should be the most important feature to collect responses from the users.

[@pattyjones8397]

LOVED THIS!!! Thank you so much, totally demystified some of my struggles. Thanks so much!

[@MikeTholfsen]

Glad it was helpful!

[@florpicon7035]

Super helpful and straight to the point. Thanks!

[@lynettenaidoo5008]

Great video Mike. Thank you for these great tips! Sincerely appreciated.

[@ilmadennislara5332]

It would be great if Microsoft Forms offered the users the option to create folders in order to classify and organize all our questionnaires. Thanks for the video...!

[@MikeTholfsen]

That's a great idea! The team is actively working on adding Forms organization

[@venkataravindragadamsetti2796]

Thank you for your informative videos on using Microsoft Forms! I have a specific question regarding Microsoft Forms: I need to create a demographics profile for a group of 15-20 people. Instead of having these individuals fill out the form themselves, I want to enter the information myself for each person. Is it possible to set up a Microsoft Form where I, as the form creator, can input and store the demographic data for multiple people? If so, could you guide me on how to do this effectively? Looking forward to your guidance

[@denisekobrin9338]

Great video! Hoping you can answer this question. I created a question with options for the answer (class name). I want to sort them in alphabetical order. I did not see this option but was able to manually reorder the options using the dots on the left. Do you know if there is a way to automatically sort them alphabetically rather than having to move them manually? Thank you!

[@faithsubbu]

Thank you so much! Got to learn few new things today from you What if I want to get geo location of the person filling out the forms?. How do I do it??

[@manokejason]

The quiz Math input feature my favourite. Thank u so much for this in-depth educational video.

[@jennifervitug1494]

Love this chocfull of tips . I just shared this with my colleagues at work, I'm sure they'll be delighted too

[@MikeTholfsen]

Great, thanks for sharing!

[@anniesebmuged7960]

My account Annie sebmuged

[@Mariam-vz4bv]

Very informative. Thank you for sharing.

[@MrHamzaakhan]

Love this!!!!!! Super helpful summary for our upcoming MIE training session over the weekend!! Keep up the fantastic work you and your team are doing!!! ❤️❤️❤️

[@MikeTholfsen]

Gs was helpful. Hope your summit goes well!

[@finn5905]

Thanks for the tips. Very helpful!

[@MikeTholfsen]

Glad it was helpful!

[@tamararufener9729]

These are GREAT! BUT... I do have a question. I am creating a form to pre-authorize travel. Question #8 is Estimated Total Cost of Trip [ based on 9, 10, & 11 ]. Is there a way to enter a dollar amount in each #9, 10, and 11 and then have them total to line 8? Thank you.

[@MJBRidge]

very useful and comprehensive. Nice job!

[@MikeTholfsen]

Thank you!

[@katiebriggs8413]

Thanks Mike, such a helpful video! Do you know if polls/surveys can be auto scheduled? For example, if I run a weekly group (same time each week) and am looking for weekly feedback post group? Thanks for your help.

[@doraocchipinti6103]

Hi Mike -I have created a question with choice options Strongly agree, agree, disagree and strongly agree - How can I add a feature in that question so that my users can add comments in relation to the question. I could do this with Survey monkey

[@ezechukwunwemeh3571]

I came here for this.

[@uttamkumar1644]

Hi Mike, this is awesome video..one of the best on Teams form...thanks a lot, Just need one help I have created a form for new joiner but when he submitted I got some weird columns in excel sheet this is bit strange, how to overcome this issue...please suggest

[@williammaroon932]

Super helpful - Thank you!! Can you share the platform you used to create this training? I love the zoom feature to demo the screen action. Thank you Mike.

[@MikeTholfsen]

I use Camtasia

[@vijayarjunwadkar]

Super Tips on Forms! Thanks a lot Mike, many are going to be very useful to me in my work! 😊👍

[@MikeTholfsen]

Great, glad to hear that!

[@smlarrabee65]

Really enjoyed this! Question for you - can I have the form be the last thing they see, without having to go back to the video? Thanks

[@myrenocomputertutor1690]

Excellent - thanks for the great work!

[@lovasatesz]

Hello! Im learned a lot...and now i have new ideas. Thanks for the video, super cool and informative. I will see again. Have a nice day! Thx

[@MikeTholfsen]

Glad it was useful

[@letmebefrnk]

Great stuff. For translation, will it in future translate the questions and possible answers? Also, translation of responses in other languages?

[@MikeTholfsen]

Yup. All possible with Immersive Reader

[@jcolley31b]

Great Video. I have always used Google Forms so I am just learning this one. Which do you feel is better or are they essentially the same? Also, why does the excel form download (responses) add extra feedback columns that repeat your questions when there are no feedback questions in the form? I did not find anything in settings or any options for this.

[@moisestatis5418]

Great video Mike, thanks so much! Just one question. If I created a form within an excel file for someone else and I want to share it, should I send the excel file or the form as template? I want the person to have the form and be able to the see information in real time in excel. Thanks

[@johnchiappetta3933]

MIke, AWESOME tutorial on MS Forms!!!

[@MikeTholfsen]

Glad you like it!

[@thayayogam]

Thank you so much! It is very helpful. How do I change to multiple answers on the liked the table questions type? I like to get multiple answers on liked questions type. There is only an option for multiple answers just for choice questions.

[@PeterMüller-l8o]

I just created a Form and have zero idea where the document is even saved. Cant pick another save-to location eather. This app is a confusing mess.

[@jasonhorn901]

Thanks so much. Lots of great information here! Quick (or perhaps not so quick question): If I've created a Forms quiz/survey, how can I upload that into a specific Teams meeting in real time when I'm conducting a meeting/lecture/workshop?

[@knowgovt]

Is there a way to extrapolate the data? For example: if I wanted to include a line in the polls about demographs, can we look at the data that way? Is there also a way to show percentages for what is answered instead of just numbers?

[@justinmitra9401]

Hi Mike, I want to create a simple form/quiz, which has a series of questions weighing certain points with 3 options as answers to the question - Yes, No and Not Applicable. What I specifically want is when Yes is selected as an answer the question earns the points, if Not applicable is selected the question becomes invalid in the total points calculation and if No is selected then the submitter has a provision to comment (describe why it was No) I hope you will be able to help

[@BrockLeonard]

thanks for your help mike!

[@abeermoawad3725]

very useful video, is there a chance to merge two forms together?

[@MikeTholfsen]

Not at this time

[@pollylee118]

Thank you so much. It was a very detail video. So powerful!

[@MikeTholfsen]

Glad it was helpful!

[@Tiffany-RemoteOfficeGirl]

Thank you! Is MS Forms a separate purchase from Office 365? I don't see it as an option on the plan comparison page. Chat support doesn't seem to be working.

[@fannyelm8940]

Hi Mike Thanks for this helpful video. Do you know a way to have a multiple answers table in the form? Like a Likert with more than one answer per line. Thanks

[@nele6139]

Hello Mike, thanks a lot for this Video. I have two questions. We would like to use forms before a Job Interview. I would like to know via Email when the Person has finished the Form. Where can i find this application? Further i would like to get the data from each Person sepparetely, no Collection. If a few persons filling the Form i will probably lose the overview. How i can See the data from each Person an what they have answered? Thanks a lot, Nelly

[@aylonsamson4397]

Great tips. Already started using it. Very intuitive. Question: Is there a way to brand the form. Specifically, what are the specs for the header image? Can RGB values be selected for the header color? How about adding an image to the bottom? Great product and quite powerful for collaboration.

[@MikeTholfsen]

Unfortunately that is not currently supported

[@mowburnt]

Amazing video! So excited to use this. I had 3 questions as a noob to all this. 🚴‍♂️1. If you had a question about distance can you add a drop down box to let the user select units next to their answer (ie mm, inches metres, feet, miles, km etc ?) 👨‍👩‍👧‍👦 2. Can you add data validation to an answer ie between 10 and 60 is allowed and flash up a warning if outside the limits? 🚦3. Can you set a formula based on answers in forms to take the responder to most relevant next question (or end the form) based on where the answer falls in a range of figures. For instance the responder types in their actual age and if its between 10-17 end form, if aged 18-35 goto q4, if aged 36 to 60 goto q5 etc?

[@MikeTholfsen]

Great questions. Those are currently not supported but you can go to uservoice to add them or vote: microsoftforms.uservoice.com

[@phloem4]

Thanks. Is is possible to have a form preload/fill data from the previous entry?

[@sagirajubharath]

Hi Mike, Hope you are doing well!!! How to generate some unique reference id in forms or How can we hide some activity in forms , so i will enter some unique id and hide or disable it ..so that users can change it. thanks in advance

[@adrivianna5282]

This video is very helpful. Thanks for sharing

[@briananurse7818]

Great overview, Mike. I'm curious to know if there is a feature that allows me to embed a link into a question.

[@ebenjamin24]

Super cool video Mike! Thank you!

[@MikeTholfsen]

Glad you liked it!

[@jayenriquez5653]

Thank you for this video.

[@jasonk9040]

Great video - thank you! Is there any way to tighten up the spacing? We are making a form where we have to enter a persons name and address and the form gets really long when there is a line devoted to things like state/prov, Untit #, phone # when normally these would all be in one row on a form.

[@MikeTholfsen]

Not that I am aware of

[@teatreetops]

Is it possible to have the form added to an outlook email so the recipient(s) can fill it out from the email as opposed to including a link they’re required to open in order to respond? Thank you!!

[@isobelgowers4684]

Hi Mike, thanks for the great video. Are there any plans to be able to add pre-prepared forms into the chat in Teams? When teaching it would be much easier if we could pre-prepare our polls and quizzes rather than trying to type this as we teach.

[@patrickpanian2]

Setting a pre-made quiz / form as an assignment is a workaround for this.

[@irapashunnur8237]

Great Video. I do not see Forms in My Excel & Powerpoint. What to do ?

[@TsuDenom]

Thanks for sharing. I have an issue when using the Likert Scale, i.e. I have a long list of statements (>10), so the Statements are not visible when one scrolls down. How does one correct this?

[@chanthawans.9516]

It's very helpful and great video, thank you! I have one question, can we change the type of chart bar in my responses?

[@fatimaros1827]

hi Mike, thank you for your videos, please do you know how can I restrict an answer. if i want to offer 3 options but each one has a limited capacity, is it possible? ideally, once one option is full its should disappear. thank you

[@johnheck1551]

Great video and really helpful Mike. When you showed uploading a file can that Form be shared with people outside the organization to upload a file? Also, is there any way to verify data in a form? For example, what if you want to verify an email address by a user entering it twice?

[@kathrynhall2019]

Such as great video, thank you! Got some great tips for my form.

[@MikeTholfsen]

So glad!

[@jaironaranjo3654]

Mr. Tholfsen what application i should learn to create a form in which require school name, principal name and then my biggest question the principal can enter from 1 student name id grade but my concern is that the form can have one upto 200 students How can i create a loop so the form would be feasible for one as to many student please give me the application name thank so much and again great presentation on your tutorials

[@huyenanhnguyen6348]

thanks Mike, such a helpful video

[@MikeTholfsen]

Glad it was helpful!

[@keningilbert]

Fabulous introduction into Forms! Can't wait to try it. Once a form is created within Excel it is obvious that it is being stored in an Excel document stored on SharePoint. When you create a form within the Forms app in order to access the responses you have to go back into Forms then Responses. Curious on where that raw data is actually being stored and in what format? Same question with PowerPoint, OneNote, Teams. An Excel file or CSV file? Is the only place to access the Responses from within Forms?

[@MikeTholfsen]

It is stored in the Forms backend

[@keningilbert]

@@MikeTholfsen Thanks for response, but what to you mean buy Forms backend? Also, what format are Forms created outside of Excel?

[@christopherraeperez3122]

Very helpful. thanks a lot. :)

[@adelespringer294]

Thanks Mike for the information. Do you have a quick and easy way to change the background colors on the Likert scale? It is hard to read with the grey background.

[@MikeTholfsen]

Not at this time

[@adelespringer294]

@@MikeTholfsen Thank you for your response.

[@lenschendel3425]

Informative video! FYI: formal name for a "dot, dot, dot" menu is an "ellipsis" menu.

[@MikeTholfsen]

Yeah, I know. It's more fun to say "dot dot dot" and it also translates better to other countries 😄

[@kvdp1805]

Great video Mike! Kudos for you! Your tips are very appreciated by Dutch educators! Keep up the good work!

[@MikeTholfsen]

Thanks! Glad these are helpful

[@cameronganesh]

Great video thank you for it. Is this on forms premium? I don't have some of your options so I thought maybe it's a premium version. Thank you.

[@MikeTholfsen]

This should be on all versions. Are you using Consumer of Office 365? Also, are you on EDU or Commercial versions?

[@cameronganesh]

@@MikeTholfsen Consumer and commercial version

[@Malcyt99]

I think you need the 100USD per month version to use some of the features that have been shown. For a small business it's to costly.

[@cameronganesh]

@@Malcyt99 thank you very much the help is much appreciated

[@ywonderland3000]

@@MikeTholfsen ا ربي بل سي ل ربي بس ١لب سي ل

[@sreejarathish]

Hi Thanks for this video very helpful. I have a situation i want to redirect a user again to first question once he/she submits the response. Scenario is user can submit it multiple times.

[@susanb1947]

Hi, this was good but didn’t answer my question. I am trying to add a list of options with text boxes beside them. Is this possible? The other option that also does not seem to be available is to have more than one text box under a question. Hoping you can help. Thanks!

[@tridestadez]

Hi Mike, thanks for the tips and trick, I was wondering whether is it possible to make the form as a template? so I am able to use or copy the same template in a different teams channel. thank you very much. looking forward to hearing from you

[@scorneillie1]

Does the Forms information you share about Excel include Office 365 versions? I can't seem to locate it where you indicate.

[@MikeTholfsen]

Excel web should have this built in for Excel 365

[@marialuis6364]

Hi. I need some advice. I have a form with several sections. Each section is to be responded to by different team members. Is that possible? To send each section to different people? Thank U!

[@owkiebokie]

Great tips! I like the tip on inserting form in excel to get real time updates. Is there a way to do that in reverse? To have an existing form and have it integrated in excel, not via download the response in excel.

[@MikeTholfsen]

That is possible in Excel web

[@careertalkwithmohideen]

Can we use the same form link to collect data at different time. Like I want to collect data for customer satisfaction immediately after buying and after 6 months. Will the old data will be saved with the new data.

[@arthurlow7258]

thank you for the video - can you create a fillable table in Microsoft Forms?

[@CyberUrza]

This video was immensely helpful.

[@MikeTholfsen]

Watch next ⏩ Top 25 tips and tricks for Microsoft Forms: kzbin.info/aero/PLdHjJccRYryPeh0rv5HSHPpmQxzd3n0Kt

[@mrcraven8318]

This is awesome - going to make keeping all parts of an assignment/school work in the same place

[@MrDionmar]

Tks a lot, It's possible to pre filled this form? tks

[@sarahahmad8663]

Please confirm if these options will be available only for those using forms through microsoft edge browser or through any browser?

[@MikeTholfsen]

These options are all available through any browser

[@adelinhindorean5978]

First of all thank you for your videos! I am writing to you because I have a problem in Office Forms Writing Equation. The Abc icon dissappeared and now is only an icon fx and an icon with the keyboard. The problem is that now if I want to fill the correct answer I have to do it using Latex language. Do you know the solution to this?

[@miguelseabra8267]

Hi Mike this was really helpful, really appreciate what I have learned from this video. I can't find it on my online 365 excel integration with forms. when I go to Insert I can't find the Forms option, do you know why that can happen? thanks again

[@vbuen323]

Hello, how can I send a survey outside of my organization and see the name and email of whom completed the survey? Currently this feature is only available for internal forms, really need to remove the “anonymous” from the reports. Any help?

[@cgdino7096]

Hi! For instance, my survey question is "Which of the following areas are your company's top 3 priorities?" and I have 6 options, how do I restrict the question such that the respondent will not have mutiple answers for 1 ranking. Previously, I encountered a response choosing 1 for all the six areas in the likert question or answered 1 2 3 1 2 3. Thank you!

[@gabrielferreiraguimaraes2092]

Hey Mike, Its only Forms but no Quiz, Right? I can't get the score from a quiz on automate to update a Sharepoint List. Do you know if its possible?

[@maritessanoza1096]

Thank you for these tips. Can you share how to generate certificates from office form?

[@aakramer]

Is it possible to see a breakdown of points by SECTION in a MS Forms Quiz? In other words, I not only want to see that my student scored 9/10 total, I want to see that she scored 5/5 on section 1 and 4/5 on section 2. Right now I have to look at each student by hand. Thoughts?

[@jinmin3471]

Hello! Can teachers know when the student open Microsoft forms and how long did it take for them to submit their answers?

[@irvincollins6068]

@MikeTholson Is there a way to use Forms as away for internal requisition of items and services?

[@margueritepridgen1492]

Is there a way to have Outlook automatically send the form to people who send you an email with a certain subject line?

[@MikeTholfsen]

That might work with Power Automate

[@saginawmosquito1399]

@@MikeTholfsen Is there a way to notify someone if a specific option/answer was selected? For example the selected answer will notify a specific email address?