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.

None of the spaces here are required. As you can see in the screenshot below, the formula works without these spaces. You can access an Excel workbook and accompanying video below for combining a ...

Since each date is really just a number stored in Excel, to compute the midpoint of two dates you would use the same mathematical formulas you would use to calculate the midpoint of two numbers ...

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 .

4] Calculating Interest Compounded Monthly in Excel To calculate the interest compounded monthly, change the value of the B4 cell to 12 and use the same formula. That’s it.

Fortunately, Excel offers a built-in function, DATEDIF, which makes it easy to calculate elapsed calendar time.