Learn to automate and grow your business with spreadsheets
When you are working with data in a Google Sheets, there will be times when you will need to either add or remove decimal points from the numbers that display in the cells. Google Sheets has a very easy way to increase or decrease decimal places so that the exact […]
In Google Sheets, you can easily add emphasis to your data through highlighting. This feature allows you to make certain text, cells, or specific words stand out. In this article, I'll guide you through how to highlight text, change cell background colors, and highlight specific words within your spreadsheet. Whether […]
In Google Sheets you can easily apply strikethrough to your cells / text. Strikethrough is a useful formatting option when you want to visually indicate that certain information is no longer relevant or should be crossed out. It's a simple yet effective way to convey changes or updates in your […]
In Google Sheets, there are multiple ways to underline text, and if you want you can even underline the cells themselves. Underlining is a great way to emphasize text or data in your spreadsheet or to simply make it stand out. In this lesson I will show you how to […]
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 […]
If you are having issues with the SUM function in Google Sheets, whether it's not working or not showing the correct result, this article will show you how to fix the error. There are several different ways that an error can occur with the SUM function, from setting up the […]
Have you ever encountered the #DIV/0! error while working in Google Sheets? It's a common issue that happens when dividing in a spreadsheet. This is an error that simply states that the spreadsheet is trying to divide by zero, which is not possible in math and therefore not possible in […]
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 […]