Google Sheets Weekday Function – Explained with Examples

There might be times when you want to know what weekday it is on a specific date. For example, you may want to know the […]

How to Get the Last Monday of the Month in Google Sheets

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 […]

Calculate Age in Google Sheets (using the Date of Birth)

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 […]

How to Create Hyperlinks in Google Sheets (Step-by-Step Guide)

A hyperlink allows you to quickly access an external webpage or a file/folder in your system. These are widely used in web-pages to link to […]

How to Search in Google Sheets and Highlight the 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 […]

Using FILTER Function in Google Sheets (explained with Examples)

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 […]

How to Use OR Function in Google Sheets (with Examples)

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 […]

Calculate the Number of Days Between Two Dates in Google Sheets

There are a couple of useful functions in Google Sheets that will quickly calculate the number of days between the two specified dates. This kind […]

How to Use 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) […]

How to Use IMPORTRANGE Function in Google Sheets (with Examples)

Do you want to import the data from other Google Sheets into the one in which your working currently? You can do this easily using […]

Using IFERROR Function in Google Sheets (with Examples)

If you work with formulas in Google Sheets, you would know that errors can pop-up any time. While getting errors is a part of working […]

How to Quickly Freeze / Lock Rows in Google Sheets

Watch Video – How to Freeze / Lock Rows and Column in Google Sheets You may want to freeze/lock rows in Google Sheets if you’re […]

We are updating our Privacy Policy, so please make sure you take a minute to review it. As of May 25, 2018 your continued use of our services will be subject to this new Privacy Policy.
Review Privacy Policy OK