Tips and Tricks

If you need to calculate the quartiles for your dataset in Google Sheets, there is a built-in function to do this called the QUARTILE function. In this tutorial, I will …

Sometimes when working in Google Sheets you may want to share only a single sheet with another user without sharing all of the tabs in the entire spreadsheet. Unfortunately at …

If you need help in Google Sheets there are a few forums where you can ask users for assistance when you have problems with your spreadsheet. In this post, I …

Sometimes when working in Google Sheets you may want to change the ownership of your spreadsheet. It is possible to change the owner of all the files in your google …

Sometimes when working in spreadsheet programs like Google Sheets, you may want to use a formula to get the column letter. Some formulas in Google Sheets use a column index …

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 …

Google Sheets is a powerful spreadsheet program that can be used in many different ways to accomplish some pretty neat things. One very useful thing that can be done with …

One thing you may want to know how to do in Google Sheets is to count the number of cells that are colored or highlighted. Whether it’s cells with conditional …

Sometimes when working in a large spreadsheet in Google Sheets, you may need to count the number of cells that contain a specific text. There are some pretty simple functions …

If you are working on a large dataset in Google Sheets, it may be useful to have two of the same table open at the same time. There is not …