Hi Reader, Welcome to Future Proof #4 (formerly the Google Sheets Tips newsletter), your Monday morning espresso, in AI form! My son and I had some fun 3-D printing over the weekend. I printed a rugged case to hold my Field Notes journals (see the finished result at the end of this email). The print run just beginning. It's impressive to watch something grow from nothing, although since the full print took around 3 hours I didn't watch the whole thing ;) And now, perhaps more than ever...
7 days ago • 2 min read
Hi Reader, Welcome to the Future Proof #3 (formerly the Google Sheets Tips newsletter), your Monday morning espresso, in AI form! Here in the Mid-Atlantic region, fall has arrived with cooler temperatures, blustery winds, and grey, rainy days. (As a Brit, it makes me feel right at home!) That means it's officially the end of the shorts-as-the-default-choice season. And, there's a riot of color coming our way over the next few weeks as the maple trees put on a show 🍁. Today, I'm sharing a tip...
14 days ago • 2 min read
Hi Reader, Welcome to the Future Proof #2 (formerly Google Sheets Tips), your Monday morning espresso, in AI form! Sorry this second issue is a day late. I was really sick at the end of last week and over the weekend, so even though the newsletter was largely written, I wasn't well enough to write this intro and press send yesterday. So, here it is. Thanks for all the kind responses last week when I introduced the new format. It seems like the majority of you understand the pivot and are...
20 days ago • 2 min read
Hi Reader, Welcome to Future Proof (formerly the Google Sheets Tips newsletter), your Monday morning espresso, in spreadsheet AI form! I published the first Google Sheets Tips newsletter in April 2018, a lifetime ago in technology terms. The mission was simple: one practical, actionable lesson each week to help you work more effectively. That mission hasn't changed. Lately though, more and more of you are turning to AI to get things done. And if you're anything like me, you're finding that...
28 days ago • 3 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #400, your Monday morning espresso, in spreadsheet form! Well, this is it folks... This is the final issue of the Google Sheets Tips newsletter. (I will continue sending a weekly tech tutorial newsletter. Just that the format and the focus will be changing.) So then. The end of an era. I think this is where I'm supposed to write something profound and wax lyrical about how life-changing it's all been, blah, blah, blah. But I've always...
about 1 month ago • 4 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #399, your Monday morning espresso, in spreadsheet form! This is the penultimate issue of the Google Sheets Tips newsletter. You may recall from one of my emails earlier in the summer that I mentioned changing this newsletter. Recently, I decided that issue 400 was a nice milestone to reach and a good place to close the curtain on these dedicated Google Sheets tips. So the final issue of the Google Sheets Tips newsletter—#400—will be...
about 1 month ago • 2 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #398, your Monday morning espresso, in spreadsheet form! Everyone loves a pretty dashboard, right? But building dashboards in Google Sheets is difficult and involves lots of finicky formatting tricks. And even then, it won't look or perform as well as a professionally-developed web dashboard. Well... no longer! Today we're looking at the biggest update to Google Sheets since, well, forever. Google have launched a new Gemini-powered...
about 2 months ago • 2 min read
Hi Reader, Happy End-of-the-Summer-Holidays! ☀️ Welcome to the Google Sheets Tips newsletter #397, your Monday morning espresso, in spreadsheet form. Today I'm sharing three conditional formatting techniques that will help you really understand how conditional formatting works. Conditional Formatting is formatting applied to your data that changes as certain conditions are met. It's a super useful concept to understand. Check it out below. Recently in my household, we've been focussed on...
about 2 months ago • 4 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #396, your Monday morning espresso, in spreadsheet form! Today I'm sharing 3 killer tips for pivot tables. I would still argue that Pivot Tables are THE killer feature of spreadsheets. Their ability to quickly and simply generate insights about your data is unmatched. So it makes sense to learn how to use them to their fullest. Today, I'm sharing three under-the-radar tips for using pivot tables. All 3 are very simple...
2 months ago • 3 min read