Learn to automate and grow your business with spreadsheets
Do you have a tab in Google Sheets that you want to copy into another Google Sheets file? In this lesson I am going to show you how to copy a tab from your existing worksheet, into a completely different Google Sheets file / sheet… whether you want to copy […]
Did you create a chart on one sheet, but want to transfer or duplicate that chart to another tab? This is something that I do all of the time when I want to see my data and chart at the same time while customizing the chart, and then move the […]
Do you have a chart that you have already formatted, and want to copy the formatting from that chart to another chart? Or perhaps you simply want to know how to duplicate charts in your Google spreadsheet. In this lesson I am going to show you how to do exactly […]
The TRANSPOSE function is a very useful formula that will allow you to turn rows into columns, or columns into rows, in Google Sheets. If you need to switch the columns and rows in your data, this lesson will show you several ways of using the TRANSPOSE function to do […]
One of the most amazing and valuable things that can be done with Google Sheets, is creating a dashboard. A lot of people don’t know that Google Sheets can be used to create professional dashboards, and so a lot of companies end up spending way more money and time than […]
In this article, I am going to show you how to export a CSV from Google Sheets. If you have data in a Google spreadsheet that you want to use to create / download a CSV, Google Sheets has a very easy way of converting your spreadsheets into CSV files. […]
Several years ago, I didn’t know that there was a super easy way to import CSV files into Google Sheets… and so I spent lots of time copying and pasting entire CSV files into my Google spreadsheets. Sometimes copying and pasting can be very effective, and so I’ll teach you […]
Do you have duplicates in your Google spreadsheet that you want to remove? There are multiple easy ways to do this automatically instead of searching for them and deleting them one by one manually. In this article I am going to show you how to use the two main methods […]
The UNIQUE function is an incredibly useful function in Google Sheets, that can be used to remove duplicate entries, or in other words duplicate rows. To remove duplicates with the UNIQUE function in Google Sheets, follow these steps: This article focuses on using the UNIQUE function to remove duplicates, but […]
In this tutorial, I am going to teach you how to use Google Sheets from the ground up. You will learn all of the important things that you need to know to work with Google Sheets in the professional world, from how to create and format sheet, to using formulas […]
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 […]