profile

Google Sheets Tips

Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.

Featured Post

Sheets Tip 341: A, B, C, D, E - Letter Lists with Clever Formulas

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #341, your Monday morning espresso, in spreadsheet form! Hope you're out enjoying the beautiful Spring weather 🌱🌼 if you're in the Northern Hemisphere. And Fall if you're down south! ➜ News I.In case you missed it earlier in the month, I've now put the replay from the live Lambda Functions website on YouTube. Watch "Unlocking the Secrets of Lambda Functions" and grab the template for free here: II.My friend, and fellow...

Split function in Google Sheets

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #340, your Monday morning espresso, in spreadsheet form! I was reminded this week of the power of consistency. In January, I set a goal in Strava to ride my bike 3 times a week. Nothing crazy, but it's what I can realistically fit in with current work and family commitments. Aside from a few weeks of sickness and snow in January, I've done a pretty good job at sticking to it. And yesterday, I could notice a difference....

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #339, your Monday morning espresso, in spreadsheet form! I have a favor to ask. If you enjoy this newsletter, or my courses, videos or membership, will you help me improve them? It's been a while since I've run a full audience survey, and I'd love to get some fresh insight into any challenges you have using Sheets, how you use AI, how I can help, etc. Can you spare a few minutes to fill out my 2025 audience survey?...

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #338, your Monday morning espresso, in spreadsheet form! After a last bite from winter last week, it looks like spring is finally here where I live on the east coast of the US. The daffodils are growing, the box turtles are out sunning themselves on logs by the river, and temperatures are forecast in the 70s (in the 20s celcius). Wherever you are, I hope you're enjoying the changing of the seasons. ➜ News I.Google...

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #337, your Monday morning espresso, in spreadsheet form! I'm sharing a simple pivot table trick today that's one of those hidden gems in spreadsheets. Once you know it, you'll never go back. Suppose you create a complex pivot table and you want to create a second version so you can try a different filter perhaps. Well, today's trick lets you quickly duplicate the pivot table, rather than having to build again from the...

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #336, your Monday morning espresso, in spreadsheet form! This week, we're looking at use cases for the text rotation tool. I don't use it often but it's a nice technique for styling your Sheets. I've used it to add branding to my Sheets (see use case 2 below). Find tip #336 below our sponsor message and a few articles to share from the spreadsheet world. Brought to you by: BudgetSheet Save Time This Tax Season With...

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #335, your Monday morning espresso, in spreadsheet form! Today, I'm sharing some formulas that I use all the time: date formulas. I do a lot of project management planning in Sheets so I'm always needing to generate sequences of dates. Below, you'll find a roundup of the most useful. But first, I'm delighted to share today's sponsor with you. If you're serious about working with data then learning how to code with the...

A map of data hosted in Google Sheets

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #334, your Monday morning espresso, in spreadsheet form! I don't know about you but I LOVE MAPS. It might be because my hobbies—cycling, hiking, climbing—mostly revolve around backcountry travel, of which maps are an intrinsic part of the game. From as early as I can remember, I've had an affinity for maps. So, I'm excited to share today's tip. It marries my professional work and personal use cases for Google tools....

URL tricks for Google Sheets

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #333, your Monday morning espresso, in spreadsheet form! This might be one of the most useful newsletters I've written. And I can't believe I've waited this long (7+ years!) to cover this topic. I'm sharing 10 incredibly useful modifications you can make to your Google Sheets URLs to change how they behave. You can share your Sheet as a template, in a minimal editor, or save as a PDF, and more. Find it all below in tip...

OpenAI Operator + Google Sheets

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #332, your Monday morning espresso, in spreadsheet form! Today I have a quick and easy tip to share with you. It's a useful, but probably underused, feature of Google Sheets that makes it super easy to find things in the menus. Check it out below. But before that, I want to share my latest AI + Sheets experiment. At the end of last week, OpenAI launched Operator, an AI agent tool that can browse websites and perform...