Protecting Excel 2007 Data - Excel tutorial

Category: Excel tutorials - Difficulty:

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.

In this tutorial you get a look into all the required basics. From easy basics of a spreadsheet to charts and graphs.

PivotTables are one of the wildest but most powerful features of Excel.
We use PivotTables a lot when we develop spreadsheets for our clients. Once a client sees a PivotTable, they nearly always ask whether they can create one themselves. Although anyone can create a PivotTable...

We often need to format the numbers to display the appropriate number of decimals, dollar signs, percentage, red (for negative dollars), etc. It is best to keep numbers describing similar items as uniform as possible.

With the Pivot data you can see the same information in different layouts with a few clicks.....