Fill it with color to differentiate it from other cells. This is the simple way to calculate sporadic totals in Excel.

Calculate the standard deviation of the historical returns compared to the mean determined in Step 3. In Excel, this can be achieved by using the STDEV function.

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

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 .

How to Calculate a Model in Excel. Mathematical models are a way to attempt to predict the probable outcome of a complex situation. From climate, stock market and physics models, you can use ...

Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.