SUBTOTAL Function in Google Sheets

The SUBTOTAL function in Google Sheets is a powerful function for working with data. There are three principal uses for the SUBTOTAL function: Calculating Subtotals for lists of data Calculating metrics with filtered and/or hidden rows of data As a dynamic function selector It’s versatile, as you’ll see in this tutorial. However, it’s not well … Continue reading SUBTOTAL Function in Google Sheets

Beyond Sheets: Get Started With Google BigQuery

This tutorial is written for Google Sheets users who have datasets that are too big or too slow to use in Google Sheets. It’s written to help you get started with Google BigQuery. If you’re experiencing slow Google Sheets that no amount of clever tricks will fix, or you work with datasets that are outgrowing … Continue reading Beyond Sheets: Get Started With Google BigQuery

When Your Formula Doesn’t Work: Formula Parse Errors in Google Sheets

Whether you’re just starting out with Google Sheets or are a seasoned pro, sooner or later one of your formulas will give you a formula parse error message rather than the result you want. It can be frustrating, especially if it’s a longer formula where the formula parse error may not be obvious. In this … Continue reading When Your Formula Doesn’t Work: Formula Parse Errors in Google Sheets

How to use Google Sheets: A Beginner’s Guide

This Google Sheets tutorial will help take you from an absolute beginner, or basic user, through to a confident, competent, intermediate-level user. Google Sheets is a hugely powerful tool, for everything from digital marketing to finance modeling, from project management to statistical analysis, in fact, just about any activity involving the recording and analysis of … Continue reading How to use Google Sheets: A Beginner’s Guide

Gmail Mail Merge For A Specific Label With Apps Script

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