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

This video is your guide to creating and using Microsoft Forms for data collection and analysis. 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).

Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

‍ What You'll Discover:
▪️ Ease of Use: Learn how Microsoft Forms simplifies data collection from surveys to feedback forms, all without any programming.
▪️ Versatile Form Elements: Explore how to include various elements like drop-downs, multiple choice, calendar dates, number checks, and even star ratings in your forms.
▪️ Seamless Excel Integration: Understand how to control and analyze your form data directly in Excel, especially if you have a Microsoft 365 account.
▪️ Form Creation Walkthrough: Follow a step-by-step guide to creating your first form, including tips on adding questions, choosing question types, and customizing your form.

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

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

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

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

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

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.

#excel #Microsoft365