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...
9 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...
16 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...
23 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...
30 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:...
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
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