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.

Find out more about the price-to-earnings, or P/E, ratio, the P/E ratio formula and how to calculate the P/E ratio in Microsoft Excel.

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 moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

We explain how to fix the issue when Excel is not auto-calculating formulas. Excel is an advanced tool when calculating formulas for statistics.

Find out more about working capital, what working capital is and what it measures, and how to calculate a company's working capital using Microsoft Excel.

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

How to Plot a Formula in Excel. Unless you are an accountant or a math whiz, the formulas used in financial calculations may seem like random, nonsensical strings of numbers, letters and Greek ...