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.
If you work with checklists in Google Sheets or use it to keep track of tasks/projects, you can also use checkmark symbols to show the tasks/projects that have been completed.
Does Google Sheets have macros? The short answer is YES – you can use macros in Google Sheets. What is Macro in Google Sheets? Macro – as a computing term
The war between Google Sheets and Excel users rages on. These are two of the most popular spreadsheet programs. Those who are comfortable using Google Sheets swear by it, while Microsoft
Watch Video – How to Show Negative Numbers in Red in Google Sheets There are multiple ways you can use to show negative numbers in red in Google Sheets. Doing
If you work with numbers in Google Sheets, there is one thing that can often frustrate many users. When you enter a number in a cell in Google sheets that
Merging cells is quite common when working with data in Google Sheets. A lot of times, people merge cells while creating headers or labels. And you can also easily unmerge
Sometimes, you may want to remove the first character from the string and get the rest of the string in Google Sheets. While you can do this manually for a
When working with data related to finances and business, you obviously need to represent your monetary assets. In fact, a lot of work done in spreadsheets deals with money. If
When dealing with data, we often need some metrics to understand the nature of the data. Some of these metrics include the average, the mean, mode, and standard deviation. Google
