I Want To Hack
35 episodes - English - Latest episode: 8 months ago - ★★★★★ - 4 ratingsWeekly discussion of coding and spreadsheets in real life business applications.
Homepage Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Episodes
Easy Web Scraping With Google Sheets
August 14, 2023 10:00 - 8 minutes - 19.5 MBHi 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 Spreadshe...
Custom Named Functions in Google Sheets
March 20, 2023 11:05 - 4 minutes - 12.4 MBHi 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 gr...
Reduce Errors with Data Validation and Conditional Formatting
March 17, 2023 15:20 - 4 minutes - 15.6 MBHi 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...
Nested Functions
February 23, 2023 19:55 - 8 minutes - 21.4 MBHi 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 ...
Grainy CSS Backgrounds
February 16, 2023 20:24 - 6 minutes - 23.1 MBHi 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 yea...
XLOOKUP and Data Sets in Google Sheets and Excel
February 10, 2023 17:30 - 6 minutes - 15.8 MBHi 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 1...
Dynamic Listing with Query in Google Sheets
February 03, 2023 20:10 - 6 minutes - 14.9 MBHi 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 ...
Validate Your Data - Multiple Selections with Apps Script
January 27, 2023 14:46 - 4 minutes - 10.9 MBHi 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 ...
Clean Your Own Data
January 20, 2023 18:01 - 5 minutes - 13.3 MBHi 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 d...
Dollar Dollar Bill Show Me The Money, Excel
January 12, 2023 20:32 - 8 minutes - 19.4 MBHi 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 f...
Less Code More Content
January 09, 2023 18:30 - 7 minutes - 17.8 MBHi 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 teach...
Design Product Release on Gumroad
March 30, 2022 13:31 - 5 minutes - 13.7 MBHi 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...
Tag and Release
February 28, 2022 20:11 - 4 minutes - 10.1 MBHi 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 Taggi...
Scattered and Plotted
February 24, 2022 19:23 - 5 minutes - 12.6 MBHi 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 Fe...
Vanilla JS FTW
February 17, 2022 14:55 - 5 minutes - 13.2 MBHi 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: 202...
Sacred Geometry
February 07, 2022 20:06 - 5 minutes - 12.1 MBHi 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...
Victory in the Time of Data
January 31, 2022 14:27 - 4 minutes - 11 MBHi 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 (fr...
Beating My Head Against A Bar Chart Wall
January 26, 2022 14:57 - 4 minutes - 11.5 MBHi 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 D...
Google Sheeting and Data Validating
January 21, 2022 14:18 - 4 minutes - 10.6 MBHi 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 yours...
MERN D3 and onClick
January 20, 2022 15:22 - 6 minutes - 15.6 MBHi 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 motivatio...
Intro to D3 Library
January 13, 2022 14:44 - 4 minutes - 11.5 MBHi 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 Chal...
100 Days of Code Day 2: D3 and RPG
January 12, 2022 20:53 - 5 minutes - 12.6 MBHi 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 Chal...
Embark
January 11, 2022 13:44 - 6 minutes - 15 MBHi 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 Cha...
Learning, Documenting, Doing and Living
September 13, 2021 14:49 - 15 minutes - 35.9 MBHi 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 ...
2021 Trailer
August 31, 2021 15:34 - 1 minute - 3.99 MBHi 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 ...
Hope
May 03, 2021 19:58 - 4 minutes - 11.8 MB♦ 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...
.ICO not Ico
November 16, 2020 22:00 - 7 minutes - 17 MB♦ 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...
Heat(around(the(corner)))
October 30, 2020 14:00 - 6 minutes - 14.3 MB♦ 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 de...
JMSTK'N
October 28, 2020 22:30 - 9 minutes - 21.3 MB♦ 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 efficientl...
CS50_go_time
October 25, 2020 16:15 - 3 minutes - 9.02 MB♦ 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 teachin...
Static Site Generators
October 20, 2020 15:30 - 9 minutes - 22.4 MB♦ 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: Static Site Generators These things are awesome. Super fast load pages with a zillion use-cases. List of Static Site Generators Hugo (which I'm currently using) GitHub Pages for hosting and deploying a simple site at [<username>.github.io] Netlify for auto-deployment from Gi...
Multiple SSH Keys for GitHub
October 15, 2020 11:00 - 7 minutes - 16.9 MB♦ 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: Multiple SSH Keys for GitHub I ran into an issue where I needed to push changes to a repository that was on a second GitHub account I created for a simple website project. I was receiving an error from the terminal in VS Code that I didn't have permission to do that. I had alrea...
java.that.hut()
March 03, 2013 21:29 - 9 minutes - 18.4 MBjava. that. hut() details Eamonn's discovery of Java scripting behind the scenes of GoogleDoc spreadsheets. Eamonn and Angela take a peek at a large spreadsheet Eamonn constructed for work and disect the functions behind it.
def random.poltergeist()
December 16, 2012 21:10 - 14 minutes - 26.8 MBEamonn and Angela fight off a poltergeist while walking listeners through two coin flipping/probability functions in Python.
Class Behemoth
December 03, 2012 14:57 - 17 minutes - 24.8 MBBe sure to listen on iTunes! So we've been in a discussion sequence centered around object-oriented programming during the last few sections of Python. Among a wealth of items that orbit over my head, we have learned about creating user-defined classes. Here's what wikipedia has to say about classes. This has been excellent, albeit slow, work. Join Angela and I as we (mostly I as she is exhausted today) rant a bit about the problem set I did defining various classes in order to implemen...