Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

Automating the selection process isn't difficult if you rely on VBA's InputBox in Microsoft Excel.

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

How to Calculate Breakpoints in Excel. A price breakpoint is a discount you offer your customers based on the amount of units that they order. The breakpoint is the lower value of the range that ...

How to Calculate Fluctuations in Excel. Calculating data fluctuations-- also called variance -- is a multi-step process that requires total accuracy. Excel 2010 provides two basic formulas for ...

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 .