Prevent Errors in Excel in 2023 with Data Validation and Conditional Formatting

🚀Join my free tech newsletter: https://got-sheet.beehiiv.com/ Walkthrough of using conditional formatting as well as data validation to prevent errors in Excel and Google Sheets using an inventory ordering spreadsheet. Excel sheet demo: https://onedrive.live.com/edit.aspx?resid=FE6EDAF51E9AF322!1141&ithint=file%2cxlsx&authkey=!ANRcKMn_p25YVyo Google Sheet demo: https://docs.google.com/spreadsheets/d/1gnacOaU_TCX_I7wGxHWWriyej4kI7t9AzM_nLybv9Cs/edit#gid=1341856047 00:00 Intro 00:25 Links in Description 00:43 Overview of Sheet and Possible Errors 01:10 Conditional Formatting 01:46 **Note About Gridlines 02:13 Data Validation 02:45 Excel beats Google Sheets 03:25 Combine Data Validation with Conditional Formatting 04:14 Data Validation Block Errors! 05:05 Please subscribe! Thanks! 😀 Please subscribe to my channel for more coding and spreadsheet content: https://www.youtube.com/@eamonncottrell?sub_confirmation=1 You can find more of my work including articles and podcasts on my website at https://www.eamonncottrell.com/ #googlesheets #spreadsheet #excel #datavalidation #conditionalformating ⭐⭐Some of My Computer Desk Gear for Data Analysts (affiliate links support my channel's growth 😀) ►Keychron Q5...my new favorite; it's lovely especially with the quiet keycaps: https://amzn.to/3NLn57r ►Keychron's Full Product Line...https://amzn.to/3rtitv7 ►DeltaHub Ergonomic Wrist rest. I was skeptical, but it has done wonders for my desk-wrist soreness. https://amzn.to/3O7cRQi ►Uplift Standing Desk...I love this thing. I also sit at it a lot, which I'm ok with 😀https://amzn.to/3XPAmAM ►Logitech THX 2.1 Speakers...great sound at an affordable price... https://amzn.to/3D9InXr ►Phone stand for Desk...surprisingly handy to have phone on a stand. And cheap...https://amzn.to/3D8ODid