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 […]
Author: Corey Bustos
Copying chart formatting, and duplicating charts in Google Sheets
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 […]
TRANSPOSE function: Switch columns and rows in Google Sheets
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 […]
How to build a dashboard in Google Sheets (Free Course)
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 […]
How to export / create a CSV in Google Sheets (Download as CSV)
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. […]
How to import or convert a CSV into Google Sheets
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 […]
2 ways to remove duplicates in Google Sheets
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 […]
Using the UNIQUE function to remove duplicates in Google Sheets
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 […]
Beginner’s tutorial for Google Sheets
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 […]
Using the SORT and FILTER functions together in Google Sheets
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 […]
How to use the SORT function in Google Sheets
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 […]
7 Reasons why your business should use Google Sheets
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 […]