Category: Google Sheets Functions Tips & Tutorials

You can unlock the full potential of Vlookup, (vertical lookup), in Google Sheets by using it to call data across

You may think in what scenario will I need to convert text to numbers in a Google document or in

If you work with text data in Google Sheets, there are many useful text functions that can help you slice

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