Top 25 Microsoft Forms tips and tricks

Рет қаралды 850,835

Күн бұрын

A step-by-step Forms tutorial on my top 25 Microsoft Forms tips and tricks. This shows Microsoft Forms features you might not know about, new Forms features, and some MS Forms advanced features. These Microsoft Forms tips are useful for educators, business people, or anyone else looking to up their game on MS Forms. This also includes Forms integration with Outlook, Microsoft Teams, OneNote, PowerPoint and Stream.
✅ Microsoft Forms Help and Support: support.microsoft.com/en-us/f...
📺 My Microsoft Forms playlist: • Microsoft Teams quick ...
📝 Table of contents
0:00 Introduction
0:20 New MS Forms Home page Layout
1:05 Tile view vs. Table View
1:20 Likert question type
2:28 NPS (Net Promoter Score) question type
2:52 Sections in Microsoft Forms
4:06 Improved Themes with Forms "Ideas"
4:35 Branching in Forms
6:05 Upload a File when answering question
7:31 Immersive Reader in Forms
9:09 Math Keyboard in Forms
10:39 Print a Form and Print Forms Summary
11:22 Shuffle Forms questions
12:04 Set start date/time or end date/time
12:47 Get a link to the summary of MS Forms responses
13:32 Customized message at the end of your Form
13:53 Duplicate a Form (Make your own copy)
15:07 Share or collaborate on a Form
16:12 Multilingual Forms
17.21 Outlook quick polls with Microsoft Forms
18:31 Excel integration with Microsoft Forms
20:04 Microsoft Teams integration with Microsoft Forms
21:00 OneNote integration with Microsoft Forms
22:24 PowerPoint integration with Microsoft Forms
23:13 Stream integration with Microsoft Forms
I am always creating more quick tip Microsoft Forms teacher tutorials, so let me know in the comments about other features you'd like to see videos for.
🔔 Subscribe to my Channel: aka.ms/MikeKZfaqSubscribe
*Connect with me on Social:
Twitter: / mtholfsen
LinkedIn: / miketholfsen
Instagram: / mtholfsen
Pinterest: / miketholfsen
TikTok: / mtholfsen
Wakelet: www.wakelet.com/@mtholfsen
*Distance Learning Resources:
Microsoft EDU Remote site: www.microsoft.com/en-us/educa...
Teams EDU Quick Start Guide: aka.ms/TeamsEDUQuickGuide
Webinar series: aka.ms/RemoteLearningPlaylist
Resource, training and tips collection: aka.ms/RemoteLearningWakelet

Пікірлер: 379

@MrHamzaakhan 3 жыл бұрын

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 3 жыл бұрын

Gs was helpful. Hope your summit goes well!

@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!

@anthonygikuri 3 ай бұрын

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!!!

@tindikamwetu2134 3 жыл бұрын

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 3 жыл бұрын

Glad it was helpful

@tarakinsell6202 2 жыл бұрын

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!!!!!!

@lynettenaidoo5008 2 жыл бұрын

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

@manokejason 3 жыл бұрын

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

@loriwaggoner7129 10 ай бұрын

Excellent. Quick, clear, highly informative!

@florpicon7035 Жыл бұрын

Super helpful and straight to the point. Thanks!

@mrcraven8318 3 жыл бұрын

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

@pattyjones8397 Жыл бұрын

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

@MikeTholfsen Жыл бұрын

Glad it was helpful!

@MikeTholfsen 3 жыл бұрын

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

@itucsok 9 ай бұрын

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

@vijayarjunwadkar 3 жыл бұрын

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

@MikeTholfsen 3 жыл бұрын

Great, glad to hear that!

@kvdp1805 3 жыл бұрын

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

@MikeTholfsen 3 жыл бұрын

Thanks! Glad these are helpful

@diyhell8712 2 жыл бұрын

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 2 жыл бұрын

Awesome, thank you!

@itsglinnfon8490 2 жыл бұрын

Thanks for all the advice ❤️ I learned a lot of from this video ☺️❤️

@isagerl8603 Жыл бұрын

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

@deltons1000 8 ай бұрын

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

@MikeTholfsen 8 ай бұрын

Glad it helped!

@hazokichan2843 5 ай бұрын

That was beneficial! Thank you 🙏🏻

@Mariam-vz4bv 3 жыл бұрын

Very informative. Thank you for sharing.

@johnchiappetta3933 3 жыл бұрын

MIke, AWESOME tutorial on MS Forms!!!

@MikeTholfsen 3 жыл бұрын

Glad you like it!

@rosinator6740 Жыл бұрын

superhelpful video! Thanks a lot 👍

@katiebriggs8413 3 жыл бұрын

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.

@stanleyds 2 жыл бұрын

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

@MJBRidge 3 жыл бұрын

very useful and comprehensive. Nice job!

@MikeTholfsen 3 жыл бұрын

Thank you!

@kathrynhall2019 2 жыл бұрын

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

@MikeTholfsen 2 жыл бұрын

So glad!

@pollylee118 Жыл бұрын

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

@MikeTholfsen Жыл бұрын

Glad it was helpful!

@adrivianna5282 2 жыл бұрын

This video is very helpful. Thanks for sharing

@mowburnt 3 жыл бұрын

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 3 жыл бұрын

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

@jennifervitug1494 3 жыл бұрын

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

@MikeTholfsen 3 жыл бұрын

Great, thanks for sharing!

@anniesebmuged7960 3 жыл бұрын

My account Annie sebmuged

@superbchops 2 жыл бұрын

Excellent film. Widely informative and told concisely. This is must-watch recommendation, as I try to explain the benefits of M365 to a cautious, recently introduced workforce. Thank you Mike.

@lovasatesz 2 жыл бұрын

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 2 жыл бұрын

Glad it was useful

@AshleyBrown-hs9fj 3 жыл бұрын

Another great Video! Your tips keep making me look like a O365 Jedi to my colleagues!! lol

@MikeTholfsen 3 жыл бұрын

"May the Forms be with you" 🔮

@finn5905 11 ай бұрын

Thanks for the tips. Very helpful!

@MikeTholfsen 11 ай бұрын

Glad it was helpful!

@CyberUrza 11 ай бұрын

This video was immensely helpful.

@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?

@briananurse7818 3 жыл бұрын

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

@kiranp551 Жыл бұрын

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

@isobelgowers4684 3 жыл бұрын

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 2 жыл бұрын

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

@christopherraeperez3122 2 жыл бұрын

Very helpful. thanks a lot. :)

@BrockLeonard 6 ай бұрын

thanks for your help mike!

@anmir 2 жыл бұрын

A great video. Thank you.👍😀

@faithsubbu 3 жыл бұрын

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??

@denisekobrin9338 3 жыл бұрын

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!

@johnheck1551 2 жыл бұрын

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?

@StevenMeert 2 жыл бұрын

Thank you ! really helpfull !

@tamilselvan1990j 2 жыл бұрын

Awesome help thank you..

@QDWorld-SwiftUI 2 жыл бұрын

It’s very informative thank you

@ebenjamin24 3 жыл бұрын

Super cool video Mike! Thank you!

@MikeTholfsen 3 жыл бұрын

Glad you liked it!

@jayenriquez5653 3 жыл бұрын

Thank you for this video.

@huyenanhnguyen6348 2 жыл бұрын

thanks Mike, such a helpful video

@MikeTholfsen 2 жыл бұрын

Glad it was helpful!

@chanthawans.9516 2 жыл бұрын

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

@tridestadez 2 жыл бұрын

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

@gopalakrishnaa14 3 жыл бұрын

Excellent video !!!!

@ilmadennislara5332 3 жыл бұрын

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 3 жыл бұрын

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

@crystalbeamer7315 2 жыл бұрын

Great video! I was wondering if you knew if there are any plans to offer the capability of creating signup sheets in forms? For example if I have 4 essay topics and 60 students and I’d like to have them sign up to choose their essay topic, but only allow a max of 20 students per topic. I can do this in Google forms by downloading an add on, but my institution uses office 365 now, so I’d like to use ms forms if at all possible.

@mrkhalidhafeth5823 3 жыл бұрын

Excellent informative tutorial!

@MikeTholfsen 3 жыл бұрын

Glad you enjoyed it!

@williammaroon932 2 жыл бұрын

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 2 жыл бұрын

I use Camtasia

@davideduaidconceptdeac6620 3 жыл бұрын

Great. Kudos!

@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

@aylonsamson4397 2 жыл бұрын

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 2 жыл бұрын

Unfortunately that is not currently supported

@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

@YukariBromfield 3 жыл бұрын

Thank you! I learned a lot! I really love the tip about inserting forms in Stream video! One of courses I teach is Geometry and it would be nice to see more math symbols added to Forms. Also, will we be able to attach a picture as one of the responses in a multiple choice? Thank you for all that you do to make online learning interactive and meaningful! Also will we be able embed Geogebra in OneNote for Windows app? Thank you!

@MikeTholfsen 3 жыл бұрын

Does Geogebra currently not work in the OneNote Windows 10 app? It should embed fine...

@YukariBromfield 3 жыл бұрын

Mike Tholfsen I had old info. Thank you! I just checked my OneNote app and the the link is embedded.

@sathyanarayananswaminathan6860 3 жыл бұрын

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.

@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

@Fudders Жыл бұрын

Thanks Mike, very helpful 👍 BTW, to show I was paying attention in class, I doubt you'll get any takers for "Buger" Heaven as a lunch venue! 🤢😄

@jessicacolley7580 18 күн бұрын

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.

@miguelseabra8267 2 жыл бұрын

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

@thayayogam 5 ай бұрын

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.

@letmebefrnk 2 жыл бұрын

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

@MikeTholfsen 2 жыл бұрын

Yup. All possible with Immersive Reader

@owkiebokie 3 жыл бұрын

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 3 жыл бұрын

That is possible in Excel web

@fasihurrehman2502 Жыл бұрын

Thankyou so much

@faisalaloshari 2 жыл бұрын

very helpful .. thanks.

@MikeTholfsen 2 жыл бұрын

You're welcome!

@lenschendel3425 3 жыл бұрын

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

@MikeTholfsen 3 жыл бұрын

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

@dawnasharples 3 жыл бұрын

Great video thank you. Is it possible to create a form that students can complete in 2 stages, I'm thinking of a learning plan. Thank you

@keningilbert 3 жыл бұрын

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 2 жыл бұрын

It is stored in the Forms backend

@keningilbert 2 жыл бұрын

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

@Snowboardgal77 3 жыл бұрын

this is amazing

@shahbanabhatti8926 2 жыл бұрын

Hi Mike, great tips! I have to create a voting form but want to limit the number of votes people can submit, is that possible? So for example I have 10 nominations but employees can only select 3. At the moment I am unable to restrict this, so I have to go through the submissions manually to make sure employees are not voting more than 3 or 4 times. thanks!

@sarahahmad8663 3 жыл бұрын

Thanks for sharing

@MikeTholfsen 3 жыл бұрын

Sure, hope it was helpful!

@babysaho9576 3 жыл бұрын

Great tips, thanks. #22 didn't work for me though. I created the question and all it did was show me a preview of what the form would look like. It never appeared in the channel when l sent it though...😟 Does it only work in the General channel? It would be useful to use in individual subject channels...

@AndaSukanda99 3 жыл бұрын

Terimakasih informasi barunya

@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

@arthurlow7258 11 күн бұрын

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

@HippiMikki 2 жыл бұрын

Hi, I added a Choice question using colours as the first word to describe a level of difficulty. For the results on the responses tab, I want it to show the matching colour to the rating (Red, Green, Blue, Amber, Black). I would like these colours to show in the Pie Chart to depicting the percentage of respondents for each colour. Any ideas on how this might be achieved? Note, after I put the colour I add a dash and further explain it's intent. For instance, Black - difficult terrain.

@phloem4 Жыл бұрын

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

@francescobagella1910 2 жыл бұрын

Thanks for all the advice 👍! In tips number 8 ( upload a file) I haven't this option in my Forms.. Could you explain why?

@tamararufener9729 3 ай бұрын

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.

@janestearns9936 2 жыл бұрын

Really helpful - thank you from New Zealand :)

@MikeTholfsen 2 жыл бұрын

Glad it was helpful!

@Tiffany-RemoteOfficeGirl 2 ай бұрын

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.

@Smart.Ventures Жыл бұрын

Great video and love all the tips. As of this day(07/04/23) the file upload option does not appear new question anymore😒

@marthazarate1040 2 жыл бұрын

I’m new at MS Forms and your tutorials have been super helpful. I have a question. I’m developing a survey in MS Forms and my questions have two scales: Importance and Frequency other questions have scales of: Importance, Expected at Entry Relationship to Job Performance Each of those scales have different responses. So my question is how do I set these scales up under each question? Is there a tutorial on this specific question? I hope you can assist me with question. Thank you

@darrenseggie2084 2 жыл бұрын

Quick question. Is there a way of creating a form with multiple sections, all to be completed and feedback given at different times, rather than having to complete the whole form? For example if I wanted someone to fill in a different section of the form each week and receive continuous feedback each week? Or would I simply have to create a form for each week?

@maritessanoza1096 Жыл бұрын

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

@fatimaros1827 2 жыл бұрын

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

@user-dk8ge6fx9o 3 жыл бұрын

1000 thanks

@simons2353 2 жыл бұрын

This is a great video - thanks Mike. However, I'd like to know how someone can print their completed form after/just before submitting it. If I do Ctrl+P at the end, to create a pdf, it just creates one page. Is it possible to save the whole of the completed form as a pdf please. Simon

@knowgovt 7 ай бұрын

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?

@tylercraft5780 3 жыл бұрын

great video! Do you know how to search or sort my forms or group forms now that they have changed the interface?

@MikeTholfsen 3 жыл бұрын

That is coming back soon, probably 2 months

@jamesolojo787 3 жыл бұрын

Forms is a hidden gold nugget for Teachers

@MikeTholfsen 3 жыл бұрын

Agree, it's awesome!

@adelespringer294 2 жыл бұрын

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 2 жыл бұрын

Not at this time

@adelespringer294 2 жыл бұрын

@@MikeTholfsen Thank you for your response.