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.

Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

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

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.

Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan.

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

How to add a condition to rank using a PivotTable in Excel A simple rank is easy to calculate, but sometimes you’ll want to accommodate a condition.

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

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

Using the closing values, you will first calculate the asset's daily returns. With those values, you can use a spreadsheet program like Microsoft Excel to calculate the asset's standard deviation.