How to Use Microsoft Forms at Work

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@CarnivoreRonin]

I'm a university professor and I share your videos in my Data Analytics classes frequently. I'm going to be using this functionality for quizzes in the fall in the IT Project Management class I'm teaching.

[@abufun1718]

Is this possible to collect all the participants data in one Excel sheet from forms?

[@CarnivoreRonin]

@@abufun1718 Yes, that is what I do for several of my classes.

[@robmedinaXXI]

Leila, this video was incredibly insightful! Your step-by-step guide on creating surveys, quizzes, and polls was practical and easy to follow. I particularly appreciated your demonstration on how to review responses, which will be invaluable in understanding feedback and results. Your ability to simplify complex features into understandable segments is truly commendable. Looking forward to more such informative content. Do you have a video that directly compares Google Forms vs Microsoft Forms? It would be great to see a detailed comparison of features, use-cases, and the pros and cons of each platform. Looking forward to more of your informative content!

[@asal7826]

Thank you Leila, I really appreciate your videos and learned many things from them. I have a request, please, make more videos for Accounting.

[@LuisCarlosChavez717]

Hi Leila, thank you for your informative video on Forms. I work for a company that needs to create a survey and a quiz in-house. Your video was very helpful, and I learned a lot from it. I look forward to watching more videos from you on this topic.

[@andeieblahandiee]

Survey! I have been using Forms for a year and it has been very useful! Only thing I wish it had was a limit on the number of responses per survey, like Google Forms. It would have then been a perfect application for rolling out course enrollment (limiting the responses to the class size).

[@chh8860]

I do not have an immediate need for "Forms", but always so glad when Leila brings these capabilities to my attention ... thank you ... thank you ... thank you. PS At the 3:15 mark, Leila asks; " What is your favorite day of the week?" Easy ... Thursdays at 5:00AM (USA - EST) ... 'Coffee with Leila' on KZbin ... 😍😍 ...😉

[@LeilaGharani]

Don't forget the cake, Chris 😊 Thanks for watching!

[@chh8860]

@@LeilaGharani 😂🤣🤣😂😂

[@bbashur]

Thank you, Leila, for the professional presentation. It is easy to follow, and I felt I could use the Ms Forms to collect information immediately! Greeting from Vienna.

[@anthonygikuri]

Thank you Leila for another powerful video. I can see the power of AI into this product of Microsoft. I see a lot of changes compared to the form I have been used to. Many might agree with me that Google Form has always dominated this field but now Google must react quickly before it is too late.

[@GerhardHolzer911]

Very informative as always 🎉 I use Forms also for registration to internal events, combined with MS Lists and Power Automate (automatic confirmation, having the list as a source for certificates etc.)

[@aicnedvasquez]

Hello Leila! Just in time! I've been planning version 2.0 of selling system and was wondering about the number of responses. MS Forms is a workaround for Lists which can't calculate a Lookup column. Thank you once again!

[@elainev670]

Survey! I need to create a form to the conference rooms of my office. This is great!

[@venkataravindragadamsetti2796]

Thank you for your informative videos on using Microsoft Forms! I have a specific question regarding Microsoft Forms: I need to create a demographic 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

[@ericp7129]

Hi Leila, I stumbled on your video today and thank you, I’ve managed to create a survey form for my organisation. I’m using a free Microsoft account. How many responses can I generate? Thank you so much

[@xlwatcher8885]

thank you for the amazing vid! I didn't quite see how the quiz designer find the data to tabulate and summarize after quiz responses are in? In an XL spreadsheet? Where is that set up to receive the answers? thanks

[@bangjamz]

Thanks for the video. I like microsoft forms because the layout is beautiful, but I don’t use it because its major drawback is the inability to install add-on such as import quiz from other platform (i.e word, excelc etc), and other useful capabilities that ms forms lacks that could be overcome with addons.

[@barteczekz]

Thank you for covering this. Do you know if it is possible to create a survey using a shared mailbox? This way answers wouldn't be tied to a personal account.

[@Tabernash21]

So much fun!! I don't know which to use first.

[@LeilaGharani]

Glad you like it, Julie!

[@chrism9037]

I don't use Forms that often but these are great tips, thanks Leila!

[@yerbolabzhamiyev3268]

Dear Leila, I hope this message finds you well. I wanted to take a moment to express my gratitude for the wonderful video you recently shared. It was truly informative and engaging, and I thoroughly enjoyed it. I have a question regarding the utilization of forms for tracking material request placement from employees within my company. I was wondering if you might have any suggestions or insights on how forms could effectively be employed for this purpose. Your expertise and feedback would be greatly appreciated. Thank you in advance for your time and consideration. Warm regards,

[@keithmcgee1253]

I actually use it for capturing production data, quality data and training information as well

[@LeilaGharani]

👍

[@nemalconsashutosh8665]

Hello Leila, I'm Ashutosh from India. Love your videos. I am a career counsellor and wish to your Microsoft Forms for personality assessments. But the assessment results will differ based on the responses of the candidates. How can I do that? Remember there are no wrong answers in the assessment.

[@learningisbliss1143]

Actually, my plans are to use it for a different purpose than any of the three you mentioned. I am working in a support team, and we have three different ticket systems, from which we need to collect data regarding things like, what was the origin of the ticket, which part of the world, which zip code, what topic, who handled the ticket, how long did it take to solve, was it easy, moderately difficult, or very difficult to solve, what is the short and clear statement of the problem, what was the solution, etc. Then we want to collect this data to use as indexed data for presenting to the software developers, business associates, etc., and for use by chatbots, and other uses. What would be a good way to set this up?

[@lehnerk]

Great vid, thank you. We are already using forms in our company and last week I got the question, where the collected data is stored. Obviously not in SharePoint or OneDrive. Somewhere else in pur M365-Tenant?

[@hansklein3649]

I would take all 3 of them, filling out forms is the easiest way to say yes to your business.

[@LeilaGharani]

True, they can really be useful.

[@alexaguilar7124]

Hello! I own a dump truck businesses, could I use “Forms” as a daily sheet input data tool? So that my drivers can input their daily deliveries for me to then later look at all data in Excel? I would really appreciate if you could help me answer these questions. Thank you, and I love your videos by the way. 😄

[@renoy320]

Can you please share a video. How we can set up limit response in Ms Forms.

[@maytenauk]

super interesting, as usual!! just wondering is there any way to know whether somenone has clicked in the link of a form once sent , but never submitted any answer...

[@blazen138]

Can you provide a video detailing the new Forms option within Microsoft Lists? Previously I was using PowerAutomate to generate a SharePoint List from Forms. This new feature seems to cut out the middleman.

[@PaschalisTsi]

A great video,... again! Although I am a fun of Forms, it sometimes does not perform as supposed to. We recently had a live conference at the company and at the end of it we would like the participants to vote end express their opinion on that did they think about the symposium. Target was to share and present the data live so a PowerPoint was created that was drawing the data from the Excel file of the Forms. That DID NOT work and it was a big disappointment for everybody. The embedded charts were not updated and it seems that it is a known issue for Forms. Oh well, maybe MS will work on the subject and get to the same level as other solutions are already!

[@ΣπύροςΗλιάκης]

Can you create a quiz for an excel problem? Perhaps have an attachment that the candidate needs to download, edit, and upload with his answer. Can that be done in forms?

[@kaplanjason]

what a great video - thanks for creating.

[@petroswheels]

Is there any way to assign negative points to answers? It would greatly help with building out a scorecard.

[@ayamuhed7085]

HI Laila, can't have two questions or spaces side by side rather than having all odrdered ordered vertically ?

[@mjb48219]

Please do a video on ways to use Microsoft Lists or Forms along with Power Automate and SQL Server to replace the dreaded & problematic Microsoft Access databases scattered across many organizations.

[@ericbremiller9531]

Can you use Forms to create a data entry template. Something that could be filled out daily to record, for example, information about the weather. And then be able to aggregate all those daily entries in a single table.

[@jordanrouden6440]

It absolutely can!

[@greenmountainsuiteshotel1294]

Hello, is there a way to save Form Surveys as a link or shortcut that can be used multiple times by the same individual?

[@AlabaUmukoro]

Great work ma. I am sorry this comment is not related to this video. I had to post it here to get your attention since the video is freshly published. Today is the 24th day since I started using PowerApps. I am learning and creating an app through which a team reports the number of items they sell daily. Each team member's monthly sales target is benchmarked at 45. I am currently stuck since my 19th day trying to figure out how to calculate each team member's 'rank' in their performance reports screen. I would easily use the RANK.EQ function in Excel but I don't know how to go about it in PowerApps. Please help me out ma.

[@winstonward5772]

Leila, please help me. I do not have access to premium features in Microsoft flow but is it possible to create a flow that will fill a word template from a submitted form? totally wracking my mind on this lol. Thank you

[@CraftyAliConfessions]

OMG, was just looking at this today, and put it aside to look at later…..I think later has just arrived……my colleague and I were looking at trying to create a survey….question….can I do this in the Teams App, instead of logging in via the internet?

[@jonjon2645]

Thanks for sharing

[@dawnp1402]

Any suggestions for a registration form that needs conditions? I’ve looked at jot form, but not sure if Microsoft has something similar. Thanks

[@SwissPGO]

Microsoft seems to try to catch up with google forms. Is is possible to have questions present answers dynamically? I used this with google form (and some custom javascript functions) to have a set of choices come from previous form entries. This is quite powerful to have your form questionnaire adapt dynamically as answers start flowing in.

[@loud0iris]

I hope MS can come up with something similar to mentimeter that can be integrated with ppt. Or is there an add in already?

[@humansizedaperture]

Sounds awesome!

[@leo0619]

it's good, How to connect forms data to power BI and share point

[@TechnicalTrainer-re6dm]

Hello Leila! I got a question for you, I would like to create a quiz with several questions for example 20 questions but at the moment to fill the quiz, I want to Microsoft form select 10 questions randomly every single time. ¿This could be possible?

[@TechnicalTrainer-re6dm]

@LeilaGharni

[@دروسالمحاسبةوالمراجعة]

Thanks, I love it

[@divyaalok5538]

जय गणेश

[@joselin4753]

Hey leyla Is there any way we can create webpage using html and use SharePoint as backend??

[@kvlpnd]

3:20, That's harsh removing Sunday as favourite day... 😂😂

[@LeilaGharani]

😂

[@donandnancyfinch2062]

I'd love to know how I can use Forms to create a "survey" which offers possible meeting times, and the recipient of the form selects a choice. When a possible meeting times hits 5 yes responses, I'd like it to block others from choosing it. The goal is to fill blocks of time with no more than 5 people, and hopefully fill up as many of the choices as possible. For example, we send to 40 people with 10 time choices, and I get several times filled up with 5 responses. I'd also like to offer that it be added to their calendar. Possible?

[@mustafaemrecam]

Leila it is amazing thank you

[@HiHi-kc1ef]

Can we use it as expenses claim forms?

[@mikedonaldson8898]

When I access Forms in the web based version of Office, there are no templates shown. In what manner are you accessing Forms to see templates?

[@fernandamejia-salazar]

Survey! With a unique ID generated fro each completed survey

[@divyaalok5538]

जय संतोषी माता

[@JuanAguilar-Cardon]

Is there a way to create a complex, graphical form on a single page (similar to a paper or Adobe form) that can be shared publicly and automatically collects and inputs data into an Excel file upon clicking a "Submit" button?

[@divyaalok5538]

जय रिध्दि सिध्दि

[@msajithabegum]

Product promo form to embed in email newsletter

[@divyaalok5538]

जय शुभ लाभ

[@ignacioamezquita2704]

Hello I just deleted I few response but the analytics from the form is not updating it self any fix on this ? Please and thank you

[@ladyboerd]

Why can I not give triple thumbs ups?

[@pauljohnson842]

Amazing thumbnail. :)

[@berndeckenfels]

Just created a Teams Poll

[@LeilaGharani]

Yay!

[@janinegarber8355]

It seems like the type of questions (text, drop down, etc) doesn't seem as robust as a paid forms program like JotForm. Am I missing some functionality?

[@lorimiller623]

You can set form answers to text, date pickers, number only, radio buttons, checkboxes, and required fields. Not sure if drop downs are needed if you have radio buttons.

[@michaell7877]

Queation. Got your reply. Would you make, like a normal 1 minute dark mode video. Let your subscribers comment on what they think? Blame it on me for the request Lol. LMBO. Always love your vids when I can see them. Hope to see that short Vid……Michael. 😇

[@dheandrew]

Unfortunately, file upload doesnot allow collect data outside organisation :(

[@Pete.C]

Sorry, which method of Forms use is for recruiting in your video?

[@LeilaGharani]

The quiz.

[@neilgoodman2885]

10-Q. No time to write, got home work to do. Respectfully & warmly, NHG

[@malaninyirenda1190]

Survey

[@annan9752]

Quiz

[@brenthair1228]

poll

[@PaulLongva]

Survey.

[@pankajpundir2323]

Hello madam,

[@RogerStocker]

I guess Poll

[@saamaanhoobahfekr9753]

کاشکی یکم ایرانی هم صحبت کنی ...

[@administrativeofficerdutycalls]

Hie, I need your help on Excel formulas. Do you have an email address.