Episodes

Easy Web Scraping With Google Sheets

S4E10 · August 14, 2023 · 08:29

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...

Custom Named Functions in Google Sheets

S4E9 · March 20, 2023 · 04:48

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!👇Th...

Reduce Errors with Data Validation and Conditional Formatting

S4E8 · March 17, 2023 · 04:45

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 link...

Nested Functions

S4E7 · February 23, 2023 · 08:50

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 Hac...

Grainy CSS Backgrounds

S4E6 · February 16, 2023 · 06:09

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 i...

XLOOKUP and Data Sets in Google Sheets and Excel

S4E5 · February 10, 2023 · 06:31

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 lis...

Dynamic Listing with Query in Google Sheets

S4E4 · February 3, 2023 · 06:03

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 ...

Validate Your Data - Multiple Selections with Apps Script

S4E3 · January 27, 2023 · 04:12

Use Google Apps Script to allow multiple selections in your data validation drop down menus.

Clean Your Own Data

S4E2 · January 20, 2023 · 05:26

Cleaning, Trimming and Importing Data in Excel and Google Sheets. Video Walkthrough in Description 👇

Dollar Dollar Bill Show Me The Money, Excel

S4E1 · January 12, 2023 · 08:29

All about accounting formatting in Microsoft Excel.

Less Code More Content

S4Trailer · January 9, 2023 · 07:30

All about my content cadence plans for the year: 50 articles, 50 videos and 50 podcasts giving back to the coding community I've been fortunate to learn from!

Design Product Release on Gumroad

S3E12 · March 30, 2022 · 05:28

I have released another FREE product on Gumroad. Join me for a five minute overview of it and the other products/projects I'm working on this year!

Tag and Release

S3E11 · February 28, 2022 · 04:16

Learned about versioning and git tagging while releasing an official v1.0.0-beta to my Infinite Memory project.

Scattered and Plotted

S3E10 · February 24, 2022 · 05:22

Recovering from a case of stupid, I finish the D3 Scatterplot Project and rejoice!

Vanilla JS FTW

S3E9 · February 17, 2022 · 05:37

Quick run-through of a basic Javascript project I finished today! Site live: https://infinite-memory.netlify.app/

Sacred Geometry

S3E8 · February 7, 2022 · 05:18

I start another D3 visualization project and then run way into left field designing sacred geometric in Illustrator.

Victory in the Time of Data

S3E7 · January 31, 2022 · 04:45

Weekly recap of how I found my mistake in the d3 project code. Having a lot of fun with these visualization projects with more great stuff coming soon!

Beating My Head Against A Bar Chart Wall

S3E6 · January 26, 2022 · 04:54

A week long bar chart project using D3.js has almost come to an end, were it not for a frustrating final test case that currently does not work.

Google Sheeting and Data Validating

S3E5 · January 21, 2022 · 04:28

A fun discovery in Google Sheets with my 5 year old leads to a spreadsheet with Teenage Mutant Ninja Turtles referencing and multiple item selections through data validation.

MERN D3 and onClick

S3E4 · January 20, 2022 · 06:39

Recapping the last few days of 100DaysOfCode.