I Want To Hack

Eamonn Cottrell

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

  1. 14/08/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 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

    8 min
  2. Custom Named Functions in Google Sheets

    20/03/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 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

    5 min
  3. Reduce Errors with Data Validation and Conditional Formatting

    17/03/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 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

    5 min
  4. Nested Functions

    23/02/2023

    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

    9 min
  5. Grainy CSS Backgrounds

    16/02/2023

    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

    6 min
  6. XLOOKUP and Data Sets in Google Sheets and Excel

    10/02/2023

    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

    7 min
  7. Dynamic Listing with Query in Google Sheets

    03/02/2023

    Dynamic Listing with Query in Google Sheets

    Hi there! We are building a dynamic daily task list in Google Sheets this week! 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 a dynamic daily task list created in Google Sheets using the =QUERY() function to pull certain data from another tab into a dashboard on the main page depending on what day it is. 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 Dynamic Daily Task ListExample 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

    6 min
  8. Validate Your Data - Multiple Selections with Apps Script

    27/01/2023

    Validate Your Data - Multiple Selections with Apps Script

    Hi there! 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:We walk through how to create an Apps Script code to have multiple selection capabilities in the data validation drop down menus in Google Sheets. This isn't available out of the box, but I came across a great solution originally coded by Alexander Ivanov and applied it to my own sheets. 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 Multiple Selection Data ValidationExample 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

    4 min
Tout afficher (35)

Bande-annonce

5
sur 5
4 notes

À propos

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

Informations

  • Création
    Eamonn Cottrell
  • Années d’activité
    2012 - 2023
  • Épisodes
    35
  • Classification
    Tous publics
  • Copyright
    © 2023, Eamonn Cottrell. All rights reserved.
  • Site web de l’émission
    I Want To Hack