❎ How to use Excel

Currently Playing: How to Create a Data Entry Form in Excel (Step-by-Step)

🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com In this step-by-step 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): https://youtu.be/7UEdYkExwTo - Sample workbook that I used in this tutorial (if you'd like to follow along): https://1drv.ms/x/s!AmxrofZZlZ-whMs0xYvY3Kg3vgy79w?e=kfVATQ - Learn the fundamentals of Excel in just 2 hours: 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: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🚩 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