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 versions of a tab without having to completely recreate the tab manually.)| Spreadsheet Class
Many people don’t know that you can hide the toolbar menu in Google Sheets, but in this lesson I will show you 2 super easy ways to hide the menu in your Google spreadsheet. This will make the view of the spreadsheet cells larger, and cleaner.| Spreadsheet Class
If you want to remove duplicates and transpose your data with a single formula in Google Sheets, you can do this by combining the UNIQUE function with the TRANSPOSE function.| Spreadsheet Class
If you want to filter your data and transpose it with a single formula in Google Sheets, you can do this by combining the FILTER function with the TRANSPOSE function. The FILTER function will allow you to filter your data by specific criteria, and the TRANSPOSE function converts columns to rows and vice versa.| Spreadsheet Class
If you want to sort and transpose your data with a single formula in Google Sheets, you can do this by combining the SORT function with the TRANSPOSE function. These two functions can be used together in a variety of ways, from sorting data that is converted from columns to rows, sorting data that is converted from rows to columns, and even sorting horizontally.| Spreadsheet Class
If you want to remove duplicates and filter your data with a single formula in Google Sheets, you can do this by combining the UNIQUE function with the FILTER function.| Spreadsheet Class
If you want to remove duplicates and sort your data with a single formula in Google Sheets, you can do this by combining the SORT function with the UNIQUE function.| Spreadsheet Class
Did you know that there is a Google Sheets formula that will allow you to convert from one currency to another? The GOOGLEFINANCE formula allows you to convert currencies, and stays up to date with changing conversion rates. For example, if you want to convert from U.S. Dollars to Euros, […] The post How to convert currency in Google Sheets (Detailed examples) first appeared on Spreadsheet Class.| Spreadsheet Class
In Google Sheets, there is an easy way to format numbers in “Currency” format, without having to manually type the dollar sign when you enter numbers into the spreadsheet. Before knowing there is such an easy way to do this, many people either leave their numbers that represent money in plain number format, or they manually type dollar signs each time a number is entered.| Spreadsheet Class
Have you ever wanted to divide in your spreadsheet without a remainder, where the answer is a whole number? There are several ways to do this, depending on which function you want to use, and depending on if you want to round up, round down, or round according to normal […] The post How to divide without a remainder in Google Sheets first appeared on Spreadsheet Class.| Spreadsheet Class
Have you ever needed to find the lowest number that is divisible by two (or more) given numbers in your spreadsheet? Google Sheets has a formula that will allow you to do this very easily. In this lesson I will show you how to use the least common multiple functions […] The post Finding the least common multiple with the LCM function in Google Sheets first appeared on Spreadsheet Class.| Spreadsheet Class