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.
Learn how to insert an image in a cell in Google Sheets. This guide shows each step with photos, videos, and detailed instructions.
Google Sheets has some useful tools that you can use when working with data. If you like things in a particular way, then youโve probably needed a way to organize
Google sheets is a free, web-based application that has made online creation and sharing of work so much easier for students and office people. While it offers so many amazing
Sorting by date in Google Sheets is straightforward when your data is clean but broken date formats can silently ruin your sort order. This guide covers every method, including the dynamic SORT function and a fast way to diagnose text-formatted dates before they cause problems.
Google Sheets has some great shortcuts that can help you get the work done a lot faster (and more accurately). One such functionality is Google Sheets Fill Down. Fill Down
Hiding columns in Google Sheets takes one keyboard shortcut or two clicks. This guide covers four methods for hiding columns, plus how to handle rows, full sheets, and unused columns on desktop and mobile.
When working with data in Google Sheets, youโll probably need to insert multiple rows between the existing rows (or at the top/bottom of a dataset). Learning how to insert rows
Watch Video – How to Color Alternate Rows in Google Sheets (With and without Conditional Formatting) If you prefer reading over watching a video, below is a written tutorial for
There are some times I wish Google Sheets had some more functionalities like MS Excel. One such functionality that isn’t available in Google Sheets is the ability to filter by
