Formulas Articles

A big part of data analytics involves data cleaning. Well cleaned data is one that is free from incomplete, irrelevant, and redundant records. To remove redundancy, you need to get rid of duplicates, so that

Expressing quantities in percentage always help give a better sense of proportion. It helps us visualize the quantity better in our heads and is great for making comparisons. It’s no wonder that most common quantities

It’s always easier to work with data that has been organized and sorted in a particular order. They are easier to sift through and it’s easier to find data items of interest. This is why

If you want to find the sum of values based on a condition, you most probably are aware of the SUMIF and the SUMIFS function in Google Sheets. The problem with the SUMIF function is

Calculating the average is a common task for people working with data in Google Sheets. And when quantities in a dataset don’t carry the same amount of importance, finding simple arithmetic mean doesn’t really suffice.

Google sheets provide a suite of functions called the “IS” functions. These functions are not commonly used purely on their own but are heavily used by Google Sheets experts in combination with many other functions.

When working with money-related data in your spreadsheets, there may come a time where you need to convert between currencies. Of course, it is always possible to Google the conversion rates and then enter them

A sequence of numbers is said to be statistically random when it does not contain any recognizable patterns. In statistics, randomness can be quite crucial. For example, one often needs to use random numbers when

When you have to refer to data from multiple sheets or tables, physically looking them up can be painstaking. Google Sheets helps overcome this problem with its VLOOKUP function. Using the VLOOKUP, or Vertical Lookup