Sumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people.
Browse all posts and insights written by Sumit.
Wondering how to use Google Sheets to compare two columns? I love how easy Google Sheets makes streamlining data, especially when I remember how complicated manual tasks used to be! With the right formulas, Google Sheets automates the process, returning results almost instantaneously. My tutorial will show you how to compare two columns in Google […]
Histograms are an incredibly useful way to show how data distributes into groups in a larger range. A histogram sorts data into “buckets” of closely related values instead of by unique values. Google Sheets features an easy-to-use, built-in histogram graphing tool. Instead of listing how many times someone scored a given percentage on a test, […]
Sorting by color in Google Sheets is just a few mouse clicks or screen taps away. Google added this capability to the Sheets app in March of 2020. You can use the color sorting to arrange cells by both fill (background) and text color. Enabling the Sort by Color functionality Google Sheets enables the color […]
How to Make a Pie Chart in Google Sheets – Step-by-Step Video Tutorial: How to make a pie chart in Google Sheets? Pie charts are a great way to visually represent data because they are easy to create and analyze. You can create your own pie chart on Google Sheets very easily. Google Sheets also […]
Spreadsheets these days are all about automating as many of your tasks as possible. Imagine a scenario where you have to process an order, create an invoice, and then email the invoice to concerned parties while updating all necessary order details to a spreadsheet. Believe it or not, it’s actually possible to do all this […]
If you work with text data in Google Sheets, there are many useful text functions that can help you slice and dice the text data or modify it easily. One of the common tasks that many people need to do is capitalize the first letter (alphabet) in Google Sheets. In this tutorial, I will show […]
Are you looking for a Google Sheets remove last character step-by-step guide? When working with data in Google Sheets, sometimes you must remove the last character from a string (or remove the last 2 or 3 or 5 characters). This can easily be done using some basic formulas in Google Sheets. In this tutorial, I […]
Looking for a leave tracker Google Sheet template that can track the leave of your employees or students? You’re in the right place. In this post, I am sharing one of my best templates – the employee vacation tracker template in Google Sheets (you can also use this as an employee paid time off tracking […]
Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According to Wikipedia – a sparkline is a small graphic designed to give a quick representation of numerical or statistical information within […]
Are you wondering how to remove gridlines in Google Sheets? Just like most of the spreadsheet tools, Google Sheets has gridlines around the cells. But what are gridlines? Gridlines help to make your data look more clear by distinguishing the different cells in the worksheet. They are used to connect the worksheet’s rows and columns, […]
Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work on the sheet simultaneously. In this tutorial, you’ll learn various to insert a timestamp in Google Sheets: Consider Taking a Course The basics of inserting a timestamps are pretty straightforward. But, they are […]
Fun fact, the checkbox is believed to have originated in the Roman empire. It came from the shortening of the word Veritas, meaning truth, to V. The V later evolved to look like the tick we are familiar with today. Checkboxes are a good way to keep track of data. Google Sheets recently added an option […]
Enjoy our custom-made Google Sheets templates for free via email access
