Google Sheets Tutorials

Google Sheets has a few useful financial functions for calculating things like the payments on a loan. One such function is called the PMT function. This can be used to …

If you want to add boolean values in Google Sheets, there is a great built-in function for this called the TRUE function. This can be useful in many different scenarios …

If you need to find the unique values in your spreadsheet across multiple columns, there is a way to do that in Google Sheets with this UNIQUE function. In this …

The SUBTOTAL function is a versatile function that is extremely useful when working with data. This is not a very well-known function, but by the end of this guide, you …

If you need to remove the last character from a string in your spreadsheet, there are a number of ways you can do this in Google Sheets. There are a …

Sometimes in Google Sheets, you may end up with some columns that are smaller than larger than others. If you want to adjust the width of all your columns to …

There are many different ways to extract numbers, text, and punctuation from a cell in Google Sheets. Learning all of the different functions that can be used to extract a …

In Microsoft Excel, you can split cells diagonally, but there is not a way currently to do this in Google Sheets. If you are trying to accomplish this in Google …

Sometimes when working in spreadsheet programs like Google Sheets, you may want to perform a task, but you may not know the best way to accomplish this. For example, one …

Google Sheets has many useful built-in functions for rounding down. The most commonly used rounding function I have covered in my previous post on rounding numbers in Google Sheets. But …