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...
13 days 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...
20 days 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...
27 days 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,...
about 1 month 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...
about 2 months ago • 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #361, your Monday morning espresso, in spreadsheet form! I'm excited to share today's tip with you. I came across it years ago but then forgot about it until today. And I'm kicking myself because it's so useful! I'm pretty sure I'll be using it on a daily basis now... read on to find out what it is. ➜ News I.Last week, Google announced a significant enhancement to formula generation in Gemini for Sheets, making the...
about 2 months ago • 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #360, your Monday morning espresso, in spreadsheet form! Last week I shared that I'm working on a new online course called Modern Google Sheets. I've now recorded 90% of the videos and edited about 65% of them so it's progressing well. After they're finished, I'll upload them to Teachable (the online school platform), prepare the templates, and add some challenge questions. I'm excited to get this course out into the...
2 months ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #359, your Monday morning espresso, in spreadsheet form! Have you noticed how much Google Sheets has changed in the past couple of years? We tend to think of spreadsheets as static tools, but that's just not the case. When I open a Sheet today I invariably use Tables and AI tools, both of which weren't available a few years ago. So I’ve been building something new to help you get fully up to speed with the modern way...
2 months ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #358, your Monday morning espresso, in spreadsheet form! Today's tip comes from an accidental discovery I made whilst researching a trick with the LEFT and RIGHT functions. Let me ask you... What do you think happens with this formula? (Answer before trying it in your Sheet ;) ) = "A" < "B" Answer #VALUE! error TRUE #NUM! error Check out the answer in today's tip and see a real-world application below. ➜ News I.Google...
3 months ago • 2 min read