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.

The interquartile mean is a measure of central tendency. While all values in a data set are used to calculate the mean, only the interquartile range -- the central portion of a data set -- is used ...

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

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 .