How To Create Online Fillable Forms in Microsoft Forms - Track Results in Excel
Learn how to create online mobile-friendly forms and surveys using Microsoft Forms so users can fill in the form online and you will get the results back in an Excel spreadsheet so you can track and analyze your data. MS Forms allows you to send users a link to fill in your form or survey online, or you can embed the form on a webpage to collect responses. Microsoft Forms is available to Microsoft 365 work, school, and personal subscribers, so users with a Microsoft account who have access to the online office apps can use Microsoft Forms.
Access Microsoft Forms: Forms.Office.com will take you to https://www.microsoft.com/en-us/micro...
With a Personal M365 account, you can initiate the form or survey from the Forms app itself and then export the responses to Excel at any time. Then see how using M365 for work or school will allow you to initiate your form from the Excel online app, which dynamically links it for real-time updates as responses to your form or survey come in.
📺 Watch Next - Create Fillable Forms Playlist: • How to Create Fillable Forms in Excel...
__________
TIMESTAMPS ⏰
00:00 Intro - How to Create Online Fillable Forms
00:25 Create New Form with Microsoft 365 Personal
01:20 Build and Edit Online Forms
03:20 How to Preview a Form
04:04 How to Send and Publish a Form
05:00 How to Export Form Responses to Excel
05:59 Create New Form with Microsoft 365 Work or School
07:47 How to Update Form Theme
08:18 View Form Results in Dynamic Excel Spreadsheet
__________
CONNECT WITH ME 📎
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
__________
GEAR
🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
📗 Green Screen: https://amzn.to/2DnHsY2
📸 Camera: https://amzn.to/39KvpQA
🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES
✏️ JotForm: https://www.jotform.com/pricing/?utm_...
📑 Wondershare PDFelement (PDF Editor): https://bit.ly/31QEkA8
💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324...
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
TEMPLATES
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/87584666...
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
✦ Visit https://mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
KEYWORDS: #onlineforms, #fillableforms, #MSForms, Microsoft Forms tutorial, create online forms, create fillable forms, create online fillable forms, create mobile forms, create surveys, create online surveys, Microsoft Forms, export form results to Excel, analyze form results in Excel, track survey responses in Excel, dynamically link a form to Excel, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤ Jotform Tutorials: • Jotform Tutorials
➤Creating Fillable Forms: • How To Create A Fillable Form In Micr...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist