Explainly Quick Tips: Web Form Connected To Excel

Description
This is an Explainly Quick Tip! Explainly Quick Tips cover topics that we, at Explainly, consider interesting and helpful while being doable in three minutes or less.

For this Quick Tip, Philip will show you how to use Excel Online to create a Microsoft Form that you can share with your friends, clients, strangers, and others to collect information and have it automatically pipe into your own Microsoft Excel file for storage and analysis.

To replicate this, you will need an Office 365 subscription and access to Excel Online. The Excel file created during the process will have to be located within your OneDrive in order to receive data updates. In addition to pushing the data from the Form into Excel, Microsoft Forms has its own data repository where you can view and evaluate the responses received.

There are no other requirements for following along with this video.

The video covers this concept in under 3 minutes and the longest (and hardest!) part of actually setting this up is in writing up the form questions that you'd like to ask.

If you have any tasks that you struggle with or would like to know how to do with Excel, or other tools, send your suggestions to me on Eloquens via message and perhaps you'll be the inspiration for my next quick tip!