Forms - Create a Microsoft Forms form directly in OneDrive Tutorial

In this video, you will learn about Microsoft 365 and its features.
The video covers how Office apps like Word, Excel, and PowerPoint can help you and your team be creative and work together securely.
You will also learn how to save your files in the cloud with OneDrive, allowing you to access them from anywhere.
The video demonstrates how you can store any type of file, including images, spreadsheets, and presentations, and share and collaborate in real-time with your coworkers.
Additionally, you will discover how to stay organized and connected with the mobile apps on your devices and be productive from any browser with Office for the web.
This tutorial will help you create a Microsoft Forms form directly in OneDrive, enhancing your productivity and collaboration.

1:33
3057 views

Available in Microsoft365

Objectifs :

Learn how to create, manage, and view a Microsoft Forms form directly within OneDrive, SharePoint, and Teams, and understand how to sync form data with an Excel workbook for real-time updates.

Chapitres :

Introduction to Microsoft Forms Integration
This section introduces the concept of creating Microsoft Forms directly within OneDrive, SharePoint, and Teams. It highlights the advantages of managing forms in the same environment where results will be viewed, providing a seamless experience.
Creating a Form for Excel
To create a form, navigate to the desired location in OneDrive, SharePoint, or Teams where you want to store your form results. Click on 'New' and select 'Form for Excel'. You will be prompted to name the workbook associated with your form. This workbook will be saved in your chosen folder and will serve as the repository for all form submissions.
Benefits of Using Forms for Excel
Using Forms for Excel within OneDrive, SharePoint, and Teams offers several benefits: - **Real-time Updates**: All updates to your forms will sync automatically with the associated Excel workbook. - **Ease of Access**: You can access your form results without navigating away from your working environment. - **Manual Syncing Option**: If needed, you can manually update the workbook to reflect the latest form submissions.
Managing Form Data
Once your form is created, all submissions will be saved in the designated Excel workbook. This eliminates the need to download files and move them to different storage spaces, streamlining the process of managing form data.
Conclusion
In summary, creating a Microsoft Forms form directly in OneDrive, SharePoint, and Teams simplifies the process of managing and viewing form results. By syncing data with an Excel workbook, users can enjoy real-time updates and easy access to their form submissions, enhancing productivity and efficiency.

FAQ :

How do I create a Microsoft Forms form in OneDrive?

To create a Microsoft Forms form in OneDrive, navigate to the desired location in OneDrive, click on 'New', and select 'Form for Excel'. You will then be prompted to name the associated workbook.

What are the benefits of using Forms for Excel?

Using Forms for Excel allows for real-time updates to your Excel workbook, easy access to form results without navigating through multiple applications, and automatic syncing of form submissions.

Can I access my form results from Teams?

Yes, you can create and manage Microsoft Forms directly within Teams, allowing for seamless collaboration and access to form results.

What happens to my form data after submission?

All form submissions are automatically saved in the associated Excel workbook, which resides in the folder you selected when creating the form.

Is it necessary to move files after creating a form?

No, when you create a form using Forms for Excel, the data is automatically stored in the designated OneDrive or SharePoint location, eliminating the need to move files manually.

Quelques cas d'usages :

Collecting Employee Feedback

HR departments can use Microsoft Forms to create surveys for employee feedback directly in Teams, allowing for real-time data collection and analysis in Excel.

Event Registration

Event organizers can create registration forms in SharePoint, enabling attendees to sign up easily while automatically storing responses in an Excel workbook for easy tracking.

Customer Satisfaction Surveys

Businesses can create customer satisfaction surveys using Forms for Excel, collecting responses directly in OneDrive, which can then be analyzed to improve services.

Project Management Updates

Project managers can create forms to gather updates from team members on project status, with responses automatically synced to an Excel workbook for easy monitoring.

Training Feedback Collection

Training coordinators can use Forms to collect feedback from participants after training sessions, with results stored in Excel for future reference and improvement.

Glossaire :

Microsoft Forms

A web-based application that allows users to create surveys, quizzes, and polls to collect information from respondents.

OneDrive

A cloud storage service from Microsoft that allows users to store files and access them from any device with internet connectivity.

SharePoint

A web-based collaboration platform from Microsoft that integrates with Microsoft Office and is used for storing, organizing, sharing, and accessing information from any device.

Teams

A collaboration platform from Microsoft that combines workplace chat, video meetings, file storage, and application integration.

Excel Workbook

A file created in Microsoft Excel that contains one or more worksheets where data can be organized, analyzed, and visualized.

Form for Excel

A feature that allows users to create forms directly linked to an Excel workbook, enabling real-time data collection and updates.

Syncing

The process of ensuring that data is consistent and up-to-date across multiple devices or applications.

00:00:00

You can create a Microsoft

00:00:02

Forms form inside OneDrive,

00:00:04

SharePoint and Teams and get real

00:00:07

time updates in your Excel workbook.

00:00:10

Creating, managing and viewing a

00:00:12

form from where you will actually

00:00:15

use and view the results is a great

00:00:17

alternative to starting off inside

00:00:19

the forms A Rather than creating a

00:00:22

form separately through Office 365,

00:00:24

you can use Forms for Excel inside OneDrive,

00:00:27

SharePoint and Teams and the form

00:00:29

data will reside in this work bar.

00:00:31

This provides easy access as you would not

00:00:34

have to go to Forms to select the form,

00:00:38

then select responses and select Excel

00:00:40

which is normally what the procedure.

00:00:42

Would be.

00:00:43

Let's not leave out the fact that

00:00:45

you would need to move the file

00:00:47

from your download folder into a

00:00:49

different storage space to use

00:00:51

forms for Excel had to OneDrive,

00:00:53

SharePoint and Teams.

00:00:54

Navigate to the location where you

00:00:56

want to store your form results.

00:00:59

Here click on New,

00:01:00

then select Form for Excel.

00:01:02

You will then be asked to name the

00:01:06

workbook associated with your form.

00:01:08

This workbook will be saved in your

00:01:10

chosen folder and will be where all

00:01:13

the form submissions will be saved.

00:01:15

All updates to your forms will be synced

00:01:17

to this workbook automatically with

00:01:19

the added extra of syncing yourself

00:01:22

if you want to update manually.

00:01:25

Now you know how to create a Microsoft

00:01:28

Forms form directly in OneDrive,

00:01:30

SharePoint and Teams.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

3576 Views

Microsoft Forms Video Training - Using the survey and questionnaire tool

From any web browser, guests have access to the form, even from a mobile device. Built-in and exportable analysis features ensure more in-de...

ALL COURSES