4 min

Custom Named Functions in Google Sheets I Want To Hack

    • Technology

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

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

4 min

Top Podcasts In Technology

Lex Fridman Podcast
Lex Fridman
Acquired
Ben Gilbert and David Rosenthal
All-In with Chamath, Jason, Sacks & Friedberg
All-In Podcast, LLC
The Gatekeepers
BBC Radio 4
Lenny's Podcast: Product | Growth | Career
Lenny Rachitsky
Hard Fork
The New York Times