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.
Don’t feel like reading? View our video tutorial: When working with data in Google Sheets, you may have a need to highlight the highest value (the maximum value) or the
Google Sheets is a smart spreadsheet tool that has been made to be user intuitive. This means that sometimes when you enter data in Google Sheets, it will try to
If you work with ever-expanding data (where you keep adding more values in the column or in the row), then sometimes you may have a need to know what’s the
Recently I got this query from a reader on whether there’s a formula to get the column letter instead of the column index number in Google Sheets. For example, column
Sometimes, you may want a quick way to get the name of the current sheet in a cell (or a list of all the sheets in the Google Sheets documents
Google Sheets has some kick-ass functions that can do a lot of heavy lifting. As a part of my online work, I often need to go to some websites and
View our video tutorial: Sometimes you may have a need for Google sheets to keep refreshing themselves after a certain time interval. For example, if you’re tracking stock prices in
Watch Video – Remove Hyperlinks in Google Sheets Hyperlinks are quite useful in Google Sheets when you’re working with web page data. Or when you have links to files and
Those who switch from using Excel to Google Sheets often miss the fact that there is no in-built feature in Google Sheets to split cells diagonally. But if you still
