I Want To Hack

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 Playlist
• Spreadsheet Example

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 @eamonncottrell 
• Subscribe to my newsletter
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh at me on gitHub @sieis
• Find me on my site

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 Walkthrough
• Demo Google Sheet
• In depth article on freeCodeCamp

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
• Watch me on YouTube @eamonncottrell 
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh 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 Walkthrough
• Demo Google Sheet
• In depth article on freeCodeCamp

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
• Watch me on YouTube @eamonncottrell 
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh at me on gitHub @sieis

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 values
• 30sec YouTube Short preview
• In depth article on freeCodeCamp
• Find me on my site
• Watch me on YouTube @eamonncottrell 
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh at me on gitHub @sieis

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 Backgrounds
• 15sec YouTube Short
• Arc site
• Grainy Gradient Playground
• In depth article
• feTurbulence MDN docs
• URL encoder for inline CSS
• Find me on my site
• Watch me on YouTube @eamonncottrell 
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh at me on gitHub @sieis

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 More
• Example Google Sheet with the Code
• In depth article
• Find me on my site
• Watch me on YouTube @eamonncottrell 
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh at me on gitHub @sieis

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 List
• Example Google Sheet with the Code
• In depth article
• Find me on my site
• Watch me on YouTube @eamonncottrell 
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh at me on gitHub @sieis

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 Validation
• Example Google Sheet with the Code
• In depth article
• Find me on my site
• Watch me on YouTube @eamonncottrell 
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh at me on gitHub @sieis

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:

A dive into dirty data. Why is it not clean already? Why do we need it to be "clean"? In this week's episode we discuss a few built in functions and features that enable us to get our data nice and clean!

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:

• Clean and Trim Data Walkthrough Video
• Read my accompanying articles on freeCodeCamp
• Find me on my site
• Watch me on YouTube @eamonncottrell 
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh at me on gitHub @sieis

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:

This week's topic has been Accounting and Currency formatting in Microsoft Excel. I discuss how to access these formatting options using the trusty point-and-click method as well as by using keyboard shortcuts and keyboard combos.

I've tried each year to continue to increase my productivity with spreadsheets and learning keyboard shortcuts and combos has continued to pay dividends in that regard.

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:

• Currency vs Accounting video on YouTube
• Accounting and Currency Formatting article on freeCodeCamp
• Find me on my site
• Read me on freeCodecamp
• Watch me on YouTube @eamonncottrell 
• Follow me on Linkedin @EamonnCottrell
• Buy me a coffee on BuyMeACoffee
• Laugh at me on gitHub @sieis