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
  • 2286 views

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 :

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:00
Você pode criar um Microsoft
00:00:02
Formulário de formulários dentro do OneDrive,
00:00:04
SharePoint e Teams e torne-se real
00:00:07
atualizações de tempo na pasta de trabalho do Excel.
00:00:10
Criar, gerir e visualizar um
00:00:12
forma de onde você vai realmente
00:00:15
usar e visualizar os resultados é um ótimo
00:00:17
alternativa para começar por dentro
00:00:19
os formulários A Em vez de criar um
00:00:22
formulário separadamente através do Office 365,
00:00:24
você pode usar o Forms for Excel dentro do OneDrive,
00:00:27
SharePoint e Teams e o formulário
00:00:29
Os dados residirão nesta barra de trabalho.
00:00:31
Isso fornece acesso fácil como você não faria
00:00:34
tem que ir para Formulários para selecionar o formulário,
00:00:38
em seguida, selecione respostas e selecione Excel
00:00:40
que é normalmente o que o procedimento.
00:00:42
Seria.
00:00:43
Não vamos deixar de lado o fato de que
00:00:45
você precisaria mover o arquivo
00:00:47
da sua pasta de download para um
00:00:49
espaço de armazenamento diferente para usar
00:00:51
formulários para Excel tinha que OneDrive,
00:00:53
SharePoint e Equipas.
00:00:54
Navegue até o local onde você
00:00:56
deseja armazenar os resultados do formulário.
00:00:59
Aqui clique em Novo,
00:01:00
em seguida, selecione Formulário para Excel.
00:01:02
Ser-lhe-á então pedido que nomeie o
00:01:06
pasta de trabalho associada ao seu formulário.
00:01:08
Esta pasta de trabalho será salva em seu
00:01:10
pasta escolhida e será onde todos
00:01:13
Os envios de formulários serão salvos.
00:01:15
Todas as atualizações dos seus formulários serão sincronizadas
00:01:17
para esta pasta de trabalho automaticamente com
00:01:19
o extra adicional de sincronizar-se
00:01:22
se você quiser atualizar manualmente.
00:01:25
Agora você já sabe como criar um Microsoft
00:01:28
Formulário de formulários diretamente no OneDrive,
00:01:30
SharePoint e Equipas.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

2792 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

Reminder

Show

/

Join Live Training Session