Modern Excel Data Entry Work Form Tutorial

Channel Avatar
Comment
X
Share
Modern Excel Data Entry Work Form Tutorial
Modern Excel Data Entry Work Form Tutorial
In this step-by-step tutorial, learn how to create a modern Excel data entry form. With Microsoft Forms in Excel, you can connect a form or survey directly to your Excel sheet. You can create any number of questions, including multiple choice, free form text, drop downs, Likert scales, and more. You can make questions required, set validation criteria, limit responses to your organization, and much more. Once your survey or form is done, you can share using a link, QR code, or even embed the form into a web site. When respondents submit the form, the results go directly into your Excel spreadsheet and show up instantaneously. You can even build charts, pivot tables, and more from the results and they’ll update as soon as additional form submissions arrive. To use this functionality, you need either a work or school Microsoft 365 account.

Additional resources
– Office.com: https://www.office.com
– Microsoft Forms Overview video: https://youtu.be/ouFKWHQMxtQ
– Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

Timestamps
0:00 Introduction
1:01 Sign into Office.com
1:29 Create a new Excel workbook
1:50 Insert form into Excel
2:11 Design form
4:31 Preview form
5:09 Set themes
5:32 Settings
6:11 Share form
6:45 View form in Excel
7:34 Edit form
8:12 View form results in Excel desktop
8:28 View results in Excel
9:19 Get back to results through Forms
9:53 Wrap up

Watch related playlists
– Playlist with all my videos on Excel: https://youtube.com/playlist?listPLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
– Playlist with all my videos on Microsoft Forms: https://youtube.com/playlist?listPLlKpQrBME6xKZ2TsinR-R649-oCFZqaex

Connect with me on social
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert

Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation1

Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com

Support me with your Amazon purchases: https://amzn.to/3kCP2yz

As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.

#stratvert

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *