How to Set Up Auto Calculate in Excel 2010. When you edit the values on your Microsoft Excel worksheet, pressing the "F9" button refreshes the calculation manually. To avoid the tedious task of ...

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.

Learn how to approximate the effective convexity of bonds using Microsoft Excel with a modified and simpler version of the standard convexity formula.

It is difficult to calculate these values manually and while calculators make it easier, Excel is the preferred tool for finding these values over a range of cells.

How to Calculate Percentage in Excel As an adult, it might get frustrating working with percentages in the workplace setting because doing everything manually might not be as effective.

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with 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.

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row.

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

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

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.