Learn to automate and grow your business with spreadsheets
Have you ever wanted to quickly change the case of text in your Google spreadsheet, from lowercase to uppercase or vice versa? Google Sheets has three different formulas that can be used to automatically change the case of text that is entered into spreadsheet cells. The UPPER function will capitalize […]
When you are filtering data in Google Sheets with the FILTER function, in most cases you will probably use it to filter vertically, however you may sometimes have data that needs to be filtered horizontally. With a slight adjustment to your references in the filter formula, you can filter horizontally, […]
There are a wide variety of charts and graphs that you can use in Google Sheets, which will make your spreadsheet look amazing, and that will make your data very easy to analyze. In this article I’ll show you how to insert a chart or a graph in Google Sheets, […]
When you are filtering in Google Sheets, you may sometimes come across an error that says "FILTER has mismatched range sizes". This is a common error that can be easily fixed by assuring that the references in your filter formula contain the same number of rows. If you happen to […]
When using formulas in Google Sheets you will often need to apply a formula to an entire column, and there are several different ways that you can do this, and in this lesson I am going to teach you all of them. Personally my favorite method of applying a formula […]
If you have a formula that you would like to copy to an entire column in Google Sheets, there is a very easy and fast way of doing this, by using "autofill" which is referred to as "fill down" when being used to apply formulas to a column. You can […]
When using Google Sheets, you may often find yourself needing to copy and paste values only, without formulas, and without formatting. There are a couple very simple ways of doing this, either through right-clicking and accessing the "Paste special" menu, or by using the keyboard shortcut as explained below. To […]
Sometimes you may find that you want to create a series of numbers very quickly when creating a spreadsheet, without having to manually type each number in the cells, and this can be done by using autofill, which is also sometimes simply known as “fill”. To automatically create a series […]
There are many different options for coloring cells in Google Sheets that will allow you to make your spreadsheet visually appealing and easy to read. It may sound obvious, but cell color is something that I see people at work forgetting to take advantage of all the time. I personally […]
When filtering data in Google Sheets you may sometimes need to filter by an entire list of values, rather than by just a single/few specified values. You can use the FILTER and COUNTIF functions to filter based on a list in Google Sheets. You can also achieve the same task […]
In this article, I am going to show you every different way of extracting numbers, text, and punctuation from strings in Google Sheets. To do this, we will mainly use the REGEXREPLACE function, which you can use to replace / extract a variety of characters types from your data. This […]
There are a variety of different ways to combine columns in Google Sheets, and I am going to show you six different formulas that you can use to combine multiple columns into one. Three of these formulas will combine columns horizontally, and three of them will combine columns vertically. Directly […]