Home
Categories
EXPLORE
True Crime
Comedy
Business
Society & Culture
Sports
Technology
History
About Us
Contact Us
Copyright
© 2024 PodJoint
00:00 / 00:00
Sign in

or

Don't have an account?
Sign up
Forgot password
https://is1-ssl.mzstatic.com/image/thumb/Podcasts211/v4/e5/48/da/e548daf0-0f3e-89d0-a34c-431dbee29807/mza_15374550122319401347.jpg/600x600bb.jpg
I Want To Hack
Eamonn Cottrell
35 episodes
4 months ago
Weekly discussion of coding and spreadsheets in real life business applications.
Show more...
Technology
Business,
Entrepreneurship
RSS
All content for I Want To Hack is the property of Eamonn Cottrell and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.
Weekly discussion of coding and spreadsheets in real life business applications.
Show more...
Technology
Business,
Entrepreneurship
https://img.transistor.fm/3nNDtT-7n7aOLu1HSkIjP9UNkerWxM-cytrJDl-3TAE/rs:fill:3000:3000:1/q:60/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9lcGlz/b2RlLzEyNDY0NDQv/MTY3ODgzMzY5My1h/cnR3b3JrLmpwZw.jpg
Reduce Errors with Data Validation and Conditional Formatting
I Want To Hack
4 minutes
2 years ago
Reduce Errors with Data Validation and Conditional Formatting

Hi there! We are talking about how to reduce errors with data validation and conditional formatting in spreadsheets this week. There's an accompanying video and spreadsheet demo linked below for you!👇

Thanks for listening, I Want to Hack is a weekly discussion of coding and spreadsheet concepts. I hope you'll subscribe to follow along! Links at the bottom, but if you do nothing else, would you consider subscribing to my YouTube channel where I share spreadsheet and coding tutorials? 😉 I'm hoping to grow this to 1000 subscribers this year!

Episode Overview:

  • Video Walkthrough
  • Demo Google Sheet
  • In depth article on freeCodeCamp

In our business, we use spreadsheets for a lot of our inventory management and ordering. We needed a way to prevent human errors in one of our order forms, and were able to do this by combining data validation and conditional formatting.

This episode is an overview of the use cases for this and the ways to save time and errors in the process.


Please subscribe to this podcast if you haven't already! I really appreciate it, and look forward to talking with you on the next pod!

More Resources:

  • Find me on my site
  • Watch me on YouTube @eamonncottrell 
  • Follow me on Linkedin @EamonnCottrell
  • Buy me a coffee on BuyMeACoffee
  • Laugh at me on gitHub @sieis
I Want To Hack
Weekly discussion of coding and spreadsheets in real life business applications.