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....
10 days ago • 2 min read
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?...
17 days ago • 2 min read
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...
24 days ago • 2 min read
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...
about 1 month ago • 1 min read
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...
about 1 month ago • 2 min read
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...
about 1 month ago • 2 min read
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....
about 2 months ago • 2 min read
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...
about 2 months ago • 2 min read
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...
2 months ago • 2 min read