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 ...

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.

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.

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 calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

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

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

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

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

Understand the basics of the debt-to-equity ratio, how to interpret it as a measure of financial stability, and how to calculate it in Microsoft Excel.