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 […]
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 […]
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. […]
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 […]
If your dataset contains date and time values, there might be situations where you need to convert them to decimal numbers. For example, you might want to convert the difference between the start and end time of a particular task, into a decimal number. This can act as an indicator of the number of hours […]
Whether you’re a beginner or an expert spreadsheet user, you’ve come across a formula parse error at some point. While these issues are frustrating, I’m here to walk you through solving and preventing common formula parse errors like #REF, #DIV, #ERROR, and #NUM. Let’s get started! What Is a Formula Parse Error? A formula parse […]
The Google Sheets filter is a powerful tool that can help you manipulate how your spreadsheet data displays nondestructively. For example, you can use this feature to delete (or hide) every other row in Google Sheets. By using the correct filter, you can use Google Sheets to delete every other row or take it a […]
The Google Sheets SWITCH function is a helpful tool for changing how a cell behaves based on the value in another cell. It’s incredibly useful in data interpretation and presentation. To understand the SWITCH function, think of it as a function that can check multiple IF conditions. For example, you can check whether is a […]
Google Sheets makes it easy to round numbers. It features several functions that can accommodate a wide range of rounding types. Whether you need to round to the nearest whole number, the second decimal point, hundreds, or by a factor of three, there’s a rounding Google Sheets function to help. In this tutorial, I’ll cover […]
You can calculate weighted averages in Google Sheets by using a built-in formula: AVERAGE.WEIGHTED. Weighted averages are useful for calculating average scores when some factors are more important than others. What is weighted average? A weighted average is similar to an average of numbers, but each number makes up a different share of the average. […]
VLOOKUP formula (or Vertical lookup) in Google Sheets is a formula that you can use to look for a value in a columnar data set. For example, if you have a list of student names and their scores, you can use VLOOKUP to find the score of a particular student in a specific subject. VLOOKUP […]
Google Sheets has countless built-in features that automate and streamline the most common use-cases. However, when you want to do something like show a formula instead of the formula result or value, the automation can make it a little tricky. Fortunately, Google Sheets has several techniques to force a cell to show the formula information […]
Enjoy our custom-made Google Sheets templates for free via email access
