Leila Gharani shows us how to use Microsoft Forms you can collect data from different people via fillable forms that 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.
- 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