Category: Google Sheets Functions Tips & Tutorials

When working with data in Google Sheets, sometimes you may have a need to remove the last character from a

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

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

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

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

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

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

QUERY function is one of the best and most useful functions in Google Sheets. When used to its full potential,

Google Sheets VLOOKUP function can be used to look for a value in a column and when that value is

COUNTIF Function in Google Sheets can be used when you want to get the count when a given condition is