I’m here to discuss how to use VLOOKUP from another sheet in Google Sheets. My goal: Help you increase your productivity with some simple automation. After all, that’s why I love the VLOOKUP function. Below, I’ll break down the syntax and include screenshots for step-by-step instructions on how to use it. Here’s my guide on […]
If you are given a spreadsheet with numbers, it will be easy to pull off some of the formulas required to properly calculate whatever it is that you are trying to analyze. On the other hand, the “text” format of those numbers can make it very difficult and sometimes even impossible to pull these same […]
If you work with text data in Google Sheets, there are many useful text functions that can help you slice and dice the text data or modify it easily. One of the common tasks that many people need to do is capitalize the first letter (alphabet) in Google Sheets. In this tutorial, I will show […]
Are you looking for a Google Sheets remove last character step-by-step guide? When working with data in Google Sheets, sometimes you must remove the last character from a string (or remove the last 2 or 3 or 5 characters). This can easily be done using some basic formulas in Google Sheets. In this tutorial, I […]
There might be times when you want to know what weekday it is on a specific date in Google Sheets For example, you may want to know the weekday on your birthday, or on the first date of the next month. In such cases, you can use the Google Sheets day of week (WEEKDAY) Function. […]
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 […]
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 […]
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 […]
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 […]
Enjoy our custom-made Google Sheets templates for free via email access
