In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates.

Instead, you would use the percentage weight when calculating the average. By constructing an Excel spreadsheet, this calculation becomes a simple matter of data entry.

Have you ever found yourself wrestling with Excel formulas, trying to calculate moving averages or rolling totals, only to end up frustrated by the constant need for manual adjustments? You’re ...

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.