Google Sheets makes it very easy to do math, such as subtracting numbers, cells, and entire columns / rows. Spreadsheets make calculating / subtracting easy in so many ways, from being able to do multiple subtraction formulas at once, to being able to use cell references so that your subtraction […]

Do you have a date in your Google spreadsheet that you want to add days to (or subtract) with a formula? There is a very easy way to do this, and in this article I am going to show you multiple ways to add or subtract days, months, or years […]

In this lesson I am going to teach you how to get a list of dates without weekends in your Google spreadsheet. I will also teach you how to use the WORKDAY function, which allows you to calculate a date that falls a certain number of workdays (business days) in […]

Many people know how to filter in Google Sheets where the criteria is an exact match, but there will be times when you want to filter where the criteria is contained within the cell, even if it is not an exact match to the cell’s value. This can be done […]

When you are using formulas in Google sheets, you will often come across situations where you need to use the “not equal” sign, but not a lot of people know how to type the not equal sign or how to use it in formulas. To type the not equal sign […]

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 […]

Did you know that you can pull stock prices, and other stock data in Google Sheets, by using a formula? In this lesson I am going to teach you all the different ways to use the GOOGLEFINANCE function, to pull real-time stock data, as well as historical stock data. I’ll […]

Are you looking for a way to pull cryptocurrency prices into your Google spreadsheet automatically with a formula? In this lesson I am going to show you three different methods to pull crypto prices into Google Sheets. These methods do NOT require add-ons. With the first method we will use […]

Did you know that you can pull data from websites into your Google spreadsheet, automatically? There is an incredibly useful function in Google Sheets called IMPORTXML, which you can use to retrieve data from web pages, where that data is pulled into a Google spreadsheet on an automated basis. This […]

Welcome to the Google Sheets formula tutorial! Today I am going to help you take your Google Sheets skills to the next level, by teaching you the basics of how to use formulas in Google Sheets, as well as by teaching you how to use the 23 best 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 […]