Category: Google Sheets Tips & Tutorials

Inserting Table of Contents can be useful if you have a lot of content and you want to quickly skip

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

If you’re creating a timetable for students in Google Sheets, or just planning ahead, you may need to know when

Google Sheets has some great date related formulas that can come in handy in many situations. In this tutorial, I

A hyperlink allows you to quickly access an external webpage or a file/folder in your system. These are widely used

Watch video – Using FILTER function in Google Sheets (examples) Google Sheets has some useful functions that are not available

Watch Video – How to Search a Google Sheet and Highlight the Matching Data If you work with huge datasets

OR function is useful when you want to evaluate a set of conditions. It will return TRUE when any of

Watch Video – IMPORTRANGE Function in Google Sheets Do you want to import the data from other Google Sheets into

Watch Video – IMPORTDATA Function in Google Sheets IMPORTDATA function is Google sheets allows you to quickly import the data

There are a couple of useful functions in Google Sheets that will quickly calculate the number of days between the

In Google Sheets, you can use the IFS function to test multiple conditions at once and then return the result