Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #327, your Monday morning espresso, in spreadsheet form! Recently a reader asked about a problem importing data from one Sheet to another when the sheet names were changing. Below, we look at how to solve this and see yet another benefit of the new Google Tables feature. My family and I spent the weekend at Fairmont University in West Virginia, where my eldest son was competing in a Lego robotics competition. With his...
18 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #326, your Monday morning espresso, in spreadsheet form! Last week, we looked at the concept of "walking the first row" to understand your data. This week, we're pairing that with the Column Stats tool. Using both of these techniques will ensure you have a full understanding of what's in your dataset and a good sense of the metrics (e.g. row count). Check it out below! Also, there is no Google Sheets Tips email next...
about 1 month ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #325, your Monday morning espresso, in spreadsheet form! Finally, an AI invention that has me truly excited... Behold the AI-powered laundry robot 🤖 Thank you boffins, this is more like it! How long until we can get one? Imagine what we could all do with those extra hours each week... In today's newsletter, I'm sharing a piece of advice that a mentor gave me early in my career. It's brilliant in its simplicity and has...
about 1 month ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #324, your Monday Tuesday morning espresso, in spreadsheet form! Coming to you on a Tuesday this week because yesterday was Veterans Day in the US and Remembrance Day in many other countries. You know when a product is good when you find yourself still using it weeks later, and not even thinking about it. So it is with the new Tables in Google Sheets. More often than not, I've found myself reaching for that "Format >...
about 2 months ago • 3 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #323, your Monday morning espresso, in spreadsheet form! Today's tip is a simple one, but it's super useful. I first shared it six(!) years ago, almost to the day, in tip 23. I'm bringing you an updated version of the tip today, with the addition of a shortcut for Gemini AI. Brought to you by: Formulas HQ Make Sheets Easy Again We’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Work smarter,...
about 2 months ago • 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #322, your Monday morning espresso, in spreadsheet form. After last week's elegant FILTER formula, I have another elegant FILTER formula for you. How lucky are you!?! ;) That wasn't by design though. I thought I had an idea for this week until I checked the newsletter archives and realized I'd covered it back in February 2024 as tip 290. So I searched my email correspondence related to that tip and found a goldmine of...
2 months ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #321, your Monday morning espresso, in spreadsheet form! Halloween is just around the corner and it's huge deal if: 1) you have kids, and 2) you live in America. It's one of the biggest nights of the year, no joke. In my 20s and 30s, before children and living in the UK, it mostly just passed me by ;) But here we are, busy preparing our costumes. This year my sons have chosen LEGO as the theme. Rest assured I'll share...
2 months ago • 3 min read
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....
2 months ago • 2 min read
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...
3 months ago • 2 min read
