Formulas

### How to Find 7-Day Moving Average in Google Sheets

The Simple Moving Average (SMA) constantly adds up an agency's closing price and divides the sum by the number of periods to get the average price of ...

### How to Make REGEXMATCH Case Insensitive in Google Sheets

The REGEXMATCH function is a very helpful tool in Google Sheets. However, this function is case-sensitive. So, sometimes it eliminates some matches ...

### Use COUNTIF Function to Count Unique Values in Google Sheets

Using the COUNTIF and UNIQUE functions in Google Sheets can greatly benefit businesses and finance professionals by quickly identifying and tracking ...

In Google Sheets, the Pivot Table can be a very useful tool to summarize a huge dataset. To analyze data, you can insert any general function from ...

### How to Insert an Exponent in Google Sheets (3 Easy Ways)

We frequently use exponents in our calculations. Sometimes we require exponents in texts also; for example, consider expressing Einstien’s ...

### How to Use COUNTIF for True Condition in Google Sheets

By using the COUNTIF function to find TRUE conditions and values in Google Sheets, a business can quickly and easily count the number of times a ...

### How to Use COUNTIF for Cells Not Equal to Text in Google Sheets

In Google Sheets, if you want to count values except for any specific values, you can also apply the COUNTIF function with a specialized operator. ...

### How to Find Slope of Trendline in Google Sheets (4 Simple Ways)

You might be familiar with the idea of a slope and trendline if you frequently show research reports, or financial data, or need to perform ...

### How to Find Median in Google Sheets (2 Easy Ways)

While working on a dataset sometimes you need to get the middle value of the dataset. For example, if you are working on the sales chart of your ...

### How to Split Text to Columns Using Formula in Google Sheets

In order to properly extract meaning from the data that has been gathered, text strings must be split as a necessary first step in data analysis. For ...

### How to Filter Unique Values in Google Sheets (5 Simple Ways)

Suppose you are working on a dataset where you must remove duplicates and count all the unique values. If your dataset is large then finding every ...

### Use COUNTIF If Cell Contains Specific Text in Google Sheets

In business and finance, it's essential to analyze data quickly and accurately. One way to do this is by using the COUNTIF function in Google Sheets ...

### How to Split Cells to Get Last Value in Google Sheets (4 Methods)

Getting the last element of cells is often necessary. For instance, we may need to separate different portions of a person's name from a single ...

### How to Concatenate Values for IF Condition in Google Sheets

In Google Sheets, you can combine cells by using some functions. CONCATENATE, JOIN and TEXTJOIN are the most popular among them. To apply some ...

### How to Concatenate Two Columns in Google Sheets

In business and finance, combining data from multiple columns can be crucial for analysis and decision-making. One way to do this is through the ...