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 Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

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.

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

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.

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.