How to Make Excel Calculate Faster. Whenever you change something on a Microsoft Excel 2010 spreadsheet, the program will recalculate some of the cells in the worksheet, even some of those that ...

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

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 median function in Excel can be categorized as a statistical function. It can be entered as part of a formula in a cell of a worksheet. The syntax of the MEDIAN function is as follows: MEDIAN ...

After tackling the basic and formatting capabilities of Microsoft Excel, we come to formulas, which are an integral part of the worksheets, and without which an electronic spreadsheet wouldn't be ...

Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done.

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

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .