Properly Create Surveys with Microsoft Forms & Export to Excel

To sign up for early access to our sponsor, GRID, visit https://grid.is

With Microsoft Forms you can collect data from different people with fillable forms you can control from Excel. With Microsoft Forms you can easily create surveys, quizzes and polls.
You can export the data to Excel to analyze and share the results with your audience. No programming is necessary, no VBA, no add-ons. Just a Microsoft 365 account (free or paid).

We’ll cover how you can use Microsoft forms to add dropdowns, multiple choice, calendar date selection, number checks, net promoter score, and even star ratings.

If you’d like to automatically connect the Excel Form results to your Microsoft Form, you need to use Excel Online. If you’d like to export the Microsoft Form results without an automatic connection, you can create your Form directly from Microsoft Forms. You have access to Microsoft Forms also with a free Microsoft 365 account.

If you’d like to collect data in Excel with a data entry form or a user form, think about using Microsoft Forms instead. It’s the better way of collecting data from different people as long as it’s not lots of data (for example for budget purposes). This works well for surveys, quizzes, polls and information on a smaller scale.


⯆ Read the full article here: https://www.xelplus.com/microsoft-forms

Check out this playlist for more Microsoft 365 videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzpZhCj37RJTyIQBssgM85f

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

00:00 How to Use Microsoft Forms
01:19 How to Get Started with Microsoft Forms
01:50 Automatic Connection between Excel and Microsoft Forms
02:58 Create Data Entry Form with Microsoft Forms
04:10 Star rating in Microsoft Forms
04:35 Choice in Microsoft Forms
05:08 How to add a drop-down to Microsoft Forms
06:10 Date picker with calendar pop-up
06:30 Add a text box and validate numbers
06:50 Add a Likert scale to Microsoft Forms
07:15 Net Promoter score in Microsoft Forms
07:50 How to Add a Theme to Microsoft Forms
08:09 How to Share a Data Entry Form with Microsoft Forms
09:24 How to Fill Out a Data Entry Form
10:34 Analyze the Responses from Microsoft Forms in Excel
13:39 Grid

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

This video was sponsored by Grid.

#MsExcel #Microsoft365