Formulas

Sometimes when working in Google Sheets, you may want to change your recalculation settings so that formulas refresh either more frequently, or less frequently. For example, if you are importing …

The WORKDAY function in Google Sheets can be used to calculate a date after a number of working days. In this tutorial, I will show you how to use the …

If you are a regular spreadsheet user, the FILTER function in Google Sheets is something you need to learn. This powerful function will take a dataset and only return the …

The SPARKLINE function in Google Sheets allows you to quickly create a miniature chart inside of a single cell. This can be useful for making a quick visualization of data …

The AVERAGEIFS function in Google Sheets is very similar to the AVERAGEIF function except there is one key difference. AVERAGEIF only allows you to check for one criterion, AVERAGEIFS on …

If you need to find the average of data that meets certain criteria, the AVERAGEIF function in Google Sheets is something that you need to learn. This useful function will …

When you need to sum the products of two different columns or arrays, there is a built-in function in Google Sheets called the SUMPRODUCT function that will come in handy, …

If you want to replace text in a string, the SUBSTITUTE function is a great formula to learn. This formula is very easy to use and will certainly come in …

If you are constantly working with dates in your spreadsheet, Google Sheets has many built-in functions that can be useful to you One such function is the EDATE function. In …

The OFFSET function in Google Sheets is the cause of confusion for many spreadsheet users. Some find it confusing and don’t understand how it works or why it’s useful. Because …