Formulas Articles

Stock Market trading relies heavily on analysis of past data. It requires observing trends and identifying patterns to make the right decisions. Indicators like market breadth, market sentiment, balance volume, and moving averages form a

So, you have a column in Google Sheets. But, it needs some modification. How do you append text in Google Sheets? There may come a time when you need to add text to an existing

SUBTOTAL is a function in Google Sheets that can be incredibly versatile. With the right tips and tools, it can be dynamic and powerful, allowing you to exponentially increase your sheets’ functionality. When using the

Google Sheets has a lot of functions meant for analyzing data. FREQUENCY() is one of them. FREQUENCY() helps you count how often a given value in an array occurs within another array. It’s a method

You had your data neatly in order. But now, you need to flip it. What do you do? You don’t want to manually rewrite your entire list. Flipping a column can occur for a few

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,