Weekly discussion of coding and spreadsheets in real life business applications.
I Want To Hack
Claim This Podcastby Eamonn Cottrell
5.0(4 reviews)
35 episodes
Updated Daily
Accepts GuestsHas Sponsors
Podcast Overview
Weekly discussion of coding and spreadsheets in real life business applications.
Language
🇺🇲
Publishing Since
12/3/2012
1 verified contact email on file for I Want To Hack
Pitch yourself as a guest, propose sponsorships, or reach out directly to the host.
Recent Episodes
August 14, 2023
Easy Web Scraping With Google Sheets
<p>Hi there! We are looking at the 5 Import functions built in to Google Sheets. There's an accompanying video and spreadsheet demo linked below for you!👇</p><p><strong>Thanks for listening</strong>, 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 <a href="https://www.youtube.com/@eamonncottrell?sub_confirmation=1">YouTube channel</a> where I share spreadsheet and coding tutorials? 😉</p><p><strong>Episode Overview:</strong></p><ul><li><a href="https://www.youtube.com/playlist?list=PLM4kOja-yPM7dvGbxPgIGPCoIjTfKq0k8">Video Playlist</a></li><li><a href="https://docs.google.com/spreadsheets/d/1n8CYEHYktePXJzt5quCBn2gwHvnvTH49vvJziXLnQSE/edit#gid=438611895">Spreadsheet Example</a></li></ul><p><br>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!</p><p><strong>More Resources:</strong></p><ul><li>Watch me on <a href="https://www.youtube.com/@eamonncottrell?sub_confirmation=1">YouTube</a> @eamonncottrell </li><li>Subscribe to my <a href="https://got-sheet.beehiiv.com/subscribe">newsletter</a></li><li>Follow me on <a href="https://www.linkedin.com/in/eamonncottrell/">Linkedin </a>@EamonnCottrell</li><li>Buy me a coffee on <a href="https://www.buymeacoffee.com/W4V7SRM">BuyMeACoffee</a></li><li>Laugh at me on <a href="https://github.com/sieis">gitHub </a>@sieis</li><li>Find me on my <a href="https://eamonncottrell.com/">site</a></li></ul>
March 20, 2023
Custom Named Functions in Google Sheets
<p>Hi there! We are talking about how to create custom named functions in Google Sheets (works in Excel too). There's an accompanying video and spreadsheet demo linked below for you!👇</p><p><strong>Thanks for listening</strong>, 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 <a href="https://www.youtube.com/@eamonncottrell?sub_confirmation=1">YouTube channel</a> where I share spreadsheet and coding tutorials? 😉 I'm hoping to grow this to 1000 subscribers this year!</p><p><strong>Episode Overview:</strong></p><ul><li><a href="https://youtu.be/UmzAdZnVRy0">Video Walkthrough</a></li><li><a href="https://docs.google.com/spreadsheets/d/1pubmIp-4VmcHpQJXibxU1Astl6lgH2qZEN3Ry1S7i6Q/edit#gid=337119202">Demo Google Sheet</a></li><li><a href="https://www.freecodecamp.org/news/google-sheets-how-to-create-custom-named-functions/">In depth article on freeCodeCamp</a></li></ul><p>Google Sheets has over 500 built in functions you can use out of the box, but sometimes it can be helpful to create a custom one. Instead of manually typing it out every time you need it, you can create a custom named function. It's a pretty straightforward process, and I hope you find this useful!</p><p><br>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!</p><p><strong>More Resources:</strong></p><ul><li>Find me on my <a href="https://eamonncottrell.com/">site</a></li><li>Watch me on <a href="https://www.youtube.com/@eamonncottrell?sub_confirmation=1">YouTube</a> @eamonncottrell </li><li>Follow me on <a href="https://www.linkedin.com/in/eamonncottrell/">Linkedin </a>@EamonnCottrell</li><li>Buy me a coffee on <a href="https://www.buymeacoffee.com/W4V7SRM">BuyMeACoffee</a></li><li>Laugh at me on <a href="https://github.com/sieis">gitHub </a>@sieis</li></ul>
March 17, 2023
Reduce Errors with Data Validation and Conditional Formatting
<p>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!👇</p><p><strong>Thanks for listening</strong>, 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 <a href="https://www.youtube.com/@eamonncottrell?sub_confirmation=1">YouTube channel</a> where I share spreadsheet and coding tutorials? 😉 I'm hoping to grow this to 1000 subscribers this year!</p><p><strong>Episode Overview:</strong></p><ul><li><a href="https://youtu.be/vMyBjyHGQ-U">Video Walkthrough</a></li><li><a href="https://docs.google.com/spreadsheets/d/1gnacOaU_TCX_I7wGxHWWriyej4kI7t9AzM_nLybv9Cs/edit#gid=1341856047">Demo Google Sheet</a></li><li><a href="https://www.freecodecamp.org/news/excel-use-data-validation-and-conditional-formatting-to-prevent-errors/">In depth article on freeCodeCamp</a></li></ul><p>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.</p><p>This episode is an overview of the use cases for this and the ways to save time and errors in the process.</p><p><br>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!</p><p><strong>More Resources:</strong></p><ul><li>Find me on my <a href="https://eamonncottrell.com/">site</a></li><li>Watch me on <a href="https://www.youtube.com/@eamonncottrell?sub_confirmation=1">YouTube</a> @eamonncottrell </li><li>Follow me on <a href="https://www.linkedin.com/in/eamonncottrell/">Linkedin </a>@EamonnCottrell</li><li>Buy me a coffee on <a href="https://www.buymeacoffee.com/W4V7SRM">BuyMeACoffee</a></li><li>Laugh at me on <a href="https://github.com/sieis">gitHub </a>@sieis</li></ul>
35 total episodes available
Deep-dive analytics for I Want To Hack
Frequently asked questions
Have a different question and can't find the answer you're looking for? Reach out to our support team by sending us an email and we'll get back to you as soon as we can.
- What is I Want To Hack?
- How often does this podcast release new episodes?
This podcast updates daily.
- Where can I listen to this podcast?
This podcast is available on 4 platforms including Apple Podcasts, Spotify, and more. You can also use the RSS feed directly.
- Does this podcast accept guests?
No, this podcast does not typically feature guests.
Legal Disclaimer
Pod Engine is not affiliated with, endorsed by, or officially connected with any of the podcasts displayed on this platform. We operate independently as a podcast discovery and analytics service.
All podcast artwork, thumbnails, and content displayed on this page are the property of their respective owners and are protected by applicable copyright laws. This includes, but is not limited to, podcast cover art, episode artwork, show descriptions, episode titles, transcripts, audio snippets, and any other content originating from the podcast creators or their licensors.
We display this content under fair use principles and/or implied license for the purpose of podcast discovery, information, and commentary. We make no claim of ownership over any podcast content, artwork, or related materials shown on this platform. All trademarks, service marks, and trade names are the property of their respective owners.
While we strive to ensure all content usage is properly authorized, if you are a rights holder and believe your content is being used inappropriately or without proper authorization, please contact us immediately at hey@podengine.ai for prompt review and appropriate action, which may include content removal or proper attribution.
By accessing and using this platform, you acknowledge and agree to respect all applicable copyright laws and intellectual property rights of content owners. Any unauthorized reproduction, distribution, or commercial use of the content displayed on this platform is strictly prohibited.