Formulas Articles

How to Calculate Moving Average in Google Sheets
Formulas

How to Calculate Moving Average in Google Sheets

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

Easy Guide: How to Subtotal in Google Sheets
Formulas

Easy Guide: How to Subtotal in Google Sheets

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

How to Use FREQUENCY Function in Google Sheets
Formulas

How to Use FREQUENCY Function in Google Sheets

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

how to use lookup in google sheets
Formulas

How to Use LOOKUP in Google Sheets (Easy Tutorial)

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.

How To Square In Google Sheets
Formulas

How To Square In Google Sheets (Very Easy)

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