🔥 Learn Excel in just 2 hours: [ Ссылка ]

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: [ Ссылка ]
- Microsoft Forms Overview video: [ Ссылка ]
- Learn the fundamentals of Excel in just 2 hours: [ Ссылка ]

⌚ 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: [ Ссылка ]
- Playlist with all my videos on Microsoft Forms: [ Ссылка ]

🚩 Connect with me on social
- LinkedIn: [ Ссылка ]
- Twitter: [ Ссылка ]
- Facebook: [ Ссылка ]
- TikTok: [ Ссылка ]

🔔 Subscribe to my YouTube channel
[ Ссылка ]

🎬 Want to watch again? Navigate back to my YouTube channel quickly
[ Ссылка ]

🛍 Support me with your Amazon purchases: [ Ссылка ]

⚖ 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

свернуть