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 Ple...
Aug 14, 2023•8 min•Season 4Ep. 10
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 ...
Mar 20, 2023•5 min•Season 4Ep. 9
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 hop...
Mar 17, 2023•5 min•Season 4Ep. 8
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! Episo...
Feb 23, 2023•9 min•Season 4Ep. 7
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 ...
Feb 16, 2023•6 min•Season 4Ep. 6
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 subscri...
Feb 10, 2023•7 min•Season 4Ep. 5
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 Goo...
Feb 03, 2023•6 min•Season 4Ep. 4
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 men...
Jan 27, 2023•4 min•Season 4Ep. 3
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 ...
Jan 20, 2023•5 min•Season 4Ep. 2
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 opt...
Jan 12, 2023•8 min•Season 4Ep. 1
Hi there! Thanks for listening , and 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: Welcome to 2023! A quick recap since we last met in March of 2021. We've had our fourth child since then (hence the long show hiatus), and I've zeroed in on content creation and teaching outlets f...
Jan 09, 2023•8 min
Hi there! Thanks for listening , and I hope you'll subscribe to follow along on my journey! Episode Overview: A walkthrough of publishing my second digital product of the year: Sacred Geometry . I discuss my motivations for this type of design-centric product as well as describe the process I went through to create and iterate it. Also, why I made it FREE . I give my brief take on using the Gumroad platform and on my continued product & project creation for 2022. Below is the link to my blog...
Mar 30, 2022•5 min•Season 3Ep. 12
Hi there! Thanks for listening , and I hope you'll subscribe to follow along on my journey! Episode Overview: I have officially released Infinite Memory and submitted it to Hashnode + Netlify's Feb 2022 Hackathon . I also learned how to release a proper version of a codebase on Github which led me down a brief educational rabbit hole in Git's documentation and resulted in a short blog post as well. Resources mentioned: My Hashnode Blog Git Tags and Versioning Blog Post Git Tagging Documentation ...
Feb 28, 2022•4 min•Season 3Ep. 11
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: Finished the freeCodeCamp Scatterplot Project! As usual, it was some small mistakes that were preventing me from passing all the tests a couple weeks ago. It always pays dividends to walk away from something (when possible) and come back with a fresh perspective! I also have some additional functionality to add to the Infinite Memory Verse Site to get it ready to submit to Hashnode's February Hackath...
Feb 24, 2022•5 min•Season 3Ep. 10
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: Finished up the memory verse vanilla js website I've been working on. Check it out. I also live streamed the recording of this podcast. Been enjoying some Twitch lately; find links to follow below! Resources mentioned: Infinite Memory Verse Site Preview of my Sacred Geometry iPhone Wallpaper Collection freeCodeCamp Data Visualization Links for the coding challenge I'm doing: 2022 Web Developer Challe...
Feb 17, 2022•6 min•Season 3Ep. 9
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: I began another scatterplot project, but then decided to spend a fair amount of time producing geometric designs in Adobe Illustrator in the same vein as line drawings I used to love doing with pen, paper and ruler. (no spirograph for me!) Resources mentioned: Preview of my Sacred Geometry iPhone Wallpaper Collection freeCodeCamp Data Visualization Links for the coding challenge I'm doing: 2022 Web D...
Feb 07, 2022•5 min•Season 3Ep. 8
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: Victory is mine! I've found and corrected the error which I couldn't figure out last episode in my bar chart. Resources mentioned: D3js.org Tutorials Teacher D3 reference My completed project on CodePen freeCodeCamp Data Visualization Links for the coding challenge I'm doing: 2022 Web Developer Challenge 100 Days of Code freeCodeCamp freeCodeCamp Become A Dev Challenge Log (free Google spreadsheet I ...
Jan 31, 2022•5 min•Season 3Ep. 7
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: Been having a blast learning D3 over on freeCodeCamp. I walk through an overview of my current project and what remains to complete it. Including discussion of the joy that comes from solving frustrating problems. Resources mentioned: D3js.org My current project on CodePen freeCodeCamp Data Visualization Links for the coding challenge I'm doing: 2022 Web Developer Challenge 100 Days of Code freeCodeC...
Jan 26, 2022•5 min•Season 3Ep. 6
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: Had a ton of fun with my five year old building a spreadsheet and then learning some new stuff myself as he wanted to select multiple values using data validation . I looked up a custom script to do it, implemented it and then did a short video walkthrough of how to go about it yourself! Resources mentioned: YouTube Video Walkthrough The Custom Google Sheet (you can copy and use yourself!) Links for ...
Jan 21, 2022•4 min•Season 3Ep. 5
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: Days 4-7 of my #100DaysofCode & Web Developer Challenge. A quick run through of what I've been working on the past few days. Resources mentioned: D3 library MERN tutorial on MongoDB 2022 Web Developer Challenge 100 Days of Code freeCodeCamp Data Visualization Certification freeCodeCamp Become A Dev Challenge Log (free Google spreadsheet I made for you to track your own motivations, notes and prog...
Jan 20, 2022•7 min•Season 3Ep. 4
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: Day 3 of my #100DaysofCode & Web Developer Challenge. I get excited about data visualization on the web. I've done a lot of this in spreadsheets and dabbled in Tableau during the course of Google's Data Analytics Certificate that I took last year, but it was a lot of fun to begin combining the visualizations with web development! Resources mentioned: D3 library 2022 Web Developer Challenge 100 Da...
Jan 13, 2022•5 min•Season 3Ep. 3
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: Day 2 of my #100DaysofCode & Web Developer Challenge. I discuss my intrinsic motivations to do this, how I'll be combining my current business background with my ongoing desire for digital entrepreneurship, and what the next 100+ days of the coding challenge will look like. Resources mentioned: 2022 Web Developer Challenge 100 Days of Code freeCodeCamp freeCodeCamp Become A Dev Challenge Log (fre...
Jan 12, 2022•5 min•Season 3Ep. 2
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: I'm starting the 2022 Web Developer Challenge and in this episode I discuss my intrinsic motivations to do this, how I'll be combining my current business background with my ongoing desire for digital entrepreneurship, and what the next 100+ days of the coding challenge will look like. I made a Google Sheet here to track your own motivations, notes and progress for the Web Developer Challenge. Make a...
Jan 11, 2022•7 min•Season 3Ep. 1
Hi there! Thanks for listening , and I hope you'll follow along on my journey! Episode Overview: This episode walks through how I've been structuring my web development life within my hopefully healthy life of work, family and recreation. It's already a full plate, but I do aspire to continue learning and creating, and I believe there's enough margin to do some of it all! Hugo Static Site Course Trailer & Playlist This Season Overview: I'm going to be trying to make money on the internet as ...
Sep 13, 2021•15 min•Season 2Ep. 1
Hi there! Thanks for listening , and I hope you'll follow along on my journey! I'm going to be trying to make money on the internet as supplementary income this year. I'll be trying out at least 7 different ways to do this including: Software as a Service Digital Products Digital Services Traditional Products Drop Shipping Educational Products Contract Work. I would love to hear from you! Find me on eamonncottrell.com Follow me on Twitter @EamonnCottrell Follow me on Linkedin @EamonnCottrell Fol...
Aug 31, 2021•2 min•Season 2Ep. 1
♦ Connect! I'd love to say hey; follow me over on Twitter . Want to show the show some quick love? Thank you! You can buy me a coffee here. Please leave a review on Apple Podcasts! ♥ This week's episode: Hope Some reflections and encouragement regarding Crucifying Complacency Computer Programming Lifelong Learning Community Hope ♠ I Want to Hack I Want to Hack began documenting my desire to code and explore software engineering in the early 2012's, and re-emerged in 2020 after many years of work...
May 03, 2021•5 min•Season 1Ep. 14
♦ Connect! I'd love to say hey; follow me over on Twitter . Want to show the show some quick love? Thank you! You can buy me a coffee here. Please leave a review on Apple Podcasts! ♥ This week's episode: ICO not ICO Some small but fun things this week so far. I do love the satisfaction of finding out how to do the little stuff. It irked me recently why my github pages site displays a generic, lame preview without any image when I share the link with anyone via text. Well, all it takes is a littl...
Nov 16, 2020•7 min•Season 1Ep. 13
♦ Connect! I'd love to say hey; follow me over on Twitter . Want to show the show some quick love? Thank you! You can buy me a coffee here. Please leave a review on Apple Podcasts! ♥ This week's episode: Heat(around(the(corner))) The journey continues into algorithms in CS50, and I'm hoping to knock out a brief rebuild of my personal site using the JAMstack this weekend.Some thoughts today on finite time and the infinite possibilities in this world of computer science and web development. Stayin...
Oct 30, 2020•6 min•Season 1Ep. 12
♦ Connect! I'd love to say hey; follow me over on Twitter . Want to show the show some quick love? Thank you! You can buy me a coffee here. Please leave a review on Apple Podcasts! ♥ This week's episode: JMSTK'N Some things dismal; some phenomenal. And with CS50 progress still underway, a combination of the two in many cases. I have found a great intrigue with the Jamstack and specifically this past week with Stackbit, a tool to spin up jamstack sites super easily and efficiently. I powered thro...
Oct 28, 2020•9 min•Season 1Ep. 11
♦ Connect! I'd love to say hey; follow me over on Twitter . Want to show the show some quick love? Thank you! You can buy me a coffee here. Please leave a review on Apple Podcasts! ♥ This week's episode: CS50_go_time Widely regarded as a premier introduction to computer science, my own knowledge, though currently broader in scope, will no doubt benefit from the wealth of topics and deep dives into the subject. I've been attracted to the course and the professor's dynamic teaching style for many ...
Oct 25, 2020•4 min•Season 1Ep. 10
