It’s the start of the year, and if you’re on the job hunt, you’ve come to the right place because I’ve put together three job application tracker Google Sheets templates for you. As you know, the job hunting process is daunting, but using a job application tracker Google Sheets template can make the process easier …
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 …
Are you struggling to stay on top of your finances? That’s where my weekly budget template Google Sheets guide comes in handy! Dozens of budget planning tools and budgeting spreadsheet templates are available; Google Sheets is a free, user-friendly option. For me, using a personal weekly budget template in Sheets has been a great way …
As an investor, keeping track of your portfolio is just as important as researching for the best initial investment. However, keeping tabs on your accounts can be a headache, especially if you have several accounts. For me, the perfect solution has been to use an investment tracking spreadsheet, which allows me to track my entire …
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 …
Are you looking for an easy guide to adding a new line in a cell using Google Sheets? The simple Google Sheets new line in a cell shortcut is to press Alt + Enter on Windows or Cmd + Enter on your Mac. It is a powerful tool used to improve your dataset’s readability. Need …
How to add columns in Google Sheets? It’s a common question with an easy answer. To add extra columns to your spreadsheet, all you have to do is navigate to “Insert” > “Columns.” If you’d like to learn the various methods or want more guidance, read this blog post for my full guide on adding …
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 …
Need to count days in Google Sheets? There are a few ways to do it, depending on what you want to find. For example, there are some methods especially for finding the number of days between dates in Google Sheets. This kind of calculation can be useful if you’re creating a schedule for your students …
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. …
Enjoy our custom-made Google Sheets templates for free via email access
