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.
Are you wondering how to use a Google Sheets calendar template? You can easily create a simple Google Sheets calendar template. However, it may not be very efficient because you would also need to update it every month. To save you some time (and using the power of Google Sheets), I have created the following […]
The VLOOKUP Google Sheets function can be used to look for a value in a column and when that value is found, return a value from the same row from a specified column. Now if that description sounds nerdy and difficult, here is another way to understand what this function does. Suppose you have gone […]
Google Sheets named ranges can be used to define a cell or a range of cells and give it a name. Now, instead of using the cell references, you can use the name of the named range in calculations. For example, suppose I have sales transaction data for a store, and I need to calculate metrics […]
Whether you’re completely new to spreadsheets or coming from a different program, you’ve probably wondered how to insert multiple rows in Google Sheets. Luckily, doing so is simple. There are many different methods for inserting multiple rows in Google Sheets. For example, you can insert a single row by selecting a row header, right-clicking, and […]
Google Sheets has some great data formatting tools. One such formatting feature is the ability to rotate text within a cell in Google Sheets. Something as shown below: This article will teach you how to make text vertical in Google Sheets: Using the Toolbar Using the Format Options How to Make Text Vertical in Google Sheets […]
In this tutorial, you will learn how to highlight cells using conditional formatting based on another cell in Google Sheets. This can be done using the custom function option in conditional formatting.
Google Sheets has a number of different ways in which you can visualize and easily analyze your data. One of these ways is a heat map. A heat map is a good visual analysis layer to add to your data set to get some insights quickly. They are also surprisingly easy to create using heat map […]
Prefer watching a video tutorial? View ours here: If you work with Google Sheets, there may be times when you have to convert Excel files to Google Sheets. So can you convert Excel to Google Sheets? Although there’s no method relating to how to save Excel as Google Sheets, there are a couple of methods you […]
Here, I discuss how to create a dependent drop-down list in Google Sheets. This allows you to show a list of options that affects what a user sees on the next menu. Follow along for my step-by-step advice on dependent drop-down lists in Google Sheets. I provide screenshots and practical examples. How to Create a […]
Watch Video – How to Insert an Image in a Cell in Google Sheets Normally, the way people insert an image in a cell in Google Sheets is by going to Insert –> Image and the selecting the image or specifying the URL. The issue with this method is that it treats the image as […]
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, […]
Enjoy our custom-made Google Sheets templates for free via email access
