Under Data Menu MS Excel 2003, you can sort the data in your file in sequence. And can filter and subtotal.
Sort – Data Menu MS Excel
This option is use data menu MS Excel to bring any data in sequence. For example, in the company, shop, school, etc., the book “Register” of its employee or buyer is prepare. In that name, date, salary etc can be done in a sequence with the help of this option.
On clicking this option, its dialog box will appear. In which the following method has been adopt to use the present option.
Method- First of all, enter your sheet of record present in the following table. After this, select the name from the drop down list of Sort by in the short dialog box and click OK.
All names will be in a sequence. And if you want that all the names that are similar, then all the names should be in a sequence according to the month.
So to do this, from the Sort dialog box, then by selecting Month from the drop-down list and then OK. All names will be sort by month.
Filter – Data Menu MS Excel
With the help of this option, any row can be sort according to the desire in the create record. There are three options under this. which are give below.
1- Auto Filter :- With its help, you can easily sort any row from the record as per your wish. To do this, first select any cell from your record. And click on this option.
2- Show All :- With the help of this option, all the records can be display.
Note- This option will be activate when you have select some rows from the record. It is just like all option.
3- Advance Filter: – With the help of this option, you can sort any record you want from the created record. The specialty of this option is that with the help of this option, along with sorting the record, if you want to prepare a copy of it, you can do it.
Form – Data Menu MS Excel
With the help of this option, a new record can be enter in the record create. On clicking on it, its dialog box will appear. All the headings of the record will be present and a box will appear in front of each heading.
In which you write the record related to that heading and by pressing the tab button, move the cursor to another box. And there also write related records in it. When you have finished writing the entire record, press the Enter button.
Subtotal – Data Menu MS Excel
With the help of this option in Data Menu MS Excel, all the totals are remove.
Method- First of all prepare a record according to this map. After that select the entire record and click on Subtotal option. A dialog box named Sub Total will appear. Select the number of cells you want to total.
With the help of this option, only a fixe number can be written in any select range. That is, the selected range will not accept anything else. Like we want it to not accept more than 500 and less than 3000 in the selected range. So for this use this option. As shown in the following dialog box.
Table – Data Menu MS Excel
With the help of this option, the result of the formula use in the select column or row can be obtaine in the form of a table.
Text to Columns
With the help of this option, text written in more than one cell can be divide into different columns.
Consolidate Data Menu MS Excel
With the help of this option, we use to copy the data written in another file or open sheet to another place.
Group and Outline
With the help of this option in Data Menu MS Excel, you can create a group of any selected column or row. So that whenever you want to hide this column or row, you can hide it. If you want to show, you can show it.
Pivot Table and Chart
With the help of this option in Data Menu MS Excel, you can create Pivot table and Pivot chart.
Import External Data – Data Menu MS Excel
There are many options under it. With the help of which you can bring data from any other place. And you can also change it.
Refresh Data – Data Menu MS Excel
With the help of the above option, when you bring any data in your file, then this option will be activate. Now on click this option, a dialog box named Import will appear. With the help of which you can fetch data.