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.
Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following, and I see many people migrating from other spreadsheet applications to Google Sheets. The fact that you can use it for free (as it comes with every Google account) is a huge reason for this […]
While Microsoft Excel still rules the spreadsheet world, Google Sheets has been slowly making inroads. It has found some loyalists in freelancers, small business owners, and entrepreneurs. While it is still not at a stage where it can crunch data like Excel or automate tasks using VBA, it does have a few advantages over Excel […]
Recently, I was working on creating a leave tracker template in Google Sheets. One of the interactive features that I wanted to create was a spin button (or scroll bar) functionality, where the user can simply click on it and the value of a cell change. While it’s easy to insert and use spin buttons […]
I am a fan of creating to-do lists and trackers. And Google Sheets is my weapon of choice. Since I have created a lot of these lists and trackers, I decided to merge all my trackers into one single Google Sheets document and then use this master tracker instead. And to do this, I had […]
Google Sheets is an excellent platform with several features for free to small businesses and individuals, which has caused many people to convert from software like Microsoft Excel. Many people use spreadsheets to keep track of their finance, grades, or schedules. Some people use Google Sheets for data analysis, which can help understand patterns that […]
Watch Video – Creating and Using Filter Views in Google Sheets Google Sheets has this amazing functionality to collaborate with other users. However, one issue when multiple people are working with the same file is that when someone changes the data, it gets changed for everyone who is working on that data. Filter Views in […]
Inserting Table of Contents can be useful if you have a lot of content and you want to quickly skip to relevant sections. If you have used word processors such as MS Word or Google Docs, you would find an easy way to insert the table of contents. But what if you want to insert […]
There might be times when you want to know what weekday it is on a specific date in Google Sheets For example, you may want to know the weekday on your birthday, or on the first date of the next month. In such cases, you can use the Google Sheets day of week (WEEKDAY) Function. […]
If you’re creating a timetable for students in Google Sheets, or just planning ahead, you may need to know when is the last Monday of the month (or any other last weekday day of the month). To calculate this, you can simply use the Google Sheets EOMONTH function In this tutorial, I will show you […]
Google Sheets has some great date related formulas that can come in handy in many situations. In this tutorial, I will show you how to calculate age in Google Sheets using date of birth. This can easily be done using the DATEDIF function in Google Sheets. Calculate Age in Google Sheets The way Google Sheets […]
Let’s discuss how to make a Google Sheets hyperlink. You might want to do this to help viewers quickly find more information about a topic, access a relevant file, or to cite your data sources. This article gives step-by-step instructions on Google Sheets hyperlinks. Before we dive in, let’s discuss one more common usage. You […]
https://www.youtube.com/watch?v=-z587aoPhCc Google Sheets has some useful functions that are not available in Excel (such as IMPORTRANGE, QUERY, IMPORTDATA, etc.) One such extremely powerful one is the FILTER function. Using the FILTER function in Google Sheets allows to instantly filter the source data to find specific information. What makes it so powerful is that it doesn’t need us to use any complex […]
Enjoy our custom-made Google Sheets templates for free via email access
