Forms - Check and share your form results Video
In this video, you will learn how to check and share your form results using Microsoft Forms.
The video covers the process of accessing response summary information, exporting results to Microsoft Excel, and managing individual responses.
This will help you analyze your form data more effectively and share it with others.
- 2:42
- 2547 views
-
OneDrive - What is OneDrive ?
- 01:14
- Viewed 2704 times
-
Outlook - Create and modify a group
- 2:19
- Viewed 5748 times
-
OneDrive - Edit, Delete a Share
- 02:16
- Viewed 1743 times
-
Power BI - Introduction to Power Bi
- 1:29
- Viewed 7259 times
-
Teams Premium - Activate the features of Teams Premium
- 3:48
- Viewed 15420 times
-
Teams Premium - Optimize Teams Premium settings in Administration
- 1:27
- Viewed 3317 times
-
Viva Engage - The role of an administrator
- 2:22
- Viewed 5828 times
-
Create a quick poll in Outlook with Microsoft Forms
- 3:38
- Viewed 6586 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 6112 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 5270 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 5270 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 4716 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 4381 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 4068 times
-
Understand the difference between surveys and quizzes in Microsoft Forms
- 1:34
- Viewed 3326 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 3129 times
-
What is Microsoft Forms?
- 1:23
- Viewed 2954 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2929 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2853 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2838 times
-
Introduction to the course on Forms
- 1:23
- Viewed 2595 times
-
Send and collect responses in Microsoft Forms
- 2:25
- Viewed 2572 times
-
Create a new group form or quiz in Microsoft Forms
- 1:38
- Viewed 2529 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 2367 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 2348 times
-
Introduction to the Microsoft Forms home page
- 3:14
- Viewed 2328 times
-
Break up lengthy surveys and quizzes into sections
- 2:24
- Viewed 2222 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 2213 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 2206 times
-
Set up your survey or quiz before sharing it to collect responses
- 3:33
- Viewed 2163 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1933 times
-
Share the link to collaborate or duplicate
- 1:36
- Viewed 1784 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 1237 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 315 times
-
Creating a Report
- 2:54
- Viewed 9379 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4460 times
-
Recovering your Data from different sources
- 3:26
- Viewed 4386 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 4114 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 4053 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 4020 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 3939 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 3772 times
-
Creating your Datasets
- 2:26
- Viewed 3768 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 3754 times
-
Analyze your network and communication habits
- 2:17
- Viewed 3708 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 3707 times
-
Introduction to the Query Editor
- 2:33
- Viewed 3637 times
-
Customising your Visuals
- 2:58
- Viewed 3615 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 3516 times
-
Improved version history
- 0:51
- Viewed 3317 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 3126 times
-
Customising your Report
- 3:12
- Viewed 3070 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2799 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2798 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 2565 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2438 times
-
Manage video settings
- 1:27
- Viewed 2178 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 1630 times
-
Analyze Team Dynamics
- 1:19
- Viewed 1081 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 656 times
-
Process an incoming message
- 01:53
- Viewed 418 times
-
Sort and filter emails
- 02:51
- Viewed 405 times
-
Manage Views
- 02:36
- Viewed 375 times
-
Organize into Folders
- 01:57
- Viewed 370 times
-
Use Categories
- 02:51
- Viewed 324 times
-
Introduction to PowerBI
- 00:60
- Viewed 318 times
-
Clean Up Your Inbox
- 01:18
- Viewed 315 times
-
Easily Sort Your Mails
- 01:38
- Viewed 309 times
-
Create an app from a list
- 01:18
- Viewed 5 times
-
Automate processes with Power Automate
- 01:49
- Viewed 5 times
-
Creating a Power BI report from a list
- 02:01
- Viewed 6 times
-
Using custom views
- 01:52
- Viewed 5 times
-
Exporting your data
- 01:33
- Viewed 4 times
-
Create a calculated column
- 01:38
- Viewed 6 times
-
Highlight your data with conditional formatting
- 00:01:23
- Viewed 5 times
-
Creating different forms
- 01:30
- Viewed 6 times
-
Create a data entry form
- 02:08
- Viewed 6 times
-
Send an email with Power Apps and Outlook
- 05:08
- Viewed 37 times
-
First steps with the patch function
- 04:17
- Viewed 32 times
-
Create dynamic filters with named formulas
- 04:57
- Viewed 33 times
-
Define centralized visibility rules
- 02:28
- Viewed 38 times
-
Dynamic color palette with named formulas
- 03:53
- Viewed 39 times
-
Introduction to named formulas
- 03:45
- Viewed 30 times
-
First steps with variables
- 04:26
- Viewed 30 times
-
Create new entries
- 03:25
- Viewed 27 times
-
Easily edit your data
- 03:27
- Viewed 26 times
-
Add a form to your app
- 02:43
- Viewed 31 times
-
Customize data display
- 03:55
- Viewed 27 times
-
Prepare your dynamic galleries
- 03:27
- Viewed 25 times
-
Reusable components
- 04:16
- Viewed 40 times
-
Structure your layout
- 04:13
- Viewed 29 times
-
Master containers
- 05:48
- Viewed 29 times
-
Optimize large data processing
- 04:43
- Viewed 28 times
-
Galleries : a first look
- 02:59
- Viewed 28 times
-
Add and manage data sources
- 02:58
- Viewed 30 times
-
Controls explained and applied
- 02:41
- Viewed 26 times
-
The Power Apps interface
- 02:35
- Viewed 32 times
-
Why choose Power Apps?
- 01:36
- Viewed 29 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 55 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 52 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 55 times
-
Relevant views to highlight your information
- 01:52
- Viewed 63 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 48 times
-
A well-structured form for easy entry
- 01:17
- Viewed 58 times
-
The right column type for each data set
- 02:35
- Viewed 50 times
-
Custom columns to match your needs
- 02:09
- Viewed 49 times
-
Smooth updates and management for any list
- 01:06
- Viewed 55 times
-
Simple ways to add data to your list
- 01:06
- Viewed 51 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 51 times
-
A fully custom list built from scratch
- 01:34
- Viewed 53 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 56 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 61 times
-
The essentials of the Lists interface
- 02:01
- Viewed 53 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 57 times
-
Introduction to PowerBI
- 00:60
- Viewed 318 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 307 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 299 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 331 times
-
Introduction to Planner
- 00:56
- Viewed 313 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 446 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 315 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 450 times
-
Introduction to Sway
- 01:53
- Viewed 394 times
-
Introducing to Word
- 01:00
- Viewed 311 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 286 times
-
Create a call group
- 01:15
- Viewed 479 times
-
Use call delegation
- 01:07
- Viewed 247 times
-
Assign a delegate for your calls
- 01:08
- Viewed 452 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 271 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 264 times
-
Manage advanced call notifications
- 01:29
- Viewed 263 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 406 times
-
Block unwanted calls
- 01:24
- Viewed 299 times
-
Disable all call forwarding
- 01:09
- Viewed 290 times
-
Manage a call group in Teams
- 02:01
- Viewed 298 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 244 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 256 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 268 times
-
Manage voicemail messages
- 01:55
- Viewed 405 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 446 times
-
Customize your voicemail greeting
- 02:17
- Viewed 246 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 316 times
-
Manage simultaneous calls
- 01:52
- Viewed 282 times
-
Support third-party apps during calls
- 01:53
- Viewed 434 times
-
Add participants quickly and securely
- 01:37
- Viewed 266 times
-
Configure call privacy and security settings
- 02:51
- Viewed 263 times
-
Manage calls on hold
- 01:20
- Viewed 260 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 269 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 257 times
Objectifs :
This document aims to provide a comprehensive overview of how to utilize Microsoft Forms for analyzing survey responses, including accessing summary information, exporting data to Excel, and managing individual responses.
Chapitres :
-
Introduction to Microsoft Forms Analytics
Microsoft Forms offers robust real-time analytics that allow users to gather and analyze response data from surveys and various forms. This functionality is essential for understanding participant feedback and improving future surveys. -
Accessing Response Summary Information
To view the summary information for your form, navigate to the Responses tab. Here, you will find key metrics such as: - Total number of responses - Average completion time - Current status of the form (active or closed) This data provides a quick overview of how your form is performing. -
Viewing Individual Responses
For a detailed look at individual responses, select 'View Results.' This section displays: - Respondent ID - Respondent name - Execution time - Breakdown of responses You can navigate through different responses using the left and right arrows or jump to a specific respondent using the dropdown list. Additionally, you can search for a specific response by entering the respondent number. -
Managing Responses
In the Responses tab, you have several options to manage your data: - Delete all responses - Print a summary of responses - Create a summary link to share with others These options help streamline the management of your survey data. -
Exporting Data to Microsoft Excel
To conduct a more in-depth analysis, you can export your response data to Microsoft Excel. Simply select 'Open in Excel' to capture a snapshot of your current response data in a workbook. In Excel, you can view: - Number of responses for each question - Charts that illustrate response breakdowns For a focused analysis on a single question, click the more detailed link under Individual questions to see each respondent's answers. -
Handling File Uploads
If your form includes a file upload field, you can view the number of submissions and a summary by clicking on 'More Details.' This section allows you to access all responses related to that specific question. Additionally, you can click the link to open any uploaded documents or view all receipt documents in the automatically created OneDrive folder for your form. The documents are renamed to include the respondent's name, ensuring easy identification. -
Conclusion
In summary, Microsoft Forms provides a comprehensive suite of tools for analyzing and managing survey responses. By utilizing the analytics features, exporting data to Excel, and effectively managing individual responses, users can gain valuable insights and enhance their data collection processes.
FAQ :
What is Microsoft Forms used for?
Microsoft Forms is used to create surveys, quizzes, and polls, allowing users to collect and analyze responses in real-time.
How can I view the summary of responses in Microsoft Forms?
To view the summary of responses, select the 'Responses' tab in your form. This will display metrics such as the number of responses and average completion time.
Can I export my form responses to Excel?
Yes, you can export your form responses to Microsoft Excel by selecting 'Open in Excel' to capture a snapshot of your current response data.
How do I delete responses in Microsoft Forms?
To delete responses, select 'More options' in the Responses tab and choose the option to delete all responses.
What should I do if I want to view individual responses?
Select 'View Results' in the Responses tab to see individual details for each respondent, including their ID, name, and execution time.
How can I share my form results with others?
You can create a summary link to share with others by selecting 'More options' and then choosing the option to create a summary link.
Quelques cas d'usages :
Conducting Employee Satisfaction Surveys
HR departments can use Microsoft Forms to create employee satisfaction surveys, collect responses, and analyze the data to improve workplace conditions. By exporting the results to Excel, HR can identify trends and areas for improvement.
Collecting Feedback for Events
Event organizers can use Microsoft Forms to gather feedback from attendees after an event. The real-time analytics feature allows them to quickly assess the success of the event and make necessary adjustments for future events.
Educational Quizzes and Assessments
Teachers can create quizzes using Microsoft Forms to assess student understanding. The ability to view individual responses helps educators provide targeted feedback and support to students based on their performance.
Market Research Surveys
Marketing teams can utilize Microsoft Forms to conduct market research surveys. By analyzing the collected data, they can gain insights into customer preferences and behaviors, which can inform product development and marketing strategies.
Event Registration Forms
Organizations can create registration forms for events using Microsoft Forms. The collected data can be exported to Excel for tracking attendance and managing event logistics efficiently.
Glossaire :
Microsoft Forms
A web-based application that allows users to create surveys, quizzes, and polls, and collect responses in real-time.
Real-time analytics
The ability to analyze data as it is collected, providing immediate insights into responses and trends.
Response summary
A consolidated view of the data collected from respondents, including metrics such as the number of responses and average completion time.
Export
The process of transferring data from Microsoft Forms to another application, such as Microsoft Excel, for further analysis.
Respondent
An individual who answers questions in a survey or form.
ID
A unique identifier assigned to each respondent for tracking their responses.
OneDrive
A cloud storage service from Microsoft that allows users to store files and access them from any device.
Upload file field
A type of question in a form that allows respondents to submit files as part of their response.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise