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.
Google Sheets makes it easy to round numbers. It features several functions that can accommodate a wide range of rounding types. Whether you need to round to the nearest whole number, the second decimal point, hundreds, or by a factor of three, there’s a rounding Google Sheets function to help. In this tutorial, I’ll cover […]
You can calculate weighted averages in Google Sheets by using a built-in formula: AVERAGE.WEIGHTED. Weighted averages are useful for calculating average scores when some factors are more important than others. What is weighted average? A weighted average is similar to an average of numbers, but each number makes up a different share of the average. […]
Sometimes, a visualization helps to group data and find patterns. That’s why I love a scatter plot in Google Sheets. They’re useful for showing trends and relationships in data when other graphs aren’t up to the task. So how do you make a scatter plot? My guide below shows the step-by-step instructions. How to Make […]
VLOOKUP formula (or Vertical lookup) in Google Sheets is a formula that you can use to look for a value in a columnar data set. For example, if you have a list of student names and their scores, you can use VLOOKUP to find the score of a particular student in a specific subject. VLOOKUP […]
Recovering deleted Google Sheets is a straight-forward process – thanks to Google Drive integration. It can be very startling when you realize you need information from a Google Sheet that you or someone else you work with deleted it. Fortunately, restoring a deleted Google Sheet is a brief process if you know where to look. […]
How to move columns in Google Sheets? Google Sheets offers several methods for transferring columns around on a spreadsheet. It’s common to come back to the data and realize that how it is organized no longer makes the most sense. You can use these three approaches on how to move columns in Google Sheets: Drag […]
If you’re new to Google Sheets or you’ve never relied on the “hide rows” feature, you may be a little confused looking at a workbook where rows are missing from the display. Hiding rows in Google Sheets is very helpful for showing off the data you want someone to look at in a spreadsheet. Google Sheets […]
Google Sheets has countless built-in features that automate and streamline the most common use-cases. However, when you want to do something like show a formula instead of the formula result or value, the automation can make it a little tricky. Fortunately, Google Sheets has several techniques to force a cell to show the formula information […]
Formatting data and making it look good and more readable is something we often do when working with Google Sheets. And Google Sheets has a tool that makes copy-pasting of formatting really easy. It’s the Format Painter tool (called the Paint Format in Google Sheets). Once you have applied the formatting to a cell or […]
Google Sheets offers several quick ways to format text with strikethrough when you need it. While strikethrough is something mostly used in Google Docs, you may also need it in Google Sheets. Sometimes you want to express how some information is no longer relevant, but you want to keep it in the spreadsheet: strikethrough formatting […]
I’m here to discuss how to use VLOOKUP from another sheet in Google Sheets. My goal: Help you increase your productivity with some simple automation. After all, that’s why I love the VLOOKUP function. Below, I’ll break down the syntax and include screenshots for step-by-step instructions on how to use it. Here’s my guide on […]
If you are given a spreadsheet with numbers, it will be easy to pull off some of the formulas required to properly calculate whatever it is that you are trying to analyze. On the other hand, the “text” format of those numbers can make it very difficult and sometimes even impossible to pull these same […]
Enjoy our custom-made Google Sheets templates for free via email access
