Google Sheets is an excellent free spreadsheet app. Whether you have zero spreadsheet experience or you’re switching from another program, you’ll want to learn basics — like how to do subtraction in Google Sheets. I’ll show you how to subtract in Google Sheets using functions like MINUS and SUM in this guide. How To Subtract […]
When working in Google Sheets, you may want to periodically check the subtotal of your data set or include results in the final documentation. The SUBTOTAL function is the easiest way to accomplish this. On top of calculating subtotals for data lists, the subtotal function also: Calculates metrics with hidden or filtered data rows Dynamically […]
Sometimes you’re using Google Sheets not to collect your own information, but to collect information from others. At that point, you need something called validation. Validation ensures that the data that’s entered is correct. For instance, if you’re filling out a survey, and you need to make sure that the names are entered properly. Validation […]
The MMULT function in Google Sheets provides a really easy way to perform matrix multiplication. In this tutorial we will discuss how matrix multiplication works and how the MMULT function can help you get it done quickly and easily. We will also take a look at a use-case to understand how useful the MMULT […]
Google Sheets is used for everything from personal budget planning to professionally prepared company spreadsheets. To that end, Google Sheets includes some advanced financial functions — including the ability to calculate Net Present Value (NPV). Net Present Value is a concept that’s used to determine the profitability of things like capital expenditures and investments. With […]
The Google Sheets QUERY function is one of the most useful functions. When used to its full potential, it can do some really amazing things in Google Sheets. In this tutorial, I will explain the Google Sheets QUERY function and show you a lot of practical examples of how you can use it in Google […]
Google Sheets has a good range of functions to import data from external sources. Some of these include IMPORTRANGE, IMPORTFEED, IMPORTDATA, IMPORTXML, and IMPORTHTML. In this tutorial, we will talk about the IMPORTHTML function of Google Sheets in particular. We will discuss what the function does, what its syntax is, as well as look at some […]
Let’s discuss the GOOGLEFINANCE function in Google Sheets. It’s an incredibly powerful tool, and I use it often. Follow along to learn how to use GOOGLEFINANCE. Below, I’ll discuss the function’s use for pulling lie stock quotes into a spreadsheet. I will also include step-by-step instructions on how to use the GOOGLE finance function with […]
The SUMIFS function in Google Sheets is quite helpful in a variety of situations, including those where you want to find the sum of cell values within a given date range. What this means is, we can use the SUMIFS function to find the sum of values in a column, if corresponding dates in another […]
Watch our step-by-step video tutorial: There are certain statistical metrics that are often used to analyze and get a basic idea about a given set of data. Some of these metrics include the mean, median, mode, and standard deviation. Among these metrics, the median gives us an idea about the central tendency of the data. […]
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, […]
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 […]
Enjoy our custom-made Google Sheets templates for free via email access
