

How to Use COUNTIF to Count Cells That Are Not Blank
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
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
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
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
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
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
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
How to Set Print Area in Google Sheets – Video tutorial: Setting the print area in Google Sheets is an important part of transferring spreadsheet information in an office. An
How to Make a Line Graph in Google Sheets – Video tutorial: Nothing conveys and represents data as clearly as a line graph. From statistics to evolving data, line graphs
Watch Video – How to use Google Sheets’ Split Text to Columns tool Are you wondering how to use Google Sheets’ split text to columns tool? The answer is simple,
Google Sheets features a built-in time formatting tool that makes converting between 12-hour time and military time, also known as 24-hour time, a breeze. This tutorial covers how to use
The Google Sheets QUERY function is one of the most useful functions. When used to its full potential, it can do some really amazing things in Google Sheets. In this
Spreadsheets provide a great way to work with data. They help you keep your data organized to get good insights from it. Google Sheets gives the added facility of Pivot
Ready take your Google Sheets skills to the next level? Want to lift your productivity without breaking a sweat?
Sign up for our free newsletter for regular spreadsheet guidance.
Enjoy our custom-made Google Sheets templates for free via email access