Category Archives for Google Sheets Tips

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

Using IMPORTFEED in Google Sheets to Fetch Feed from URL

Fetch only the title from the feed of a website

IMPORTFEED function in Google Sheets can be used to import the RSS feed in the worksheet. This can be useful if you want to keep track of new blog posts or news items on your favorite website. For example, you can create a list of websites that you want to follow and quickly get the […]

Continue Reading >>

Using Query Function in Google Sheets – Examples

Data arranged in ascending order in Query Function in Google Sheets

QUERY function is one of the best and most useful functions in Google Sheets. When used to its full potential, it can do some really amazing things in Google Sheets. In this tutorial, I will explain the Query function and show you a lot of practical examples of how you can use it in Google […]

Continue Reading >>
1 2 3 5