I, table design to deal with the first

First of all, to a worksheet of their own design. Table head of the table settings, must be based on the parent department of the database based on careful analysis. If that is the traditional DBF database, of course, can be carried out directly in EXCEL-related operations; ACCESS database if it is, after appropriate processing, we can operate it in EXCEL2000. It is not, then one by one to record the entry of the data item, a table of their own design can be the first. Table with the first characters indicate the best, so that entry can be avoided where necessary, appropriate adjustments and then click on the list.

Second, "to find, replace" and "automatic correction" Using function

Then analyze the data: in the "graduate school" column, there are good number of students graduated from the same school, certainly not to re-type high efficiency. Yes, with the first few characters to their own definition of a temporary substitute the name of some schools (such as "4Z" representative "city of the fourth secondary Zaoyang", such as completed by then "Ctrl + H" to all " 4Z "Replace All" Zaoyang city of the fourth secondary school "is not on the list?

[Hint: try to remember some simple, easy-entry, the content will not be confused with other characters to perform the replacement, but do not patronize a simple easy to remember, otherwise, you use "4" instead of "city of the fourth secondary Zaoyang" Try doing a "Replace All"Do not abuse people can yo! ]

Even if you Ctrl + H would like to omit this step, you can try EXCEL's "AutoCorrect" feature. The use of automatic correction function can be simplified a large number of repeat users of the data input operation, for example, can be above the "4z" corrected the definition of "the fourth secondary Zaoyang City", the definition is:

1. From the Tools menu, select "AutoCorrect", open the AutoCorrect dialog box.

2. In the "Replace" box, enter data, such as: "4z", in the "Replace" box, enter data, such as: "Zaoyang city of the fourth secondary school", click "Add", then click "OK" .

After, simply enter the cell "4z" word, that is automatically corrected to "the fourth secondary Zaoyang City."