Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

You can use the DATEDIF function or the NETWORKDAYS function to calculate date duration in Excel. The DATEDIF function calculates the difference between two dates in calendar units (days ...

Use the CORREL function in Excel to calculate this value, applied to the two series of daily values for the two stocks. The portfolio variance formula is: (W1^2)(SD1^2)+(W2^2)(SD2^2)+(2xW1xW2xC12).

The sum of the years’ digits method uses the function SYD to calculate a fraction: (years left of useful life) ÷ (sum of useful life). Excel can also calculate the declining balance method (DB ...

Nick David / Getty Images There is no specific formula in Excel or other spreadsheet applications that will calculate a company's weighted average cost of capital (WACC) for you. Instead ...