Learn to automate and grow your business with spreadsheets
Coloring tabs in Google Sheets is something that a lot of people know you can do, but a lot of people don't take advantage of this useful feature. Coloring your tabs in a spreadsheet workbook is just another part of formatting your sheets to make them look professional, and easy […]
Do you have a tab in your Google Sheets file that you want to duplicate? There is a very easy way to make an exact copy of a tab in Google Sheets! (Duplicating tabs makes it easy to create backups of your tabs, and also allows you to create alternate […]
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 […]
Click here to go back to the main dashboards course page. Download the raw data to follow along: Revenue Report CSV See the completed sales dashboard: Sales Dashboard After downloading the raw data that is linked above, scroll down and begin the video (or return to YouTube) to start building […]
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 […]