Learn how to approximate the effective convexity of bonds using Microsoft Excel with a modified and simpler version of the standard convexity formula.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

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

How to Calculate Fluctuations in Excel. Calculating data fluctuations-- also called variance -- is a multi-step process that requires total accuracy. Excel 2010 provides two basic formulas for ...

To calculate statistical variance in Microsoft Excel, use the built-in Excel function VAR.

How to Calculate Negatives in Excel. Microsoft Excel has the ability to automatically recognize a positive or negative number that you enter in a cell. However, if an incorrect format is selected ...

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.