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

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.