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 […]
Watch Video – How to Search in Google Sheets and Highlight Matching Data If you work with huge datasets in Google Sheets, sometimes, it may get difficult to identify some data points. For example, if you have a list of students and their marks, it can take some time to find a student name and […]
OR function is useful when you want to evaluate a set of conditions. It will return TRUE when any of the conditions being checked are met, else it returns FALSE. Let’s dive into our OR function Google Sheets guide. OR Function Google Sheets Syntax OR in Google Sheets works with the following syntax: OR(logical_expression1, [logical_expression2, …]) […]
Importing data from other documents into your current file doesn’t have to be hard. I’ll use this IMPORTRANGE Google Sheets function guide to show you how to do it in just a few minutes. This blog post will discuss the process in further detail below. But, essentially, IMPORTANGE in Google Sheets can be boiled down […]
Watch Video – IMPORTDATA Function in Google Sheets IMPORTDATA function is Google sheets allows you to quickly import the data from the URL of a .csv (comma separated value) or .tsv (tab-separated value) file. This can be useful if you’re working with data that is available online in a .csv/.tsv file. Using IMPORTDATA function, you […]
The IFS Google Sheets function lets you easily test multiple conditions in a single formula. While the functions can get long and seem daunting, once you understand them,y ou’ll be applying them fluently. This guide aims to teach you everything you need to know about IFS statements in Google Sheets to get started quickly. Read […]
Do you want to learn how to freeze a row in Google Sheets? You’ve come to the right place! In this detailed guide, I’ll discuss how to freeze and unfreeze rows or columns in Google Sheets with my step-by-step instructions and screenshots. While there are several methods of freezing rows, the quickest and easiest way […]
If you work with formulas in Google Sheets, you know that errors can pop up any time. While getting errors is a part of working with formulas in Google Sheets, it’s important to know how to handle them correctly. In this tutorial, I will show you how to use the IFERROR Google Sheets function to […]
A drop-down list in Google Sheets can be helpful when you want the user to select from pre-defined options. It’s a great way to make the data entry consistent. Watch Video – How to Add Google Sheets Drop-Down List For example, a user from a drop-down list can select easily the country as the US. […]
Enjoy our custom-made Google Sheets templates for free via email access
