Want to automate data entry in Excel? In this step-by-step tutorial, I’ll show you how to create a sleek and professional automated data entry form that makes collecting responses effortless!

What You’ll Learn:
️ Design a user-friendly form with text fields, checkboxes, drop-downs, and a submit button
️ Apply conditional formatting and data validation to control input
️ Automate data collection using Excel macros (no coding required!)
️ Protect your form to prevent unwanted changes
️ Save your form as a macro-enabled workbook for easy use

We’ll build a cookie order form for the Kevin Cookie Company, but you can customize it for any business or project! Whether you’re tracking inventory, logging customer orders, or collecting survey responses, this tutorial has you covered.

By the end, you’ll have a fully automated Excel form that submits data with a click—no manual entry needed!

Host: Kevin Stratvert

TIMESTAMPS
00:00 – Introduction
00:30 – Insert a Logo
01:37 – Build the Form Layout
03:16 – Format the Form
05:25 – Add a Place Order Button
06:42 – Insert Checkboxes
07:31 – Show Quantity Field Only When Checked
11:56 – Create a Dropdown for Delivery Method
13:20 – Restrict Delivery Date to Valid Dates
14:06 – Remove Gridlines & Add Borders
15:14 – Apply a Themed Background
16:02 – Test the Form with a Sample Order
16:48 – Link Form Fields to a Response Sheet
19:13 – Record a Macro to Capture Form Data
23:08 – Run a Macro Test
24:11 – Assign Macro to the Place Order Button
24:50 – Protect the Form from Edits
27:52 – Enable Full-Screen Kiosk Mode
28:20 – Save as a Macro-Enabled Workbook
29:25 – Wrap Up

RELATED VIDEOS
– Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

NEWSLETTER
– Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

CONNECT WITH ME
– Official website: http://www.kevinstratvert.com
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://bit.ly/KevinStratvertDiscord
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/kevinstratvert/

TOOLS AND DISCOUNTS
️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
Squarespace Websites | https://squarespace.syuh.net/XYaqYM
Grammarly | https://grammarly.go2cloud.org/SH3nL
CapCut | https://bit.ly/installcapcut
️ Shopify | https://shopify.pxf.io/XY9rPa
Notion | https://affiliate.notion.so/rffva4tr71ax
️ Figma | https://psxid.figma.com/lqjg97licpry
ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
Quickbooks Online | https://bit.ly/intuitquickbooksonline
Hubspot | https://hubspot.sjv.io/DKo6jb
Semrush | https://bit.ly/semrush14dayfreetrial
Descript | https://get.descript.com/sf22jb63w2tx
Smartsheet | https://bit.ly/trysmartsheet

MY COURSES
– Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

SUPPORT THE CHANNEL
– Hit the THANKS button in any video!
– Amazon affiliate link: https://amzn.to/3kCP2yz

DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #excel

Please take the opportunity to connect and share this video with your friends and family if you find it useful.