Using NPV in Excel - Excel tutorial

Category: Excel tutorials > Functions - Difficulty:

Two methods to quickly and easily move information from row format into a column format, or a column into a row.

The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan). This is the PMT function that was used for the car purchase in the first example. There are a few things that we must know in order for this function to work.

Charts float above your data, locked inside special box-like containers. To take advantage of these chart boxes, you need to understand a little more about how they work.

Date and Time Functions

In this tutorial you will be able to learn how to incorporate a drop down menu into a pay form.