Merry Querying

CODING & SPREADSHEETS
Deck the Halls with QUERIES

Since last we spoke I’ve…

1. Run a couple half marathons (of my own making)

2. Analyzed a collectible card game that I will probably not own or play (Lorcana)

3. Cooked an incredible dish that I should make weekly (breakfast hash deluxe)

Now to the sheets…

In the world of coding and spreadsheets, I've dropped a couple new videos on my YouTube channel.

Countdown Spreadsheet

The first is a guided walkthrough of making a Christmas Countdown sheet. NO APPS SCRIPT, either. So, don't be scared. It just uses a few handy built-in functions

Here's the full video (18 minutes):

QUERY Like a Boss

And the second, is a quick walkthrough of Querying one spreadsheet from another sheet.

Again, there's no Apps Script, it's just an exercise in combining a couple built in functions to link spreadsheets together.

This comes in handy especially if you want to have your data completely separated from the sheet you're working in.

Here's that video (3 minutes):

Thank you so much!

It means a lot that you’ve read this, and I hope it’s informed and/or entertained you for a few moments today!

Would love to say hi. Here are the best places to find me:

✉️ LinkedIn
📺️ YouTube

Ways I can help:

• View my spreadsheet and creative products on my Gumroad store.

• Need a powerful automation tool for Google Sheets? Try Coefficient to automatically import data and sync with your business systems.

• Hire an expert to help complete your next Google Sheets, Apps Script or Google Workplace project.