Google Sheets Tutorials

If you need to calculate the simple moving average, this can be done pretty easily in Google Sheets with a combination of several functions. In this tutorial, I will show …

Learning to diagnose and fix error messages is an important part of using spreadsheet programs like Google Sheets. Everyone gets errors eventually. One common type of error that you may …

Google Sheets is a powerful tool that comes with a ton of built-in functions that can be used to do many things. As you work with spreadsheet programs like Google …

By default, most data in a pivot table will be set to SUM the data. But sometimes you may want to count the number of times a certain piece of …

Pivot tables are powerful tools for summarizing data. Learning to use pivot tables can seem challenging at first, but really they are quite simple to use once you understand them. …

Sometimes when working with spreadsheets, you may have data spread across multiple sheets. You may want to create a single pivot table from this data. This can be done in …

If you regularly use spreadsheet programs like Google Sheets, learning to use pivot tables is a must. When you are new to using pivot tables, it’s common to have some …

By default, a Pivot table in Google Sheets will show a grand total row at the bottom of your pivot table. Sometimes you may want to completely hide or remove …

The ISBLANK function is a simple way to check whether a cell is empty or not. It’s a pretty straightforward function that is very easy to use. In this tutorial, …

A Pivot table is a powerful feature that every spreadsheet user should learn how to use. Besides learning the technical aspects of using a pivot table, it may also be …