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.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis ...

Calculate Time Difference in Excel. It is tough to calculate the difference between two times in Excel. But with a little bit of trick applied, we can achieve the result we want.

Type the formula to calculate the number of double time hours worked that day in cell B5. For example, suppose state law requires you to pay workers double time if they work more than 10 hours per ...

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

To calculate someone's age in Excel, enter the formula =DATEDIF(A2,TODAY()," y"), where cell A2 contains the date they were born and "Today" is today's date. Press Enter, and Excel will output the ...

In Excel, rank is a value that represents the position of one value within a group of values. You’ll want to rank all kinds of data: student GPAs, sport statistics, product sales and so on.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

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.