Hi Reader, Welcome to the Google Sheets Tips newsletter #387, your Monday morning espresso, in spreadsheet form! I'm traveling so no news section again this week. But don't worry, I'll have a full recap of all the relevant Google Next announcements soon. ➜ Sheets Tip #387: Do You Know How To Round Numbers To The Nearest Hundred, Thousand? We’ve all used the ROUND function to tidy up messy decimals. But do you know one of its best tricks? It works equally as well to round to the nearest ten or...
12 days ago • 1 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #386, your Monday morning espresso, in spreadsheet form! Similar to Sheets Tip #384 from a couple of weeks ago, we're keeping it light hearted with today's tip. In this case, I'm showing you one of Google Sheets' secret easter egg functions! Read on to find out what it is and what it does. ➜ Sheets Tip #386: Is your Sheet feeling crowded? Build a meadow 🐑 We’ve all been there: you’re focused on giving a demonstration in your Sheet to...
19 days ago • 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #385, your Monday morning espresso, in spreadsheet form! It's that time of year when you need hat and gloves one day and shorts and sunscreen the next. Last week, we had back-to-back days of 90°F. I'm sure it happens every Spring, but I always find it surprising how quickly the seasons change. Thankfully, we've also enjoyed plenty of days in the 60s and 70s (the preferred operating temperature of this Englishman). I...
26 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #384, your Monday morning espresso, in spreadsheet form! Normally with these Google Sheets Tips, I make them as practical as possible, so that you can apply them to your work. Today, however, I'm going to show you The Ultimate Spreadsheet Prank as a way of understanding how custom number formats work. And if that doesn't float your spreadsheet boat, well then, I don't know what will. Find this tutorial below the news...
about 1 month ago • 2 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #383, your Monday morning espresso, in spreadsheet form! NASA's Artemis II mission blasted off towards the moon last week. I watched the launch live with my son (on YouTube, not in person, haha). The launch was exhilarating; I was holding my breath for the 10-second countdown! I'm excited to follow along with the remainder of the mission and see close-up images of the moon. In fact, as I press send on this email, they are scheduled to...
about 1 month ago • 2 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #382, your Monday morning espresso, in spreadsheet form! If you feel like the AI wave is moving faster than you can keep up with, you aren't alone. The gap between "playing with a chatbot" and "building reliable AI systems" feels wider than ever, and that feeling is only increasing with every new AI announcement. For the past couple of months, I’ve been working on a new course to help address this challenge. Next Monday, I’m opening...
about 2 months ago • 2 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #381, your Monday morning espresso, in spreadsheet form! Since last week, the weather in the Mid-Atlantic region has been even more volatile than that mission critical spreadsheet your non-technical boss "fixed" recently. We had a day over 80F, followed by a wild 50F drop to temps in the 30's and snow squalls. And later today, we're forecast to have a severe thunderstorm and possible tornadoes. It's threatening enough that schools in...
2 months ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #380, your Monday morning espresso, in spreadsheet form! I read something online last week (source) that really resonated with me: Joy is a competitive superpower The author gave the example of the US figure skater Alysa Liu, who rocked a huge smile on her way to a gold medal at the recent Winter Olympics. As someone who has a tendency to take things too seriously, this was a good reminder for me to smile more and...
2 months ago • 3 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #379, your Monday morning espresso, in spreadsheet form! Anyone else feeling a little overwhelmed with everything AI these days? Every day, panicked people on Twitter are prophesying the end of white-collar jobs. And Block recently announced they are reducing their headcount by 40% (4,000 people) because of AI, so maybe they have a point. But on a visit to a new dentist last month, I still had to fill out a paper form...
3 months ago • 4 min read