This will be one value for your two-stock portfolio, and we can call it C12. Use the CORREL function in Excel to calculate this value, applied to the two series of daily values for the two stocks.

In Excel, the formula used to calculate a bond's modified duration is built into the MDURATION function. This function returns the modified Macaulay duration for a security, assuming the par value ...

Step 4: Another formula you can use to calculate percentage is simply applying the / key in between two cells. For example, to pass a driving theory test, I need to get 80% of the questions correct.

In Microsoft Excel, first, increase the widths of columns A, B, and C by highlighting the entire sheet. Click on the corner of the worksheet (to the left of column A and above the numeral 1 in row ...

In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory ...

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.

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.

Excel’s RANK.EQ () function returns the rank of a numerical value within a list of other numerical values and uses the following syntax: RANK.EQ (number, ref, [order]) ...

Everyone likes a bonus, but sometimes calculating one can be a bit complicated--at first. Here's how to calculate the amount in Microsoft Excel that you or your staff will get paid.

Enter a value in the field next to "Decimal Places" to indicate how many digits Excel should display after decimal points. For example, if you select "2," the value "100" becomes "100.00." ...

On of the most common uses of Excel is to calculate values. For example, if you're keeping track of inventory of your office supplies, you add up the total amount of each item by adding the cells ...

Thanks -- and Fool on! 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 .