Google Sheets isn’t a database. But it can be used for basic database functions. The LOOKUP function can be used to find specific information within a set of data. Related functions include VLOOKUP and HLOOKUP.
Today, we’re going to look at something fairly easy to do in Google Sheets: square! Squaring a number means multiplying that number by itself. The square of 5, for instance, is 5*5=25. Google Sheets has
The IFNA function in Google Sheets helps handle N/A errors that are returned when a search value is not found by a formula. This tutorial shows how it is used.
Data that has been imported from multiple sources often has the tendency to contain multiple copies of the same entries. As such, one of the prime tasks in data cleaning is to clear duplicate values,
The Google Sheets NOT function is a handy tool that lets you negate or reverse a logical value. This tutorial shows how to apply it in different use cases.
This tutorial shows some useful tricks and different use-cases to demonstrate how to use Google Sheets to extract numbers from strings.
The Google Sheets OFFSET function is quite an under-used function. This is mainly because a lot of people don’t understand the purpose behind the function, or how it can be effectively made use of. In
Ever tried comparing the contents of two different Google Sheets to find discrepancies? If they’re small worksheets with a few rows and columns of data, it might not be that tough. With larger amounts of
Google Sheets has been coming up with some really killer features lately, and the checkbox in Google Sheets is very useful. It’s super easy to insert a checkbox to a cell (unlike MS Excel, where