You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

Find out the best practices for most financial modeling to price a bond, calculate coupon payments, and calculate a bond's yield to maturity in Microsoft Excel.

Key Points Use Excel to calculate daily returns and standard deviation to gauge stock volatility. Annualize volatility by multiplying daily standard deviation by the square root of 252.

How to use Excel’s RANK.AVG () function Figure D Figure D Word’s RANK.AVG () better accommodates duplicates. Figure E Figure E The average rank increase with every duplicate.