# Formulas

Formulas are expressions that utilize defined values and provide a calculation. Formulas provide computational power for your spreadsheets.

## SUMPRODUCT and EXACT Formula

In this tutorial, we will combine the SUMPRODUCT and EXACT Function in a formula to determine the total number of Wins for Ohio State. Yes, to be fair, …

## SPLIT FIRST and LAST NAMES

Split First and Last name This tutorial covers how to split first and last names in excel. Splitting First and Last names from a combined cell in Excel …

## Compound Quarterly Growth Rate (CQGR)

Compound Quarterly Growth Rate (CQGR) in Excel is rather easy to calculate. This can be very useful to forecast potential income or forecast personal returns. Before we begin, …

## Summing Only Positive or Negative Values

Learn how to sum only positive or negative values in excel. If you are an avid excel user, you will eventually have a need to only sum either …

## Compound Annual Growth Rate (CAGR)

The compound annual growth rate (CAGR) is an essential function regardless of industry. In this tutorial, we will cover how easy it is in Excel to formulate this …

## Annual Growth Rate in Excel

Annual Growth Rate in Excel Calculating the Annual Growth Rate in Excel is very easy. Annual growth rates are used across all industries to determine business trends both …

Scroll to Top