Excel

Calculate NPV in Excel

How to calculate NPV in Excel using Functions

In the last two posts, you learnt the basics of Net Present Value (NPV) and how to calculate NPV using formulae. However, Microsoft Excel makes… Read More »How to calculate NPV in Excel using Functions

Advertisements

Goal Seek in Microsoft Excel

Continuing with our Excel Tutorials, in this article, I’ll take you through using Goal Seek in Microsoft Excel 2007. The function is same as that of earlier versions of Excel as well as Excel 2010. The screenshots below are taken in 2007.

MEDIAN IF example

MEDIAN IF tutorial in Excel 2007 and Excel 2010

Excel 2007 brought a host of new functions to Excel that were missing in Excel 2003. One of these functions was AVERAGEIF which returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. One essential function that is still missing is MEDIANIF or MEDIAN IF which should ideally return the median of all the cells in a range that meet a given criteria.