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.
Giving a name to your columns can be quite useful if you want to use these in the formulas. Instead of using the column alphabet in the formula, you can
We often feel the need to rearrange columns in our spreadsheet. Sometimes as an after-thought, other times, we might want to bring two columns next to each other to just
A big part of data analytics involves data cleaning. Well cleaned data is one that is free from incomplete, irrelevant, and redundant records. To remove redundancy, you need to get
In this tutorial, I will show you how to do percentages in Google Sheets using the Google Sheets percentage formula and other applications. What is a Percentage? Expressing quantities in
We often need to insert new columns when working with data in spreadsheets. When there are multiple columns that need to be inserted, it often helps to insert them all
It’s always easier to work with data that has been organized and sorted in a particular order. This is why the Sort function in Google Sheets is so useful. But
Google Sheets is known for having a number of convenient and time-saving features. One such feature is the option to find and replace text. Finding and replacing text within a
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
