Google Sheets

An interesting workaround allows you to calculate age in Google Sheets using a date of birth. The formula allows users to subtract the current day from the date of birth […]

Just like alphabets and numbers, dates can also be sorted from earliest to latest and vice-versa. In Google Sheets this can be done with the built-in sort function, which allows […]

Looking to populate your Google Sheets spreadsheet with a bunch of randomized data? You can vastly speed up the process by making use of built-in functions. There are two different […]

To easily analyze large spreadsheets, you can make use of sorting functions that will organize your data. For those using Google’s productivity suite, the built-in sorting function allows users to […]

Once a spreadsheet contains numerous lines of data, it becomes difficult to find what you are looking for. It then becomes important to properly sort the data to ensure it […]

While Google Docs makes it easy to add bullets with a menu option, there is no such option to insert bullet points in Google Sheets. Instead, you will need to […]

A lot of people choose to color alternate rows of a spreadsheet to make it more readable. Previously color alternating rows in Google Sheets was a lengthy process, however Google […]

The #REF! error is one of the most annoying formula parse errors in Google Sheets. The error is usually caused by a missing/invalid reference or circular dependency in your formula. […]

A common error in Google Sheets is #DIV/0!. In this article we will be taking a look at what this error is, what causes the error and how you can […]

When working with large datasets it becomes difficult to keep track of what each row and column represents as you start scrolling down or rightwards. Luckily you can easily solve […]