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.

The forward P/E ratio forecasts a company's earnings for a period. Published data can be used to calculate forward P/E in Excel. Excel can help you quickly compare multiple companies.

Learn how to use Microsoft Excel to calculate the Sharpe ratio, an investing tool used to assess the relationship between risk and return for an asset.

The forward P/E ratio measures the relationship of the current stock price to the forecasted EPS figures. Here's how to calculate a company's forward P/E ratio for the next period using Microsoft ...