The app was originally made available to Office 365 Education license subscribers, but Microsoft recently expanded its availability to Office 365 Commercial subscribers (as a preview initially). Forms are replacing the Online Survey feature previously offered in Excel Online, which I've written about before.
Microsoft Forms also has you covered after people respond, via real time data collection. After collecting the data, you can analyze the results using Excel’s built-in filters or create a separate PivotTable report.
I will walk you step-by-step through the process of creating and sending a Form and give you a look at how the results come in. You can watch the video, and/or read on for written directions.
1. The first step is to login to your Microsoft Office 365 account.
2. Click on the Forms app.
3. Click on the New Form or New Quiz button to get started. I will be creating a New Form to get feedback regarding customers' experience while visiting one of our locations.
4. Enter in a title name for your form (can contain up to 90 characters).
5. Enter in a subtitle (this is optional, and can contain up to 1000 characters).
6. Click the Insert Image button to add a picture to your form (this is optional).
7. Click on the + Add question button to add your first question.
8. Choose from one of the following question types (choice, text, rating, and date).
9. To enter in a date field, click on the Date icon (you can require the question to be answered, add a subtitle, add an image, delete the question, or move the question up or down).
10. To enter in a drop-down list, click on the + Add question button and choose the Choice button (There will be two default options which can be deleted or changed. Additional options can also be added, answers can be shuffled, and you can allow users to check multiple answers).
11. To enter in a Ratings field, click on the + Add question button and choose Rating (you can choose from different levels and symbols).
12. Enter in your question and subtitle (the subtitle provides users with what the numbers or star symbols represent).
13. To create a comments field, click on the + Add question button and choose Text (look for the … symbol to set restrictions).
Using Microsoft Forms, you have two different previews options: computer and mobile.
14. Click on the eye icon to preview your form. (You can also select from one of the stock themes or you can upload your own image to add a splash of color to your form.)
15. Click on the arrow to return to the form.
Before sharing your form, you will want to view the settings options to decide on who can respond, start and end dates, and whether to display the person’s name or make the form anonymous. By default, only people within your organization can respond.
16. Make the necessary setting changes then click the Share button.
There are many options on how to share the form with others. You can copy/paste the link, send a QR-code, embed the form into a blog or webpage, or send the link in an email.
17. Click on the email icon located under the Share button.
18. Right click on the link and choose Edit link (this is an optional step).
19. Change the Text to display, then click Apply.
20. Add the recipients to the email message form and click send.
21. Click on the sent link (depending on how the form was setup will determine whether people will need to log into their Office 365 account).
22. Fill out the form and click Submit (responses are sent back immediately to review).
23. Login to your Office 365 account, click on Microsoft Forms, and click on your stored form.
24. Click on the Responses tab.
Here you will be able to view rich, real-time analytics providing you will individual results as well as summary information. You can even open your results into Microsoft Excel for additional data analysis. Printing and deleting options are located under the ellipses (…).
25. Click on the Open in Excel icon.
26. Your data is now exported into an Excel table (use the filters to only view specific records).
27. Save the Excel file before closing.
That is all there is to it. Give it a try and let us know how you did.
| Focus on the Office 365 Features That Matter Most to Your Company | Learn Excel Online and Step up to New Responsibilities | Software Training Online: 90-Minute Classes |