Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #343, your Monday morning espresso, in spreadsheet form. Thanks for all the well wishes I received to last week's email! I'm two weeks into the recovery from sinus surgery and things are slowly but surely returning to (a new) normal. I'm taking daily walks around my neighborhood, going slightly further each day. For the first couple of days I needed my wife as a support to hold on to, as I shuffled up and down the...
12 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #342, your Monday morning espresso, in spreadsheet form! Whew, it's been quite the week in my household. Last week I had sinus surgery to alleviate some long-standing sinus issues I've had. It was a nearly 6-hour surgery so I was completely out-of-it for a day or two afterwards. When I came round they asked if I wanted a drink. I said "some water" but I couldn't speak clearly because of the bandages etc. The nurse...
19 days ago • 2 min read
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...
26 days ago • 2 min read
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....
about 1 month 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?...
about 1 month 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...
about 2 months 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 2 months 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...
2 months 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...
2 months ago • 2 min read