Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #370, your Monday morning espresso, in spreadsheet form! This is the last Google Sheets Tips email for 2025. We're taking a break from publishing for the holidays and will return with Tip 371 on 5th January 2026. Thank you so much for reading and replying to these emails. I love learning from all of you when you write back and share your own tips and tricks (and occasional corrections! π ). In the meantime, I wish you...
24 days agoΒ β’Β 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #369, your Monday morning espresso, in spreadsheet form! We had our first snowfall of the season last Friday, so winter is definitely underway here in the Mid-Atlantic region. It was only a light dusting though, so the sleds are still hanging in the garage. For now. In this issue, we're looking at a clever way to add visual clues to our data tables with indicator arrows β²π». And, if you're a Workspace customer, you must...
about 1 month agoΒ β’Β 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #368, your Monday morning espresso, in spreadsheet form! I finished reading a fascinating book last week, Home on the Canal, a long-out-of-print history of the Chesapeake and Ohio Canal and the stories of the people who lived and worked along it. Today, I live beside the canal, now a beautiful National Historic Park, and cycle or walk on the restored towpath most weeks. Riding across the Antietam Aqueduct recently, I...
about 2 months agoΒ β’Β 3 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #367, your Monday morning espresso, in spreadsheet form! For my birthday this year, my wife bought me a half-day fly fishing lesson. I had previously tried casting with a fly rod a few years ago in Wyoming, and have been keen to have another go ever since. As a middle-aged dad, my life is, well... maybe a little... predictable. In a good way. Family, work, exercise outdoors, eat, sleep, and repeat. It's a wonderful,...
about 2 months agoΒ β’Β 3 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #366, your Monday morning espresso, in spreadsheet form! β News I.Gemini in Google Sheets can now analyze data across multiple tables. Excellent news! Read more here >> II.Google's Gemini Deep Research now integrates with your Workspace content, including Sheets. (This is only available for paid Workspace accounts.) Read more here >> β Sheets Tip #366: Stack lists with the magic of TOCOL Suppose we have lists of names like this: In this...
about 2 months agoΒ β’Β 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #365, your Monday morning espresso, in spreadsheet form! Fall is beautiful on the Eastern seaboard of the US right now. The colors near me are peaking in an explosion of reds, oranges, purples, and yellows: β News I.More powerful pivot tables now available in Connected Sheets. Connected Sheets lets you use the Sheets interface to analyze BigQuery data (huge datasets with millions of rows). Read more here >> II.Google...
2 months agoΒ β’Β 1 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #364, your Monday morning espresso, in spreadsheet form! Thanks to the hundreds of you who signed up for the Modern Google Sheets course last week. I'm excited to teach the workshops, which start next week. And thanks for your patience with the extra course promotion emails. We're now back to business as usual, with the once-a-week Google Sheets Tips newsletter. Lastly, Happy Halloween! It's a fun night here in our little town. Most of...
2 months agoΒ β’Β 1 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #363, your Monday Tuesday* morning espresso, in spreadsheet form! (* arriving in your inbox on a Tuesday, because it was Columbus Day in the US yesterday.) Almost two years ago, I launched a course called "The AI Playbook for Google Sheets", which explored how to use basic AI inside Sheets. (Fun fact: this was my last course launch!) A lot has changed since then! Today, Gemini and other AI tools can manipulate data, generate formulas,...
3 months agoΒ β’Β 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #362, your Monday morning espresso, in spreadsheet form! Last week I finished recording and editing all the video lessons for the new Modern Google Sheets course (woohoo!). I keep track of progress in a Google Sheet (where else of course!) using Tables and dropdown chips: (click to enlarge) I'm using Tables extensively now in my Sheets work. I find the benefits over plain dataβsuch as the dropdown chips, table...
3 months agoΒ β’Β 1 min read