Consolidate Data {Tutorial for beginners} - Excel tutorial

Category: Excel tutorials > Basics - 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.

The concept of "protection" gets a lot of attention in the Excel newsgroups and forums. It seems that many users want to learn how to protect their workbooks from being copied or modified. Excel has several protectionrelated features.

Data Analysis With Charts

A shortcut which allows you to show either the results in all cells or the underlying formula in the cells

The common error values that could appear when creating a formula are described below: