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.
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.
When working with text data in Google Sheets, sometimes you may have a need to change the rotation of the text. In some cases, you may want to make it
Google Sheets checkboxes evaluate to TRUE and FALSE, which makes counting completed tasks simple. Hereโs how to count checked and unchecked boxes, add conditional totals, and scale your tracker with ARRAYFORMULA.
If you work with the data in Google Sheets, it would be safe for me to assume that you have it in a tabular format (i.e., have the data in
A Google Sheets org chart is quite commonly used in presentations and reports. It’s a simple chart that shows the hierarchy of who reports to whom in an organization. Below
Use Conditional Formatting in Google Sheets to automatically highlight the highest or lowest value in any dataset with no manual scanning required. This tutorial covers max, min, top N, bottom N, and full-row highlighting with simple custom formulas.
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
