Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
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
New course — launch offer Stop dabbling with Gemini.Start building AI systems. Go from one-off prompts to repeatable AI workflows — in just 15–20 minutes a day Integrate Gemini across Sheets, Docs, Gmail, and all your Workspace tools Build automations and agents that save you hours every week Master NotebookLM, vibe coding, Gemini Gems, and … Continue reading Newest Course: Gemini Mastery