Home Excel Formulas

Formulas

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

Compound Quarterly Growth Rate (CQGR)

0
Compound Quarterly Growth Rate (CQGR) in Excel is rather easy to calculate. This can be very useful to forecast potential income or...

Compound Annual Growth Rate (CAGR)

0
The compound annual growth rate (CAGR) is an essential function regardless of industry. In this tutorial, we will cover how easy it...
Reverse CAGR

Reverse Compound Annual Growth Rate (CAGR)

0
Reverse Compound Annual Growth Rate is a calculation to determine the future value of your investment. In this calculation, the Compound Annual...

Annual Growth Rate in Excel

0
Annual Growth Rate in Excel Calculating the Annual Growth Rate in Excel is very easy. Annual growth rates are...

Summing Only Positive or Negative Values

0
Learn how to sum only positive or negative values in excel. If you are an avid excel user,...
Equated Monthly Installment

Equated Monthly Installment (EMI)

0
Calculate your Equated Monthly Installment (EMI) in Excel.

Calculate Private Mortgage Insurance (PMI)

0
Learn how to calculate Private Mortgage Insurance (PMI) on a new home purchase.

Use a Letter to Represent a Value in Excel

0
This tutorial will show you how to use a letter to represent a specific value. Using this process, you can perform mathematical...

SPLIT FIRST and LAST NAMES

0
Split First and Last name This tutorial covers how to split first and last names in excel.

Percent Change Formula in Excel

0
Quickly Calculate Percentage Change in Excel.

Latest Tutorials

Year Function

YEAR Function

Delete Multiple Rows of data