Category: Google Sheets Tips & Tutorials

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

Watch Video – How to Freeze / Lock Rows and Column in Google Sheets You may want to freeze/lock rows

If you work with formulas in Google Sheets, you would know that errors can pop-up any time. While getting errors

A drop-down list in Google Sheets can be helpful when you want the user to select from pre-defined options. It’s

IMPORTFEED function in Google Sheets can be used to import the RSS feed in the worksheet. This can be useful