Category Archives for Google Sheets Tips

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 Search in Google Sheets and Highlight the Matching Data

Search in Google Sheets and Highlight the Matching Data - Demo

Watch Video – Search in Google Sheets and Highlight the Matching Data If you work with huge datasets in Google Sheets, sometimes, it may get difficult to identify some data points. For example, if you have a list of students and their marks, it can take some time to find a student name and all […]

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 >>

How to Use IMPORTRANGE Function in Google Sheets (with Examples)

Result of the IMPORT Range function in Google Sheets

Do you want to import the data from other Google Sheets into the one in which your working currently? You can do this easily using the IMPORTRANGE function in Google Sheets. While it’s really easy to connect two workbooks in Excel that reside on your hard drive or a network drive, the only way to […]

Continue Reading >>

How to Use IMPORTDATA function in Google Sheets

Result of IMPORTDATA function in Google Sheets

IMPORTDATA function is Google sheets allows you to quickly import the data from the URL of a .csv (comma separated value) or .tsv (tab separated value) file. This can be useful if you’re working with data that is available online in a .csv/.tsv file. Using IMPORTDATA function, you can instantly get the data in Googe Sheets […]

Continue Reading >>

Calculate the Number of Days Between Two Dates in Google Sheets

calculating weekend days using DAYS and NETWORKDAYS formula Google Sheets

There are a couple of useful functions in Google Sheets that will quickly calculate the number of days between the two specified dates. This kind of calculation can be useful if you’re creating a schedule for your students or while creating project plans that have the start and end dates. In this tutorial, I will […]

Continue Reading >>

Using IFS Function in Google Sheets to Test Multiple Conditions

Calculating Commission using IFS function in Google Sheets Formula

In Google Sheets, you can use the IFS function to test multiple conditions at once and then return the result based on it. The difference between the IF function and the IFS function is that in IFS function, you can test multiple conditions at once. As soon as the condition is found to be TRUE, […]

Continue Reading >>

How to Quickly Freeze / Lock Rows in Google Sheets

Watch Video – How to Freeze / Lock Rows and Column in Google Sheets You may want to freeze/lock rows in Google Sheets if you’re working with a large dataset that requires you to scroll up and down a lot. Freezing rows at the top would make those rows visible all the time so that […]

Continue Reading >>

Using IFERROR Function in Google Sheets (with Examples)

If you work with formulas in Google Sheets, you would know that errors can pop-up any time. While getting errors is a part of working with formulas in Google Sheets, it’s important to know how to handle these errors in the right way. In this tutorial, I will show you how to handle errors in […]

Continue Reading >>

How to Create a Drop Down List in Google Sheets

A drop down list in Google Sheets can be helpful when you want the user to select from pre-defined options. It’s a great way to make the data entry consistent. Watch Video – Creating Drop Down Lists in Google Sheets   For example, a user from a drop down list can select easily the country […]

Continue Reading >>
1 2 3 5