4 Min.

Reduce Errors with Data Validation and Conditional Formatting I Want To Hack

    • Technologie

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 WalkthroughDemo Google SheetIn depth article on freeCodeCampIn 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 siteWatch me on YouTube @eamonncottrell Follow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieis

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 WalkthroughDemo Google SheetIn depth article on freeCodeCampIn 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 siteWatch me on YouTube @eamonncottrell Follow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieis

4 Min.

Top‑Podcasts in Technologie

Acquired
Ben Gilbert and David Rosenthal
#heiseshow (Audio) - Technik-News und Netzpolitik
heise online
Lex Fridman Podcast
Lex Fridman
Apfelfunk
Malte Kirchner & Jean-Claude Frick
Ö1 Digital.Leben
ORF Ö1
Mac & i - der Apple-Podcast
Mac & i