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: 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?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
- Playlist with all my videos on Microsoft Forms: https://youtube.com/playlist?list=PLlKpQrBME6xKZ2TsinR-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_confirmation=1
🎬 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
Видео Modern Excel Data Entry Work Form Tutorial канала Kevin Stratvert
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?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
- Playlist with all my videos on Microsoft Forms: https://youtube.com/playlist?list=PLlKpQrBME6xKZ2TsinR-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_confirmation=1
🎬 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
Видео Modern Excel Data Entry Work Form Tutorial канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
PIRATES Invade SeattleMunich, Germany | Stunning GoPro Video TourBermuda Family VacationOur family visits Oahu!How to use Presenter View in Microsoft TeamsUplevel your PowerPoint game with MORPHYou've Been Presenting PowerPoint Wrong…5 Mind-blowing AI Tools 🤯Best Excel Shortcuts in under 1 min🔥 CapCut Video Editing Tips and TricksHow to use Microsoft Power Query🧙♂️ 5 BEST Shortcuts in Microsoft WordPower Virtual Agents Chatbot TutorialTop 5 Most Useful Websites5 Mind-blowing Artificial Intelligence Tools 🤯🎬 BEST CapCut Video Editing Tips and TricksHow to Use Cameo in PowerPoint5 PowerPoint Secrets Exposed! 🤫Google Drive Tips and TricksHow to use PowerPoint CameoOBS Studio Tips and Tricks