Every Monday I send out a Google Sheets tip email and occasionally I’ll include a formula challenge. I posted Formula Challenge #3 — to alphabetize a string of words separated by commas using a single formula — in January 2020 and had over 150 replies! It would have been too time consuming to reply to … Continue reading Gmail Mail Merge For A Specific Label With Apps Script
These Google Sheet Tips are fantastic!!! Every week, I try to use the new tip / idea / code in one of my projects. Great stuff! – Chip D. Join our community of over 50,000 Google Sheets aficionados and get: The Google Sheets Tips email – an actionable tip every Monday (think of it … Continue reading Google Sheets Tips Newsletter
My online training courses will teach you how to get the most out of Google Apps. I’ve taught over 25,000 students how to solve business problems using Google Sheets. Lessons are taught through bite-size, actionable videos, based on real-world scenarios, with all templates included. Here’s what some past students had to say about the courses: … Continue reading Course Reviews
Did you know that formulas are written differently depending on where in the world you’re located? For example, the syntax in the US is different to that in Italy. This post explores the syntax differences that occur based on your Google Sheets location, i.e. the location you’re working in, assuming your Google settings match (which … Continue reading Explaining syntax differences in your formulas due to your Google Sheets location
Modern Google Sheets, my newest online course, is now available! It shows you how to work faster and smarter in the age of AI. Google Sheets has changed a lot in the past couple of years, with new Tables to keep data structured, Gemini AI to build formulas and analyze data, and modern functions like … Continue reading New Course: Modern Google Sheets
