Learn to automate and grow your business with spreadsheets
If you want to both sort and filter your data with a single formula in Google Sheets, you can do this by combining the SORT function with the FILTER function. In this article I will show you multiple ways of combining these two formulas so that you can sort and […]
The SORT function is an incredibly useful formula that you can use to sort your data in Google Sheets. With the SORT function you can sort your data by a specified column (or multiple columns), in ascending or descending order, and you can also sort data vertically or horizontally. The […]
Google Sheets is an amazing tool that companies all around the world are using to stay organized, and to operate more efficiently and effectively. There are a wide variety of ways to use Google Sheets in your business, from storing data and safely sharing spreadsheets with staff, to tracking and […]
One of the most useful things that you can do with Google Sheets, is mathematics. Whether you are simply wanting to solve simple math problems, or whether you have calculations that need to be performed on a set of data, doing math in a Google spreadsheet is very easy if […]
The "Circular dependency detected" error in Google Sheets, is a very common error that can occur when using almost any formula. When you see the circular dependency detected error displayed in your Google spreadsheet, this means that your formula is referring to a range that contains the formula itself, or […]
Have you ever needed to quickly make your columns the same width in a Google spreadsheet? There is a very simple way to evenly space columns in Google Sheets, that will allow you to quickly expand or shrink multiple columns to the same width at one time. In this article […]
In Google Sheets, there is a very simple way that you can make the column width automatically fit your text, which is called "Fit to data". This is a very useful and simple trick that will save you time, and add to your set of important, basic spreadsheet skills. When […]
In Google Sheets, you will sometimes have text that is entered into your spreadsheet, that does not fit within the cells. There is a very easy way to make the text fit the cell, by wrapping the text. When text is "wrapped", once the string of text reaches the end […]
There are certain situations when using Google Sheets, when you will want to change the direction of the text that is in the spreadsheet cells, such as when you want to make text vertical. There are several ways to rotate text in a Google spreadsheet, and so you can select […]
If you ever need to quickly capitalize the first letter of each word in a Google spreadsheet, there is a very simple function that can be used to accomplish this. The PROPER function will automatically change the case of text so that only the first letter of each word is […]
Sometimes you may come across a situation in Google Sheets where you need to change text to lowercase quickly, without having to manually change letters. There is actually a very simple way to make text lowercase, by using a formula. The LOWER function changes text that is in a spreadsheet […]
If you want to quickly capitalize all letters in a cell, or range of cells in Google Sheets, this can be done by using the UPPER function. The UPPER function is very easy to use, since all you need to do to use it, is to designate the cell that […]