Sumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people.
Browse all posts and insights written by Sumit.
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. …
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 …
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 incorrectly configured Google Sheets print area can result in poorly located page breaks and wasted paper. If you’re coming over from Microsoft Excel, you might …
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 are a sure way to record and monitor informational changes accurately. With the use of line graphs, trends clearly appear, allowing individuals and companies alike …
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, you can quickly split the contents of a cell (or a range of cells) into columns, using the Split Text to Columns feature. This is …
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 built-in time conversion tool in Google Sheets. It may be particularly useful if you have an existing workbook that has times stored as 12-hour …
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 tutorial, I will explain the Google Sheets QUERY function and show you a lot of practical examples of how you can use it in Google …
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 tables that makes the data analysis process even more powerful. This pivot table Google Sheets tutorial will give you the jumpstart you need to delve …
Enjoy our custom-made Google Sheets templates for free via email access
