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.
Here, I’ll show you how to add days to date in Google Sheets. You might want to add a certain number of days up to a delivery date or add a security period of a few days to a given date. Whatever your purpose, Google Sheets add days to date is really easy. In this […]
REGEXEXTRACT Google Sheets function is part of the suite of REGEX functions available to many users. The function is extremely handy when you are trying to dig out a certain string that is part of a larger one. The only prerequisite to using this function is a firm grasp of regular expressions. In this tutorial, […]
Let’s talk about Google Sheets Goal Seek. It’s a valuable tool and one that doesn’t get enough attention. In this article, I will show you how to use Goal Seek. As always, expect practical examples and a full breakdown of the function. By the end, you should be completely familiar with Goal Seek in Google […]
The REGEXREPLACE Google Sheets function lets you quickly replace parts of strings in your sheets. It comes as part of a suite of Google Sheet replace string functions along with functions like REGEXEXTRACT and REGEXMATCH. At first, the inclusion of regular expressions in REGEX functions might seem intimidating, but once you get the hang of […]
A running total is a useful aggregation tool that helps you see the cumulative sum of a sequence of numbers at any point in the sequence. It is widely used in a number of applications in both academics and the business world. In this tutorial, we are going to show you how to add a […]
Let’s talk about how to make a candlestick chart in Google Sheets. After all, charts and graphs give you a birds-eye view of your data and help you make inferences. I use a candlestick chart to track variations in values of a variable over time. And it’s not difficult to do. In this tutorial, I’ll […]
The INDEX function is perhaps one of the most under-used functions in Google Sheets. However, if you know the right way to use it, you’ll find it quite handy in a lot of applications. In this tutorial, we will show you two ways to use the Google Sheets INDEX function: When you want to return […]
Wildcards are a very versatile set of symbols that help you select a group of similar strings at a time. In this tutorial, I will cover what are wildcards in Google Sheets and how to apply them. We will also take a look at a few use-cases where wildcards can be highly helpful. What are […]
How do you add text to formulas in Google Sheets? We’re glad you asked. Combining text and numbers is common in spreadsheets, for example when you want to add some context to shared sheets. In this article, which we’re calling our “Google Sheets Add Text to Formula Guide”, we go in depth on the subject. […]
The world of data sharing and saving changed when Adobe invented the PDF format. It became a common thing to work with data received in the form of PDF documents. You might have a scanned copy of important data that you need to process in Google Sheets, or you may want to work on a […]
I’ll show you how to convert text to date in Google Sheets. Without an understanding of the process, some users get frustrated. That’s why I include step-by-step instructions on how to convert text to dates. Follow along with my full guide below. I cover DATEVALUE and TO_DATE functions, which are invaluable when you want to […]
Formulas always help make data processing easier and faster. As helpful as they are, formulas can sometimes come in the way of what we are trying to achieve. So, it could become necessary at times to convert formula results to values. In essence, we are only replacing the formulas with the values obtained as a […]
Enjoy our custom-made Google Sheets templates for free via email access
