Filter		Advanced Filter		Pivot Table		Group and Outline		Data Validation		Name Manager
Goal Seek		Freeze Panes		Split Screen		Conditional Formatting		Text to Columns

Creating Pivot tables

Use Insert-> Pivot table
We use Pivot Table to create a view that helps us summarize and analyze the data records
Pivot table summary can be placed on
different range in the same worksheet     or another worksheet
To use worksheet data as the data source, click a cell in the range of cells that contains the data.
The Data Range should not have any blank Rows or Blank Columns or Blank header names By default, non numeric fields are added to the Row Labels and Column labels area and page areas, numeric fields are added to the Values area
Drag and Drop the fields to be specified areas ( Page Section, Column Labels, Row Labels, Data Area) Data Area should have a numeric function associated with it. (Sum , Count , Average , Max , Min)
You may remove using the same method, just drag and drop the field out of the pivot area

In The Layout section you can re-align the areas and field names as required

Except the Data Area... Page Section , Column Labels , Row labels have filter options

You can Sort the Data value
Refresh:Should there be any changes , we can have the pivot updated by using Refresh option on Pivot
Group:The Row label or Column lable can be grouped if they are a numeric or date function

The Data are can have Sum , Count , Average, Max or Min ( Any of the math functions), this is areason for updating the Data area with Numeric values

  Alt + D + P + [Enter] [Enter] [Enter]