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 320: Bet you didn't know you could do this with pivot tables...

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #320, your Monday morning espresso, in spreadsheet form! I'm currently experimenting with Google Gemini and ChatGPT to write my Google Sheets formulas and do data analysis. They do a much better job now than they did even just 6 months ago. The way we work with spreadsheets will change fundamentally in the next couple of years. I'll share results from these experiments with Sheets Insiders members in Thursday's email....

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #319, your Monday morning espresso, in spreadsheet form! My wife and I took our two young sons on a backpacking trip along the Appalachian Trail this weekend. We hiked in 4 miles on Saturday to a shelter, camped the night, and walked back the next day. It was a lot of fun and we made a lifetime memory on what would have been an otherwise regular weekend. It was also a good reminder of that old adage "beauty is in the...

Using the QUERY function to sample data

Hi Reader, Welcome to the Google Sheets Tips newsletter #318, your Monday morning espresso, in spreadsheet form! I have a fun data tip for you today, involving a secret feature of the QUERY function. Find that below. But first... Today is a special day because my new Sheets Insiders membership program is officially open for enrollment! Sheets Insiders is a membership program designed to help you work more effectively with Google Sheets and Apps Script. As a member of Sheets Insiders, you get...

Hi Reader, Welcome to the Google Sheets Tips newsletter #318, your Monday morning espresso, in spreadsheet form! I have a fun data tip for you today, involving a secret feature of the QUERY function. Find that below. Have a fabulous week! ➜ News I.Two of the newer features in Google Sheets — Conditional Notifications and Google Tables — are now integrated. Conditional notification rules can now apply to Tables and work with Table names. Some common notification rules will be pre-built into...

MROUND function in Google Sheets

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #317, your Monday morning espresso, in spreadsheet form! I hope your week is off to a fabulous start. My youngest son is sports-mad. From the moment he wakes up until he falls asleep, he's got a bat and ball in his hands or a football at his feet. Currently, he's obsessed with pickleball, the funny, new version of tennis that's sweeping across the US. So I spent much of this weekend just gone whacking a ball around in...

Brought to you by: Hi Reader, Happy Monday! Welcome to the Google Sheets Tips newsletter #316, your Monday morning espresso, in spreadsheet form. Today we're looking at a new feature in Sheets. Google recently added a multi-select option to dropdown menus. It's a welcome update that makes an already great feature even better. It adds another dimension to interactivity with Sheets and, when combined with the new tables format, makes our data much richer. Hopefully, by now, you've all got...

Lightning strike at sea

Hi Reader, Welcome to the Google Sheets Tips newsletter #315, your Monday morning espresso, in spreadsheet form! I want to start by sharing this extraordinary photo with you: It was taken last week off the coast of Barcelona. You can see a sailing yacht in the bottom right corner, rather too close for comfort. (Here's what it looked like to the sailors onboard!) But this is no ordinary sailing yacht. It's Luna Rossa, the Italian entry in the 37th America's Cup, the oldest international sports...

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #314, your Monday Tuesday* morning espresso, in spreadsheet form! * arriving on a Tuesday because yesterday was a public holiday in the US (Labor Day) In case you missed it, last week I sent an email about a new membership program I'm launching soon. Over the next few weeks I'm going to send some behind-the-scenes emails with all the details about this program. If you're interested, click here to get them (Does not...

Type @ followed by date to bring up the date menu in a cell of Google Sheets

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #313, your Monday morning espresso, in spreadsheet form! I published my first Google Sheets tutorial 10 years ago, in October 2014. Wow, time flies! Since then, I’ve published 250+ free tutorials on my website, 313 editions of this newsletter, and 21 online courses. We live in an amazing age where it’s possible for an individual contributor to reach a global audience with their ideas. I’m incredibly grateful to be able...

Right click menu to get link to a cell

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #312, your Monday morning espresso, in spreadsheet form! My sons go back to school this week and I'm looking forward to getting back to a regular routine. The summer was amazing but loooong. After 11 weeks, we're all ready for school to begin. In this newsletter, we're looking at how to use hyperlinks in Google Sheets. And, if you're an advanced user, I've got a spicy formula for you at the end of the newsletter....