Pivot Data:
Generally the data is entered in the worksheet as and when created. However, for better decision making, data has to be summarized in tubular report form.
Pivot table can be used as a tool for summarizing and analyzing the data records in an interactive manner. It summarises the data by using mathmetical functions such as sum, average, product, max, min etc. Pivot table does not contain any formula but contains only the result of the formula.

Adding Record With Data Forms
To add new records to a list, using the data forms, the steps are:
1. Select a cell list.
2. Select the form option from the data menu.
# To add a new record to the list , select the new button. The data form displays blank text boxes for all of the fields.
# Enter the appropriate data in each text box on the form for a new record.
# Press the enter key to add a new record to a list (The data form display blank fields for the next new record.
# Select the close option to return to the worksheet.

Viewing Records
You can use the data forms to view records in a list. The steps to records are given below:
1. Place the cell pointer in a cell of your list.
2. Select the form option from the data menu.
The data form of the list get displayed on the screen.
At the left side of the form are labels of the fields in the list and the text boxes that show the entries for the records. At the right side of the form are buttons that help to perform specific operations in the list.

Deleting Record with Data Forms
To delete the records the steps are:
1. select the form option from the data menu (This opens up the data form for the current list.
2. Scroll to the record that you want to delete.
3. Click on the delete button. (A message box gets invoke which prompts you to confirm the delete)
4. Click on the ok button to delete the record from the list.

Finding Records With Data Form:
You can use data form to find particular records in a list. You can view only one record at a time when you use data form. To search for records, the steps are:
1. Select the form option from the data menu. (This opens the data form for the current list)
2. Click on the Criteria button.
3. Select a text box and enter the criteria that you want to search. For example, Amount =67888(refer Figure 5.5).
4. Select the Find Next button after you have entered the criteria. If no matches are found, Excel beeps. Select the Find Previous button if you want to search backwards in the list to find a match.
5. Select the close button to clear the dialog box.