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 […]
Regarding free spreadsheet software, Google Sheets is hard to beat. In this program, you can make labels, mailing lists, and other documents based-data, thus making it a useful tool. However, printing labels is not an option in Google Sheets. But don’t worry. If you want to learn how to print labels from Google Sheets, you […]
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. […]
Sometimes, a visualization helps to group data and find patterns. That’s why I love a scatter plot in Google Sheets. They’re useful for showing trends and relationships in data when other graphs aren’t up to the task. So how do you make a scatter plot? My guide below shows the step-by-step instructions. How to Make […]
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 […]
Recovering deleted Google Sheets is a straight-forward process – thanks to Google Drive integration. It can be very startling when you realize you need information from a Google Sheet that you or someone else you work with deleted it. Fortunately, restoring a deleted Google Sheet is a brief process if you know where to look. […]
How to move columns in Google Sheets? Google Sheets offers several methods for transferring columns around on a spreadsheet. It’s common to come back to the data and realize that how it is organized no longer makes the most sense. You can use these three approaches on how to move columns in Google Sheets: Drag […]
If you’re new to Google Sheets or you’ve never relied on the “hide rows” feature, you may be a little confused looking at a workbook where rows are missing from the display. Hiding rows in Google Sheets is very helpful for showing off the data you want someone to look at in a spreadsheet. Google Sheets […]
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 […]
Formatting data and making it look good and more readable is something we often do when working with Google Sheets. And Google Sheets has a tool that makes copy-pasting of formatting really easy. It’s the Format Painter tool (called the Paint Format in Google Sheets). Once you have applied the formatting to a cell or […]
Google Sheets offers several quick ways to format text with strikethrough when you need it. While strikethrough is something mostly used in Google Docs, you may also need it in Google Sheets. Sometimes you want to express how some information is no longer relevant, but you want to keep it in the spreadsheet: strikethrough formatting […]
Enjoy our custom-made Google Sheets templates for free via email access
