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

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

Calculating the seasonal index allows a business to uncover trends in sales in absolute terms. Microsoft's Excel spreadsheet application can do most of the work for you.

How to Calculate the Decline in Sales by Percent for the Number of Years in Excel. When calculating a declining sales figure spanning multiple years, you need to calculate two percentages.

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

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.

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.