How To Create Online Fillable Forms in Microsoft Forms - Track Results in Excel

Video Description

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/microsoft-365/online-surveys-polls-quizzes 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: https://www.youtube.com/watch?v=_g7863PjNns&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv __________ 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: https://www.linkedin.com/in/sharonsmithhr Twitter: https://twitter.com/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_source=sharon-smith&utm_campaign=jf1&utm_medium=blog 📑 Wondershare PDFelement (PDF Editor): https://bit.ly/31QEkA8 💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack= 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/875846662/employee-engagement-survey-ms-excel?ref=listing_published_alert 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?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. 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/sharonsmithhrformulasdownload 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: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD ➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv ➤PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM ➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90 ➤ Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW ➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45 ➤ Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR