Learn to automate and grow your business with spreadsheets
Have you ever created a chart in Google Sheets with multiple series, and you wanted to change the order of the series? Before I learned how to do this I would always change the order of the data, instead of simply changing the order of the series on the chart […]
When you are creating a Google Sheets chart, something that can be extremely useful is "Data labels" which are the values that each bar / column etc. represents. For example when you create a column chart, by default there will be numbers on the y-axis that will give you a […]
In Google Sheets, many know how to highlight a cell based on its value, by using conditional formatting. But did you know that you can use conditional formatting to highlight an entire row based on the value of a single cell? That's what I'm going to show you how to […]
When you're using Google sheets, sometimes you'll have duplicates in your data and you'll want a way to highlight them so that you can easily see where they are. In this lesson I'm going to show you several ways to highlight duplicates in Google sheets. You'll learn how to highlight […]
Are you looking for a way to insert bullet points in Google Sheets, but can't seem to find the button for it? There is not a bullet point button, but there are several ways to insert bullet points in a Google spreadsheet and I will show you all of them […]
In this lesson I am going to teach you how to chart data that is on a different tab than the chart, and I will also show you how to chart data that is on multiple tabs. There are multiple ways to do these things, and I will teach you […]
In this lesson I am going to show you how to chart multiple series in Google Sheets, where you are charting data with multiple columns per row, or vice versa. For example if you want to chart multiple lines on a line chart, or if you want to have multiple […]
Welcome to the Google Sheets Skills Test! Do you have what it takes to complete the spreadsheet projects? You'll get the chance to find out very soon! Note: At the bottom of this page you can find learning resources to help you gain spreadsheet skills. I highly suggest taking the […]
Did you know that there is a simple way to insert text on a new line, within a single cell? In this article I will show you how to insert a new line in a cell in Google Sheets, and I will also show you how to insert a new […]
In Google Sheets, you can freeze rows and columns in your spreadsheet, so that a specified amount of rows and/or columns will stay locked in place when you scroll, such as when you want to lock your header rows, or lock a column on the left side of your sheet. […]
Do you have numbers in a Google spreadsheet that you want to average? This lesson will teach you multiple ways to average in Google Sheets. I will show you how to use the AVERAGE function, and I'll also show you how to average by using the SUM function with division. […]
Adding and summing are probably the most common and helpful formulas in Google Sheets. In this lesson I am going to teach you how to add and sum in a Google spreadsheet, so that you can easily add together any numbers that you want. I'll go over how to use […]