Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com
In this stepbystep tutorial, learn how to create a simple data entry form in Microsoft Excel. With this Excel form, you can easily enter data into your spreadsheet. Along with entering data, you can also enter criteria to search for data in your workbook. Especially if you have many columns and rows of data, this makes Excel data entry much easier. At the end in this tutorial, I show you how to create a very simple macro that connects to a button. You can then click on the button to launch your Excel form.
Additional resources
How to create a Modern Excel Data Entry Form (using Microsoft Forms + Excel): • Modern Excel Data Entry Work Form Tut...
Sample workbook that I used in this tutorial (if you'd like to follow along): https://1drv.ms/x/s!AmxrofZZlZwhMs0x...
Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
0:45 Set up data for form
1:21 Create simple data entry form
2:33 Navigating data with Excel form
2:57 Add new record
3:25 Undo changes with restore
4:02 Search using criteria
5:47 Data validation with Excel forms
6:55 Create button to launch Excel form
10:12 Wrap up
Watch related playlists
Playlist with all my videos on Excel: • ❎ How to use Excel
Connect with me on social
LinkedIn: / kevinstratvert
Twitter: / kevstrat
Facebook: / kevinstratvert101912218227818
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