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.

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

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 use Excel’s RANK.AVG () function Figure D Figure D Word’s RANK.AVG () better accommodates duplicates. Figure E Figure E The average rank increase with every duplicate.

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.

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.