It is difficult to calculate these values manually and while calculators make it easier, Excel is the preferred tool for finding these values over a range of cells.

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

Net present value (NPV) is used to estimate the profitability of projects or investments. You can calculate NPV in two ways using Microsoft Excel.

Formula of Mean: Know to How to Calculate Median for Grouped, Ungrouped data along with solved examples, questions with solution.

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.