Sometimes when working in charts in Google Sheets, you may want to add another Y-Axis so that your graphic has two Y-Axis’. For some datasets making a chart with a …

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 spreadsheet programs, the data in your cells may look uneven and sloppy if cells have different formatting rules applied to them. Learning to justify the text …

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 …

The ADDRESS function in Google Sheets will return a cell reference as a string. This is not a very well-known function, but when you work with spreadsheets long enough, you …

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 …

If you want to know the number of net working days between two dates, the NETWORKDAYS function will come in handy. In this tutorial, I will show you how to …

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 …