Cell References - These are the cells that hold the values that are used to complete the function. Example A2, D5, F8, etc. Arithmetic Operator - This is the operator used to calculate the function.

Microsoft Excel has dozens of preset formulas for many types of mathematical calculations, but compounding interest isn't one of them. To calculate the future value of a single amount compounded ...

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.

4] Calculating Interest Compounded Monthly in Excel To calculate the interest compounded monthly, change the value of the B4 cell to 12 and use the same formula.

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

Example Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My payroll calculator ...

Find out more about the price-to-earnings, or P/E, ratio, the P/E ratio formula and how to calculate the P/E ratio in Microsoft Excel.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.