Modern Excel Data Entry Work Form Tutorial

🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com

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:    • How to use Microsoft Forms  
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:    • ❎ How to use Excel  
Playlist with all my videos on Microsoft Forms:    • Forms  

🚩 Connect with me on social
LinkedIn:   / kevinstratvert  
Twitter:   / kevstrat  
Facebook:   / kevin-stratvert-101912218227818  
TikTok:   / kevinstratvert  

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

🎬 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