Hi Reader, Welcome to the Google Sheets Tips newsletter #395, your Monday morning espresso, in spreadsheet form! I moved house last week. 🏡 It's a lot of work to pack up a house and set up a new one. And it's amazing how much stuff you accumulate, especially when: 1) you've lived somewhere for a long time, and 2) have children. A move is the perfect opportunity to declutter and get rid of stuff that isn't serving you anymore. We had a big yard sale (aka a jumble sale for my outside-the-US...
11 days ago • 2 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #394, your Monday morning espresso, in spreadsheet form. Welp, with the World Cup and the Tour de France events both now firmly in the rear view mirror, I guess I have no choice but to get back to work! In all seriousness, this summer has been crazy busy for me. International travel to visit my family in England, a bad sickness, summer camps, moving house... Once my boys go back to school again, it'll be a little easier to get into a...
18 days ago • 2 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #393, your Monday morning espresso, in spreadsheet form! ⚽️ We were bitten by World Cup fever in my house, watching matches together in the evenings. What a fantastic tournament, with drama in spades. Of course, I'm disappointed England didn't reach the final, but the I thoroughly enjoyed the ding-dong 6-4 third place playoff game against France. 🚴♂️ But, imho, there's an even better sporting spectacle happening in France at the moment:...
25 days ago • 4 min read
Brought to you by: Hi Reader, Welcome (back) to the Google Sheets Tips newsletter, issue #392, your Monday morning espresso, in spreadsheet form! Greetings from the East Coast of the US, where we've been under an Extreme Heat Warning for the past few days, with temperatures at a sweltering 100°F (feels like 114°F with humidity 🥵.) This follows on from the heat wave in the UK a week ago (where I was visiting family) and another in Germany the week before that (where my wife and I traveled for...
about 1 month ago • 3 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #391, your Monday morning espresso, in spreadsheet form! (Sorry there was no newsletter last week. I was sick!) This week we're looking at a cool use case for Google Sheets that most folks have no idea about. Creating QR codes! With a few simple formulas you can create QR codes in your Sheets that you could use to track inventory, accept invitations, or even print out to use at an event. First, a housekeeping announcement: after today,...
2 months ago • 2 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #390, your Monday Tuesday* morning espresso, in spreadsheet form! * public holiday in the US yesterday. Speaking of coffee, I usually work from my local coffee shop twice a week. It makes for a nice change of scenery from home. And everytime I order the same thing: a regular cappuccino, no frills, no syrups, no fancy milks. I think it says a lot about my personality and stage in life. As a working parent, neck deep in the world of AI,...
3 months ago • 3 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #389, your Monday morning espresso, in spreadsheet form! After a major work sprint to launch the 28 Days to Gemini Mastery course earlier this spring, I recently took a few weeks off to visit my brother and his family in Australia. We spent time hiking and packrafting in Tasmania's remote and beautiful Southwest National Park. It was an incredible trip and, without cell service for 12 days, a true break from the noise...
3 months ago • 3 min read
Hi Reader, Welcome to the Google Sheets Tips newsletter #388, your Monday morning espresso, in spreadsheet form! ➜ Sheets Tip #388: Merged Cells To many power users who live in spreadsheets, merged cells are often treated like a patch of poison ivy on a hiking trail. They see them, turn their nose up, and steer well clear. But are they always the villain? Let's find out. Why Purists Cringe At Merged Cells In a structured dataset or a table, merged cells are, quite frankly, a nightmare. They...
3 months ago • 1 min read
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...
3 months ago • 1 min read