What is a Google Sheets percentage formula, and how does it work? Percentages are found everywhere in our everyday life. However, many people cringe at calculating them, thinking they are too complicated. That’s where the Google Sheets percentage formula comes in. When working with Google Sheets, I often find myself having to find percentage changes …
Here’s what you need to know about the NPER function in Google Sheets. It’s mainly used to determine the number of payment periods until a debt is paid off. The function assumes a constant interest rate, static payment, and no additional principal additions (aside from interest). Because of that, the Google Sheets NPER function is …
How do you count not-blank cells in a spreadsheet? I’ll show you. In Google Sheets, the COUNTA and COUNTIF functions allow you to count cells if they’re not blank. You just have to tell them what you’re looking for. I’ll break down these functions’ syntax, and I’ll show you exactly what to enter. That way, …
This guide show how to highlight duplicates in Google Sheets. Note that you can do this in several ways, but the simplest is to use a custom formula in the conditional formatting menu. I’ll also show you how to highlight duplicates with the COUNTIF formula. Follow along below for the step-by-step highlighting guide, the syntax …
I can’t overstate the value of INDEX MATCH in Google Sheets. While there are several functions designed to look up data, these are two of the most powerful. Used on their own, the INDEX and MATCH functions have limited applications. However, they become exceptionally powerful when combined. The INDEX MATCH function helps me evaluate a …
What is the CONCATENATE Google Sheets tool? The CONCATENATE Google Sheets function combines multiple text strings or data from two cells into one, protecting the data from each cell. It is a helpful tool when combining multiple elements. For example, you could use the formula =CONCATENATE(A1, B1) to join the text in cells A1 and B1. …
Adding phone numbers into Google Sheets — without formatting — can quickly become overwhelming. Thankfully, there’s an easy way to customize your Google Sheets phone number format. The quickest way is to click select the following in the top menu bar of your Google Sheet: “Format” > “Number“ > “Custom Number Format.” In this guide, I’ll show …
What is the Find and Replace Google Sheets feature and how do you use it? When spreadsheets are filled with huge data sets, finding and substituting cell entries can be challenging. You can make this process a lot easier by using the Find and Replace Google Sheets feature. To access this option, go to Sheets and …
To simplify how ARRAYFORMULA works, you must add it before using arrays in functions that normally don’t use arrays as arguments, like SUM. If that’s a little confusing, don’t worry. This easy array formula Google Sheets tutorial will teach you how to use the ARRAYFORMULA function with several examples from basic to intermediate. Read on …
Adding dates to spreadsheets seems like it should be as easy as entering into the cell, right? While that is true most of the time, dates entered in this fashion often cause other functions not to work correctly. It may also cause issues with formatting, i.e., the month before the day is not necessarily the …
Like all IF functions, AVERAGEIF will only calculate data within a spreadsheet if it meets specific criteria. The AVERAGEIF function in Google Sheets will calculate the mean of the applicable cells from the columns or rows of the given range of cells. When To Use AVERAGEIF in Google Sheets You can use AVERAGEIF in several …
Manually typing the date and time in a spreadsheet can slow your progress down significantly. The Google Sheets NOW function allows you to automatically return the current time and date value, which should greatly increase your productivity if your spreadsheet requires multiple inputs of this value. Why Use The Google Sheets NOW Function? Although the …
Enjoy our custom-made Google Sheets templates for free via email access
