In Google Sheets, sometimes you will find the need to calculate the number of days between two different dates, or to subtract days from a date to find what the date would be x many days ago. Since dates are simply numbers displayed in a special way in a spreadsheet, […]

In Google Sheets, duration values are simply normal numbers displayed in a special format, and if you want you can convert the duration into a decimal / number value. In this lesson I am going to show you how to change cell format to display durations as a decimal, and […]

Do you have numbers / decimals in your spreadsheet that you want to convert to duration format? In this lesson, I am going to show you not only how to convert cells to duration format, I will show you how to convert decimals into duration format so that the original […]

Understanding how to calculate percentage increase in a set of values is crucial for assessing growth or change over time, whether you’re tracking financial growth, project milestones, or any other numerical trends. To calculate the percentage increase/decrease, first you subtract the initial value from the final value to find the […]

Being able to calculate percentages is something that is very useful in spreadsheets, and is a very useful mathematical skill to have in general. When working with data in spreadsheets there will be a lot of situations where you will want to calculate the percentage of a given number relative […]

Have you ever wanted to convert fractions to decimals in your Google spreadsheet? This can be done very easily by dividing the top portion of the fraction (numerator) by the bottom portion of the fraction (denominator). A fraction is essentially a division problem. One-half (1/2) is equal to “1 over […]

In Google Sheets, sometimes you will need to convert dates in your spreadsheet to numbers. You can do this easily by either using a formula, or by formatting the cells. I’ll walk you through both methods, and I’ll show you how to convert single dates and whole columns of dates […]

Are you looking for a way to convert dates into text in your Google spreadsheet? Whether you want to display dates in a specific format or combine them with additional text, this article will guide you through the process. We’ll go over three methods: Using the TEXT function to convert […]

In Google Sheets there are two easy ways to square numbers or solve any exponent that you want. In this lesson, I am going to show you both methods, and I will show you how to incorporate cell references into your exponent formulas. Squaring a number means to multiply a […]

In Google Sheets there are two easy ways to square root numbers or solve any root that you want. In this lesson, I am going to show you both methods, and I will show you how to incorporate cell references into your root formulas. Square rooting a number means finding […]

Google spreadsheets make it very easy to do math, such as dividing numbers, cells, and entire columns / rows. Spreadsheets make dividing easy in so many ways, from being able to do multiple division formulas at once, to being able to use cell references so that your division formula criteria […]

In Google Sheets you can do math very easily, such as multiplying numbers, cells, and entire columns / rows. Spreadsheets multiplying fast and easy, from being able to do multiple multiplication formulas at once, to being able to use cell references so that your multiplication formula criteria is easily controlled […]