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

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.

Easy way to calculate time difference in Excel using simple logic. A simple formula to calculate difference between two dates & times in Excel.

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. Remember, standard ...

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

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 ...

How to Calculate the Total Hours Formula in Excel. As a spreadsheet software program, Microsoft Excel has many useful features for a small business's productivity.

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 ...

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.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...