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.

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. Chief among these is the ability ...

Everyone likes a bonus, but sometimes calculating one can be a bit complicated--at first. Here's how to calculate the amount in Microsoft Excel that you or your staff will get paid.

Excel for the web supports all three ranking functions. If you’re unfamiliar with Excel’s three ranking functions, consider reading How to calculate rank in an Excel sheet.

But if not, you need to calculate a weighted average trade price, because a simple average of the prices won't be accurate. Keep reading to learn how to do both.