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.
Watch Video – How to Search in Google Sheets and Highlight Matching Data If you work with huge datasets in Google Sheets, sometimes, it may get difficult to identify some data points. For example, if you have a list of students and their marks, it can take some time to find a student name and […]
OR function is useful when you want to evaluate a set of conditions. It will return TRUE when any of the conditions being checked are met, else it returns FALSE. Let’s dive into our OR function Google Sheets guide. OR Function Google Sheets Syntax OR in Google Sheets works with the following syntax: OR(logical_expression1, [logical_expression2, …]) […]
Importing data from other documents into your current file doesn’t have to be hard. I’ll use this IMPORTRANGE Google Sheets function guide to show you how to do it in just a few minutes. This blog post will discuss the process in further detail below. But, essentially, IMPORTANGE in Google Sheets can be boiled down […]
Watch Video – IMPORTDATA Function in Google Sheets IMPORTDATA function is Google sheets allows you to quickly import the data from the URL of a .csv (comma separated value) or .tsv (tab-separated value) file. This can be useful if you’re working with data that is available online in a .csv/.tsv file. Using IMPORTDATA function, you […]
The IFS Google Sheets function lets you easily test multiple conditions in a single formula. While the functions can get long and seem daunting, once you understand them,y ou’ll be applying them fluently. This guide aims to teach you everything you need to know about IFS statements in Google Sheets to get started quickly. Read […]
Do you want to learn how to freeze a row in Google Sheets? You’ve come to the right place! In this detailed guide, I’ll discuss how to freeze and unfreeze rows or columns in Google Sheets with my step-by-step instructions and screenshots. While there are several methods of freezing rows, the quickest and easiest way […]
If you work with formulas in Google Sheets, you know that errors can pop up any time. While getting errors is a part of working with formulas in Google Sheets, it’s important to know how to handle them correctly. In this tutorial, I will show you how to use the IFERROR Google Sheets function to […]
A drop-down list in Google Sheets can be helpful when you want the user to select from pre-defined options. It’s a great way to make the data entry consistent. Watch Video – How to Add Google Sheets Drop-Down List For example, a user from a drop-down list can select easily the country as the US. […]
IMPORTFEED function in Google Sheets can be used to import the RSS feed in the worksheet. This can be useful if you want to keep track of new blog posts or news items on your favorite website. For example, you can create a list of websites that you want to follow and quickly get the […]
A feature that used to be missing from Google Sheets zooming. Thank heavens they added the ability to Zoom In and Zoom Out in Google Sheets. Now, that we can zoom out in Google Sheets, we can avoid straining our eyes and be able to see better. Of course you can also use the older […]
Prefer watching a video tutorial? View our “How to transpose Google Sheets “video here: If you’ve been working hard on a spreadsheet, what if you don’t like the structure of your data? You can flip your rows into columns using the TRANSPOSE Google Sheets formula. With step-by-step tutorials and screenshots, I’ll show you how to […]
Google Sheets fill down can save you a lot of time when doing data entry or working with data. To use the fill handle, Google Sheets recognizes a pattern and allows you to quickly use the pattern to fill down the data. For example, suppose you have 1 in cell A1 and 2 in cell […]
Enjoy our custom-made Google Sheets templates for free via email access
