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.
There’s a simple way to spell check in Google Sheets. Below, I’ll show you where to find it and how to make the most of it. Note that this differs
Do you need to hide zero values in Google Sheets? You’re in the right place. Sometimes, your data set looks cluttered with a bunch of zero values. That might be
Google Sheets VLOOKUP from another sheet is a simple way to pull data from other sources. To VLOOKUP from another sheet in Google Sheets, you can use the IMPORTRANGE function
Want to learn how to delete empty rows in Google Sheets? It’s a valuable skill that I use regularly, and luckily, it’s easy to learn, especially as I have highlighted
Occasionally, you may need to keep track of work by using a timestamp. This simple record is a great way to illustrate precisely when activities were carried out. It’s also
Google Sheets can convert currencies automatically with one GOOGLEFINANCE formula. This guide shows how to pull live exchange rates, convert amounts from USD to popular currencies, fetch historical rates, troubleshoot errors, and handle Excel currency conversion when you need it.
If you work with text data in Google Sheets, you may occasionally need to know the character count in Google Sheets. It turns out that itโs extremely easy to use
Any work with text data or numbers in Google Sheets, sooner or later you will have to deal with those pesky extra spaces that find their way in the cells.
To delete multiple sheets in Google Sheets, just use CTRL when you click on multiple tabs. Then right-click and choose to delete them. Otherwise, you’ll need to write a script.
