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
Time Stamps
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
Видео Properly Create Surveys with Microsoft Forms & Export to Excel канала Leila Gharani
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
Time Stamps
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
Видео Properly Create Surveys with Microsoft Forms & Export to Excel канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Top 25 Microsoft Forms tips and tricks for 2021 // New features, hidden gems & Office integrationCreating Easy Data Entry Forms in ExcelHow to Create & Use Excel Macros (Real world example)Use Excel & Power Automate | Record Working Hours from Phone & Update LinkedIn from Excel!Excel LAMBDA - HOW & WHEN you Should use itAdvanced Pivot Table Techniques (to achieve more in Excel)How to Capture Form Responses in an email with FlowHow to use Microsoft FormsHow To Mine Ethereum & Make Money 2021 Tutorial! (Setup In 10 Minutes Guide)How to Use Power Apps | Get Started with THIS Tutorial & Create your 1st appEasy Excel Forms - No VBA & access from any device!Microsoft Forms | 9 new features for 2021How to Use OneNote Effectively (Stay organized with little effort!)How to Create Fillable Forms in Excel - Employee Engagement Survey TemplateMicrosoft Forms TutorialPower Automate Microsoft Forms Connector tutorial with AttachmentsLearn to Use Power Automate with Examples | Create Bulk PDF Files | Planner to OutlookBranching and sections in Microsoft Forms by Chris MenardHow to use Microsoft Access - Beginner Tutorial