Category Archives for "Tech Tips"

How to Create and Use Filter Views in Google Sheets

Filter Views in Google Sheets - Dataset

Watch Video – Creating and Using Filter Views in Google Sheets Google Sheets has this amazing functionality to collaborate with other users. However, one issue when multiple people are working with the same file is that when someone changes the data, it gets changed for everyone who is working on that data. Filter Views in […]

Continue Reading >>

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 calculate someone’s age in Google Sheets using their date of birth. This can easily be done using the DATEDIF function in Google Sheets. Calculate Age in Google Sheets The way […]

Continue Reading >>

Using FILTER Function in Google Sheets (explained with Examples)

Filter Function in Google Sheets - using Cell References

Watch video – Using FILTER function in Google Sheets (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 FILTER function. FILTER function allows to instantly filter the source data and get the result. What makes is so powerful […]

Continue Reading >>

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 met, else it returns FALSE. OR Function Syntax OR(logical_expression1, [logical_expression2, …]) logical_expression1 – The first condition that you want to check. This could be a cell reference that has the TRUE/FALSE […]

Continue Reading >>
1 2 3 8