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.
Calculating the average is a common task for people working with data in Google Sheets. And when quantities in a dataset don’t carry the same amount of importance, finding simple
Google Sheets provides a suite of functions called the “IS” functions. These functions are not commonly used purely on their own but are heavily used by Google Sheets experts in
A sequence of numbers is said to be statistically random when it does not contain any recognizable patterns. In statistics, randomness can be quite crucial. For example, one often needs
How to Make a Scatter Plot in Google Sheets – Video tutorial: Visualization tools like charts and graphs are beneficial for giving better insights into your data. A scatter plot
Let’s talk about how to use VLOOKUP with multiple criteria. After all, I often use this formula to find data based on more than one thing. Fortunately, there’s an easy
The REGEXMATCH Google Sheets function is one of the most underrated functions of Google Sheets. Most users often choose not to use it as they think it will probably be
Have you come across the term, “Google Sheets INDIRECT,” but you’re unsure what it means? While Google Sheets has a myriad of functions that are pretty straightforward, the Google Sheets
Want to learn how to use the SUMIF function in Google Sheets? I created this guide to show exactly how to do it. While it’s easy to sum a range
Decimals in your data are a necessary evil. While it’s good to keep as many decimal places as you can (to ensure accuracy), it may make your spreadsheet difficult and
