In order to create a calculator that can accurately price an option, including market volatility and changing market prices for financial instruments, you'll need to download an Excel add-on.

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

Learn how to calculate the cost of equity in Microsoft Excel using the capital asset pricing model, or CAPM, including brief definitions of each component.

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

How to make a conditional running total in Excel At this point, you’ve not really gained much; the PivotTable isn’t really any better than the Table and its simple expressions.