Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
The INDIRECT function in Google Sheets is used to convert text strings into valid cell or range references. For example, the INDIRECT function will convert the text string “A1” into the cell reference A1. The formula is: =INDIRECT(“A1”) which is equivalent to this formula: = A1 It gives the answer 10 in the following example … Continue reading INDIRECT Function in Google Sheets
The IFERROR function in Google Sheets is a useful function to have in your Google Sheets toolbox. And it’s easy to learn. In this tutorial you’ll learn how it works and see common use cases. There are three principal uses for the IFERROR function: Replacing error values with a fallback value Catching errors and replacing … Continue reading IFERROR 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
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
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