Google Sheets Tutorials

The RANK function will return the rank of values in a dataset in Google Sheets. In this tutorial, I will show you how to use the RANK function in Google …

If you need to quickly find the maximum value in a range of data based on certain criteria, the MAXIFS function will come in handy. In this tutorial, I will …

Sometimes when working in Google Sheets, you may want to convert a month name to a number. For example, maybe you have a cell that contains a month like “September” …

There are a lot of tricks you can use in Google Sheets to speed up your productivity. Learning how to use Google Sheets properly will save you a lot of …

If you are working with dates in Google Sheets and only want to use the month of the year that date falls on, the MONTH function is a useful formula …

If you want to combine text together from different strings in Google Sheets with a specific separator, the TEXTJOIN function will come in handy. In this tutorial, I will show …

Sometimes when working in Google Sheets, you may need to take a timestamp and extract the date from it. Luckily this is a pretty simple process. In this tutorial, I …

Sometimes when working in Google Sheets with the FILTER function you may end up getting a mismatched range size error. Luckily, this type of error is pretty easy to fix. …

If you’re working with dates in Google Sheets and you need to find the difference between two dates, the DATEDIF function will come in handy. In this tutorial, I will …

Many users know how to create drop-down lists in Google Sheets, but not many people know that you can actually color these drop-down lists. Adding color to your drop-down list …