Equated Monthly Installment (EMI)
Calculate your Equated Monthly Installment (EMI) in Excel.
Formulas
Formulas are expressions that utilize defined values and provide a calculation. Formulas provide computational power for your spreadsheets.
Reverse Compound Annual Growth Rate (CAGR)
Reverse Compound Annual Growth Rate is a calculation to determine the future value of your investment. In this calculation, the Compound Annual Growth Rate (CAGR), which is the …
Use a Letter to Represent a Value in Excel
This tutorial will show you how to use a letter to represent a specific value. Using this process, you can perform mathematical calculations, such as multiplying X time …
Calculate Private Mortgage Insurance (PMI)
Learn how to calculate Private Mortgage Insurance (PMI) on a new home purchase.
Get the day name of a date in Excel
Here is an easy way to get the name of a date in Excel. Overview: Let’s look at the following example using the TEXT Function. By using this …
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 …