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 want to find the sum of values based on a condition, you most probably are aware of the SUMIF formula and the SUMIFS Google Sheets function. The problem
Visualizing data using charts and graphs can be a great way to understand your data and relationships between the variables in the data. Moreover, adding a trend line (also called
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
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
