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.
In most cases, data is arranged vertically (i.e., you read it from top to bottom) and there is an in-built functionality in Google Sheets to sort data that is arranged
Don’t feel like reading? View our video tutorial for the Google Sheets FILTER function: Google Sheets has some great functions that can help slice and dice data easily. Although there
While Google Sheets already have cells that you can use to add numbers or text, sometimes you may need to insert a text box in Google Sheets. This could be
To multiply in Google Sheets and Excel, use the equal sign followed by a multiplication formula. After all, most people use Google Sheets for two basic purposes — creating a
There are so many things that a lot of us do regularly in Google Sheets. And while a lot of these options are readily available with a few clicks, you
Sorting data in Google Sheets is pretty straight forward. You can sort a single column (alphabetically or based on the numeric value in ascending/descending order) or multiple columns (based on
If you’re working with a lot of sheets in a Google spreadsheet document, you may want to create a table of contents of all the sheets. It would make it
When working with data in Google Sheets, you may need to combine some specific cells (or combine cells in two columns). There are multiple ways you can do this using
If you’ve been asking yourself “Can Google Sheets add a new line in a Cell?” The short answer is yes. In this tutorial, I will show you a few ways
