Sumit is a Google Sheets and Microsoft Excel Expert.
Highlights
Experience
Sumit Bansal is renowned for his ability to simplify complex spreadsheet formulas, making them accessible and understandable. His writing is focused on providing practical, user-friendly training and tips to small business owners and data teams. Sumit's unique approach involves breaking down intricate spreadsheet functions into easily digestible parts.
Apart from his writing, Sumit is involved in business consulting, offering valuable insights and solutions to businesses aiming to optimize their data management and analysis processes using spreadsheet tools.
Education and Awards
Sumit's expertise in spreadsheets is recognized globally, as evidenced by his receipt of the Excel MVP award from Microsoft. This award highlights his exceptional skill in Excel and his commitment to sharing his knowledge and helping others in the field.
Before I get into the Google Sheet vs Excel debate, there is something you need to know. I love Excel spreadsheets, and I have been an active user for 12+
Google Sheets is a widely popular spreadsheet tool, prized for its accessibility, collaboration features, and integration with other Google Workspace apps. However, like any software, it has its limitations.
I often want to select more than one option in a drop-down list. For example, when there’s a collection of colors to choose from, I might like more than one color. Or, in a document where we list proficiencies, I might want to choose more than one from a list of coding languages. In cases where my employee has multiple skills, I want to select multiple options from the drop-down.
Merging cells in Google Sheets can enhance your spreadsheet’s organization and appearance, whether you’re combining cells in rows, columns, or both. A common scenario is when you have a shared
Here’s how to count colored cells in Google Sheets. I have a full video guide and a written guide with step-by-step instructions and screenshots below. I’m also including a powerful
There are a few easy ways to zoom out on Google Sheets. These methods also allow you to zoom in. This guide shows where to find the view menu and
To highlight duplicates in Google Sheets, use conditional formatting and the COUNTIF function. My guide below covers this in detail. Specifically, I’ll show how to use conditional formatting to highlight
There are a multitude of situations when you might need to calculate the age of a group of people based on their date of birth. Unfortunately, it’s not as simple as just taking the birth year and subtracting it from the current year.
To hide gridlines in Google Sheets, use the “show” menu. I’ll show where to find this (and how to add only specific lines in your spreadsheet) below. Note that my
