I Want To Hack

About I Want To Hack

Weekly discussion of coding and spreadsheets in real life business applications.

Publisher

Eamonn Cottrell

Category

business · technology

Language

en

Explicit

No

First episode

3 Dec 2012

Latest episode

14 Aug 2023

Latest episodes

35 episodes in the feed.

1. 

   14 Aug 2023

   Easy Web Scraping With Google Sheets

   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!👇 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 (https://www.youtube.com/@eamonncottrell?sub_confirmation=1) where I share spreadsheet and coding tutorials? 😉 Episode Overview: Video Playlist (https://www.youtube.com/playlist?list=PLM4kOja-yPM7dvGbxPgIGPCoIjTfKq0k8) Spreadsheet Example (https://docs.google.com/spreadsheets/d/1n8CYEHYktePXJzt5quCBn2gwHvnvTH49vvJziXLnQSE/edit#gid=438611895) 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: Watch me on YouTube (https://www.youtube.com/@eamonncottrell?sub_confirmation=1) @eamonncottrell Subscribe to my newsletter (https://got-sheet.beehiiv.com/subscribe) Follow me on Linkedin (https://www.linkedin.com/in/eamonncottrell/)@EamonnCottrell Buy me a coffee on BuyMeACoffee (https://www.buymeacoffee.com/W4V7SRM) Laugh at me on gitHub (https://github.com/sieis)@sieis Find me on my site (https://eamonncottrell.com/)

2. 

   20 Mar 2023

   Custom Named Functions in Google Sheets

   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!👇 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 (https://www.youtube.com/@eamonncottrell?sub_confirmation=1) where I share spreadsheet and coding tutorials? 😉 I'm hoping to grow this to 1000 subscribers this year! Episode Overview: Video Walkthrough (https://youtu.be/UmzAdZnVRy0) Demo Google Sheet (https://docs.google.com/spreadsheets/d/1pubmIp-4VmcHpQJXibxU1Astl6lgH2qZEN3Ry1S7i6Q/edit#gid=337119202) In depth article on freeCodeCamp (https://www.freecodecamp.org/news/google-sheets-how-to-create-custom-named-functions/) 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! 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 (https://eamonncottrell.com/) Watch me on YouTube (https://www.youtube.com/@eamonncottrell?sub_confirmation=1) @eamonncottrell Follow me on Linkedin (https://www.linkedin.com/in/eamonncottrell/)@EamonnCottrell Buy me a coffee on BuyMeACoffee (https://www.buymeacoffee.com/W4V7SRM) Laugh at me on gitHub (https://github.com/sieis)@sieis

3. 

   17 Mar 2023

   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 (https://www.youtube.com/@eamonncottrell?sub_confirmation=1) where I share spreadsheet and coding tutorials? 😉 I'm hoping to grow this to 1000 subscribers this year! Episode Overview: Video Walkthrough (https://youtu.be/vMyBjyHGQ-U) Demo Google Sheet (https://docs.google.com/spreadsheets/d/1gnacOaU_TCX_I7wGxHWWriyej4kI7t9AzM_nLybv9Cs/edit#gid=1341856047) In depth article on freeCodeCamp (https://www.freecodecamp.org/news/excel-use-data-validation-and-conditional-formatting-to-prevent-errors/) 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 (https://eamonncottrell.com/) Watch me on YouTube (https://www.youtube.com/@eamonncottrell?sub_confirmation=1) @eamonncottrell Follow me on Linkedin (https://www.linkedin.com/in/eamonncottrell/)@EamonnCottrell Buy me a coffee on BuyMeACoffee (https://www.buymeacoffee.com/W4V7SRM) Laugh at me on gitHub (https://github.com/sieis)@sieis

Reach and audience

Public platform figures. Ratings count people who left a rating, not total listeners.

Apple Podcasts (US)

5.0 / 5

4 ratings

Contact I Want To Hack

Guest appearances

Does not typically book guests

Based on episode analysis; this does not confirm that the show is currently accepting guests.