The COUNTIF Google Sheets function can be used when you want to get the count when a given condition is met. COUNTIF contains the Google Sheets COUNT function and the IF function. That’s why I created this in-depth guide. It shows you how to use the COUNTIF function with screenshots and practical examples. That’s a Google […]
Watch Video – How to Merge Cells In Google Sheets (How to Combine Columns in Google Sheets) When you work with data that has headers, sometimes, you may feel like you need to learn how to merge cells in Google Sheets. For example, if you have the main header as Revenue and subheaders as 2016, 2017, […]
Ready to discuss conditional formatting in Google Sheets? Below, I’m providing step-by-step instructions on the process, including color gradient (scaling), using a checkbox, highlighting information, and much more. I’ve created the most straightforward conditional formatting Google Sheets guide so you can discover everything about this critical spreadsheet function. Using Excel? Check out our Using Excel […]
If you work with text, there is an easy way to run spell check in Google Sheets to take care of the misspelled words. As an example, below I have the fruits’ name in Column A. If you look closely, you can find two misspelled words in it – Aple (instead of Apple) and Strawbery […]
The IF function in Google Sheets can be used when you want to check a condition and then based on it, returns a specified value if it’s TRUE, or else return the other specified value. Confused? This in-depth IF function Google Sheets guide will have you mastering this in no time. The complex IF function […]
If you work with data in Google Sheets, sorting is a feature you would need quite often. In this tutorial, you’ll learn how to sort in Google Sheets. Sort in Google Sheets (Using In-built Sorting Functionality) Suppose you have students marks data in a Google Sheet as shown below: Now you can sort this data […]
Google Sheets is not only about numbers in data. Some people also use it to manage text data like comments on a business page or responses to a questionnaire. However. These kinds of data can be pretty text heavy, and if you’ve seen a spreadsheet in Google Sheets, those cells aren’t designed to hold that […]
I’ll be upfront with you: There is no straightforward way to insert bullet points in Google Sheets. Maybe there just hasn’t been enough demand for their developers to change it. That doesn’t mean it can’t be done. In fact, I can show you several ways to add bullet points to a spreadsheet. I’ll describe each […]
You can easily get a Word Count in Google Sheets. All you need is some know-how of the Text Functions (LEN and SUBSTITUTE). Word Count In Google Sheets – Method 1 Suppose you have a few text strings as shown below: There are different text strings here of varying lengths. Now to count the number […]
I’m here to discuss how to remove duplicates in Google Sheets. This is a common issue. When you have replicated data and want to clean the results, you’ll need to remove duplicates. Below, I’ll show you exactly how to do this. Watch video – How to Remove Duplicates in Google Sheets Note that, if you […]
There are times when you might need to highlight every other row in Google Sheets to make your data easy to read and analyze. Luckily there are plenty of Google Sheets alternate row color options in the format menu. The first option uses the alternating colors menu in Google Sheets to color every other row. […]
Enjoy our custom-made Google Sheets templates for free via email access
