A volatile function is a function that recalculates every time a change is made to an Excel worksheet, or whenever an existing workbook is reopened. Going one step further, when a volatile function is ...

Two common ways of calculating depreciation are the straight-line and double declining balance methods. Excel can accomplish both using the SLN function to calculate the straight line -- a ...

How to Calculate NPV in Excel Using XNPV Function . To calculate the NPV of an investment project, you must consider the present value of all cash receipts and all cash disbursements related to ...

Calculating correlation can be time-consuming but software like Excel makes it much easier. You can use several methods to calculate correlation in Excel. Understanding Correlation ...

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 .

The article Using Excel to Calculate Your Annual Salary With Increases originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

If you are using monthly periods, rather than annual periods, you may enter "=RATE(A2,A4,A3)*12" to calculate the annual interest rate. Advertisement Article continues below this ad ...