I Want To Hack Eamonn Cottrell
-
- Technology
Weekly discussion of coding and spreadsheets in real life business applications.
-
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 where I share spreadsheet and coding tutorials? 😉
Episode Overview:
Video PlaylistSpreadsheet ExamplePlease 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 @eamonncottrell Subscribe to my newsletterFollow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieisFind me on my site -
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 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 freeCodeCampGoogle 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 siteWatch me on YouTube @eamonncottrell Follow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieis -
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 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 -
Nested Functions
Hi there! We are discussing nesting functions in Google Sheets 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:I had a question in the comments on my most watched video asking how to count unique values in a comma-separated list. I was intrigued and made it my topic of conversation this week!
Here’s the functions we used: =UNIQUE(SORT(TRANSPOSE(SPLIT(JOIN(", ",A2:A),", ",FALSE))))
=COUNTIF(SPLIT(JOIN(", ",$A$2:$A),", "),E19)
The links to my video walkthrough and article are available below.
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!
Resources mentioned:
Video Walkthrough of nesting functions and finding unique values30sec YouTube Short previewIn depth article on freeCodeCampFind me on my siteWatch me on YouTube @eamonncottrell Follow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieis -
Grainy CSS Backgrounds
Hi there! We are discussing how to add a grainy effect to our CSS backgrounds this week. Full video walkthrough and article in the links below 👇
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:I found a couple of cool ways to add a grainy-ness to solid background colors. I talk about them in the pod this week, and go through them in detail in the accompanying article and video.
The links to my video walkthrough and article are available below.
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!
Resources mentioned:
Video Walkthrough for Grainy CSS Backgrounds15sec YouTube ShortArc siteGrainy Gradient PlaygroundIn depth articlefeTurbulence MDN docsURL encoder for inline CSSFind me on my siteWatch me on YouTube @eamonncottrell Follow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieis -
XLOOKUP and Data Sets in Google Sheets and Excel
Hi there! We are using LOOKUP functions in Google Sheets and Excel this week! We're focused on the XLOOKUP in the pod, but all are explained in the video linked below 👇
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:Walking through the functionality of the XLOOKUP function in both Excel and Google Sheets. XLOOKUP was added by Microsoft in 2019 as a successor to VLOOKUP and HLOOKUP. Google Sheets added it in 2022. It combines the best features of VLOOKUP and HLOOKUP, and is able to be used as either a vertical or horizontal lookup function itself. It's become my favorite way to lookup data. What about you?
The links to my video walkthrough and the Google Sheet we're using are available below.
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!
Resources mentioned:
Video Walkthrough for XLOOKUP and MoreExample Google Sheet with the CodeIn depth articleFind me on my siteWatch me on YouTube @eamonncottrell Follow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieis