Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.

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

An alternative Excel averaging formula that doesn’t evaluate zero Your email has been sent Excel's AVERAGE() function evaluates zero values. If you want to exclude zeroes, use these alternatives ...

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

There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions.

Excel’s powerful formulas and functions are invaluable tools in your skill set if you would like to improve your spreadsheet productivity and data analysis. This comprehensive guide by Chandoo ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...