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...
8 days 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...
15 days 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...
22 days ago • 3 min read
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...
29 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...
about 1 month 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:...
about 1 month 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 2 months 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,...
3 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