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
  • 3012 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 !

 

résultat(s)
00:00:00
Puoi creare un Microsoft
00:00:02
I moduli si trovano all'interno di OneDrive,
00:00:04
SharePoint e Teams e diventa realtà
00:00:07
aggiornamenti temporali nella tua cartella di lavoro di Excel.
00:00:10
Creazione, gestione e visualizzazione di un
00:00:12
modulo da dove lo farai effettivamente
00:00:15
usare e visualizzare i risultati è ottimo
00:00:17
alternativa a iniziare dall'interno
00:00:19
le forme A Piuttosto che creare un
00:00:22
modulo separato tramite Office 365,
00:00:24
puoi usare Forms for Excel all'interno di OneDrive,
00:00:27
SharePoint e Teams e il modulo
00:00:29
i dati risiederanno in questa barra di lavoro.
00:00:31
Ciò fornisce un accesso facile come non lo faresti
00:00:34
devo andare su Moduli per selezionare il modulo,
00:00:38
quindi seleziona le risposte e seleziona Excel
00:00:40
che normalmente è la procedura.
00:00:42
Lo sarebbe.
00:00:43
Non tralasciamo il fatto che
00:00:45
dovresti spostare il file
00:00:47
dalla cartella di download in una
00:00:49
diverso spazio di archiviazione da utilizzare
00:00:51
i moduli per Excel dovevano essere inviati a OneDrive,
00:00:53
SharePoint e Teams.
00:00:54
Passa alla posizione in cui ti trovi
00:00:56
desideri archiviare i risultati del modulo.
00:00:59
Qui fai clic su Nuovo,
00:01:00
quindi seleziona Modulo per Excel.
00:01:02
Ti verrà quindi chiesto di nominare il
00:01:06
cartella di lavoro associata al modulo.
00:01:08
Questa cartella di lavoro verrà salvata nel tuo
00:01:10
cartella scelta e sarà dove saranno tutti
00:01:13
gli invii del modulo verranno salvati.
00:01:15
Tutti gli aggiornamenti dei moduli verranno sincronizzati
00:01:17
a questa cartella di lavoro automaticamente con
00:01:19
l'ulteriore vantaggio della sincronizzazione
00:01:22
se desideri eseguire l'aggiornamento manualmente.
00:01:25
Ora sai come creare un Microsoft
00:01:28
I moduli si formano direttamente in OneDrive,
00:01:30
SharePoint e Teams.

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

 

résultat(s)
00:00:00
Вы можете создать Microsoft
00:00:02
Формы формируются в OneDrive,
00:00:04
SharePoint и Teams и станьте реальными
00:00:07
обновления времени в рабочей книге Excel.
00:00:10
Создание, управление и просмотр
00:00:12
форма, откуда вы на самом деле будете
00:00:15
пользоваться и просматривать результаты просто замечательно
00:00:17
альтернатива тому, чтобы начинать с себя
00:00:19
формы A Вместо создания
00:00:22
форму отдельно через Office 365,
00:00:24
вы можете использовать формы для Excel в OneDrive,
00:00:27
SharePoint и Teams и форма
00:00:29
данные будут находиться на этой рабочей панели.
00:00:31
Это обеспечивает легкий доступ, чего бы вы не сделали
00:00:34
нужно перейти в «Формы», чтобы выбрать форму,
00:00:38
затем выберите ответы и выберите Excel
00:00:40
обычно это и есть процедура.
00:00:42
Было бы.
00:00:43
Давайте не будем упускать из виду тот факт, что
00:00:45
вам нужно будет переместить файл
00:00:47
из папки загрузок в
00:00:49
другое место для хранения данных для использования
00:00:51
формы для Excel пришлось использовать OneDrive,
00:00:53
SharePoint и команды.
00:00:54
Перейдите в то место, где вы
00:00:56
хотите сохранить результаты своей формы.
00:00:59
Здесь нажмите «Создать»,
00:01:00
затем выберите «Форма для Excel».
00:01:02
Затем вам будет предложено назвать
00:01:06
рабочая книга, связанная с вашей формой.
00:01:08
Эта рабочая книга будет сохранена в вашем
00:01:10
выбранная папка и будет там, где все
00:01:13
отправленные формы будут сохранены.
00:01:15
Все обновления ваших форм будут синхронизированы
00:01:17
в эту рабочую книгу автоматически с
00:01:19
дополнительная функция синхронизации
00:01:22
если вы хотите обновить вручную.
00:01:25
Теперь вы знаете, как создать Microsoft
00:01:28
Формы формируются прямо в OneDrive,
00:01:30
SharePoint и команды.

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

 

résultat(s)
00:00:00
Puedes crear un Microsoft
00:00:02
Formulario de formularios dentro de OneDrive,
00:00:04
SharePoint y Teams y conviértete en realidad
00:00:07
actualizaciones puntuales en tu libro de Excel.
00:00:10
Crear, administrar y ver un
00:00:12
formulario desde donde realmente lo harás
00:00:15
usar y ver los resultados es genial
00:00:17
alternativa a empezar desde dentro
00:00:19
las formas A En lugar de crear un
00:00:22
formulario por separado a través de Office 365,
00:00:24
puedes usar Forms for Excel en OneDrive,
00:00:27
SharePoint y Teams y el formulario
00:00:29
los datos residirán en esta barra de trabajo.
00:00:31
Esto proporciona un acceso más fácil que usted no tendría
00:00:34
tienes que ir a Formularios para seleccionar el formulario,
00:00:38
luego seleccione las respuestas y seleccione Excel
00:00:40
que es normalmente el procedimiento.
00:00:42
lo sería.
00:00:43
No dejemos de lado el hecho de que
00:00:45
tendrías que mover el archivo
00:00:47
de tu carpeta de descargas a una
00:00:49
diferente espacio de almacenamiento para usar
00:00:51
los formularios para Excel tenían que usar OneDrive,
00:00:53
SharePoint y Teams.
00:00:54
Navega hasta la ubicación donde
00:00:56
desea almacenar los resultados de su formulario.
00:00:59
Aquí haga clic en Nuevo,
00:01:00
luego seleccione Formulario para Excel.
00:01:02
A continuación, se le pedirá que asigne un nombre al
00:01:06
libro de trabajo asociado a su formulario.
00:01:08
Este libro de trabajo se guardará en su
00:01:10
eligió la carpeta y estará donde estén todos
00:01:13
se guardarán los envíos del formulario.
00:01:15
Se sincronizarán todas las actualizaciones de sus formularios
00:01:17
a este libro de trabajo automáticamente con
00:01:19
el extra adicional de sincronizarte
00:01:22
si quieres actualizar manualmente.
00:01:25
Ahora sabes cómo crear un Microsoft
00:01:28
Los formularios se forman directamente en OneDrive,
00:01:30
SharePoint y Teams.

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

 

résultat(s)
00:00:00
Je kunt een Microsoft aanmaken
00:00:02
Formulieren in OneDrive,
00:00:04
SharePoint en Teams en ga aan de slag
00:00:07
tijdupdates in uw Excel-werkmap.
00:00:10
Creëren, beheren en bekijken van een
00:00:12
formulier van waaruit u daadwerkelijk
00:00:15
gebruik en bekijk de resultaten is geweldig
00:00:17
alternatief voor binnen beginnen
00:00:19
de formulieren A In plaats van een te creëren
00:00:22
afzonderlijk via Office 365 invullen,
00:00:24
je kunt Forms for Excel gebruiken in OneDrive,
00:00:27
SharePoint en Teams en het formulier
00:00:29
gegevens zullen zich in deze werkbalk bevinden.
00:00:31
Dit biedt eenvoudige toegang zoals u dat niet zou doen
00:00:34
moet naar Forms gaan om het formulier te selecteren,
00:00:38
selecteer vervolgens de antwoorden en selecteer Excel
00:00:40
wat normaal gesproken de procedure is.
00:00:42
Zou zijn.
00:00:43
Laten we niet vergeten dat
00:00:45
je zou het bestand moeten verplaatsen
00:00:47
van je downloadmap naar een
00:00:49
verschillende opslagruimte om te gebruiken
00:00:51
formulieren voor Excel moesten naar OneDrive,
00:00:53
SharePoint en Teams.
00:00:54
Navigeer naar de locatie waar je
00:00:56
wil je formulierresultaten opslaan.
00:00:59
Klik hier op Nieuw,
00:01:00
selecteer vervolgens Formulier voor Excel.
00:01:02
Vervolgens wordt u gevraagd een naam te geven
00:01:06
werkboek dat aan uw formulier is gekoppeld.
00:01:08
Deze werkmap wordt opgeslagen in uw
00:01:10
gekozen map en zal zijn waar alle
00:01:13
de formulierinzendingen worden opgeslagen.
00:01:15
Alle updates van je formulieren worden gesynchroniseerd
00:01:17
automatisch naar deze werkmap met
00:01:19
de extra mogelijkheid om jezelf te synchroniseren
00:01:22
als je handmatig wilt updaten.
00:01:25
Nu weet je hoe je een Microsoft maakt
00:01:28
Formulieren rechtstreeks in OneDrive,
00:01:30
SharePoint en Teams.

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

 

résultat(s)
00:00:00
Możesz utworzyć Microsoft
00:00:02
Formularz formularzy wewnątrz usługi OneDrive,
00:00:04
SharePoint i Teams i uzyskaj prawdziwość
00:00:07
aktualizacje czasu w skoroszycie programu Excel.
00:00:10
Tworzenie, zarządzanie i przeglądanie
00:00:12
formę, z której faktycznie będziesz
00:00:15
korzystanie i przeglądanie wyników jest świetne
00:00:17
Alternatywa dla rozpoczęcia od środka
00:00:19
Formy A Zamiast tworzyć
00:00:22
formularz osobno za pośrednictwem pakietu Office 365,
00:00:24
możesz użyć Formularzy dla programu Excel w usłudze OneDrive,
00:00:27
SharePoint i Teams oraz formularz
00:00:29
dane będą znajdować się na tym pasku roboczym.
00:00:31
Zapewnia to łatwy dostęp, tak jak nie
00:00:34
musisz przejść do Formularzy, aby wybrać formularz,
00:00:38
następnie wybierz odpowiedzi i wybierz Excel
00:00:40
co zwykle jest tym, co jest procedurą.
00:00:42
Byłby.
00:00:43
Nie pomijmy faktu, że
00:00:45
musiałbyś przenieść plik
00:00:47
z folderu pobierania do
00:00:49
inna przestrzeń dyskowa do wykorzystania
00:00:51
formularze dla programu Excel musiały być OneDrive,
00:00:53
SharePoint i zespoły.
00:00:54
Przejdź do lokalizacji, w której
00:00:56
chcesz przechowywać wyniki formularza.
00:00:59
Tutaj kliknij Nowy,
00:01:00
następnie wybierz Formularz dla programu Excel.
00:01:02
Następnie zostaniesz poproszony o nazwanie
00:01:06
skoroszyt powiązany z formularzem.
00:01:08
Ten skoroszyt zostanie zapisany w Twoim
00:01:10
wybrany folder i będzie tam, gdzie wszystkie
00:01:13
zgłoszenia formularza zostaną zapisane.
00:01:15
Wszystkie aktualizacje formularzy zostaną zsynchronizowane
00:01:17
do tego skoroszytu automatycznie za pomocą
00:01:19
dodatkowy dodatek synchronizacji
00:01:22
jeśli chcesz zaktualizować ręcznie.
00:01:25
Teraz wiesz, jak utworzyć Microsoft
00:01:28
Formularze formularze bezpośrednio w usłudze OneDrive,
00:01:30
SharePoint i zespoły.

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

 

résultat(s)
00:00:00
Létrehozhat egy Microsoftot
00:00:02
Űrlapok a OneDrive-on belül,
00:00:04
SharePoint és Teams, és váljon valósághűvé
00:00:07
időfrissítések az Excel munkafüzetben.
00:00:10
Létrehozása, kezelése és megtekintése
00:00:12
formában, ahonnan valójában fogsz
00:00:15
az eredmények használata és megtekintése nagyszerű
00:00:17
alternatívája a belülről való induláshoz
00:00:19
az A formák ahelyett, hogy létrehoznánk a
00:00:22
külön formanyomtatványt az Office 365-en keresztül,
00:00:24
használhatja az Excel-űrlapokat a OneDrive-ban,
00:00:27
SharePoint és Teams és az űrlap
00:00:29
az adatok ebben a munkasávban találhatók.
00:00:31
Ez könnyű hozzáférést biztosít, ahogy nem tenné
00:00:34
az űrlap kiválasztásához el kell mennie az Űrlapok menüpontba,
00:00:38
majd válassza ki a válaszokat, és válassza az Excel lehetőséget
00:00:40
Ez általában az eljárás.
00:00:42
Az lenne.
00:00:43
Ne hagyjuk ki azt a tényt, hogy
00:00:45
át kell helyeznie a fájlt
00:00:47
a letöltési mappából a
00:00:49
különböző tárolóhely a használatra
00:00:51
az Excel űrlapjai OneDrive-ra voltak szükségesek,
00:00:53
SharePoint és Teams.
00:00:54
Keresse meg azt a helyet, ahol Ön
00:00:56
szeretné tárolni az űrlap eredményeit.
00:00:59
Itt kattintson az Új gombra,
00:01:00
majd válassza az Excel-űrlap lehetőséget.
00:01:02
Ezután megkérik, hogy nevezze meg a
00:01:06
az űrlaphoz társított munkafüzet.
00:01:08
Ez a munkafüzet mentésre kerül az Ön számára
00:01:10
kiválasztott mappa, és ott lesz, ahol minden
00:01:13
az űrlap beküldései mentésre kerülnek.
00:01:15
Az űrlapok összes frissítése szinkronizálódik
00:01:17
ehhez a munkafüzetbe automatikusan
00:01:19
az önmagad szinkronizálásának hozzáadott extra
00:01:22
ha manuálisan szeretne frissíteni.
00:01:25
Most már tudja, hogyan hozhat létre egy Microsoftot
00:01:28
Az űrlapok közvetlenül a OneDrive-ban,
00:01:30
SharePoint és Teams.

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

 

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

3468 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

An Error Has Occurred

Unable to save your progress. Please reload the page, log in, and try again. If the problem persists, please contact an administrator.

Close

Reminder

Show

/

Join Live Training Session