excel初级教程（Excel初级教程）.docVIP

excel初级教程（Excel初级教程） Excel 2000 crash course The third part is management data list First, create data lists In Chinese Excel 2000, sorting and filtering data logging operations need to be done through a data list, so a list of data should be created before operation. List is a series of related data contains data rows to the table, such as the payroll, this electronic report contains data for this, it can be accepted as like database browsing and editing operations. The use of Chinese Visual FoxPro 6 were similar, only in the Chinese Excel 2000 can easily be used as a data list database, and in the implementation of database operations, such as query, sorting or summary data will automatically list data as database, and use the data elements to organize data column list: The column in the data list is the field in the database The column flag in the data list is the field name in the database Each row in the data list corresponds to a record in the database So what is the difference between a data list and an electronic report? In fact, there is no big difference. The first line of the former contains column headings, the latter is the database containing the data list, and there are also headings! So you can easily set up a data list. Such as payroll in the name, age, position and wages, which can be used as a column header data list, using the mouse to select a range of cells as shown in Figure 1, a list will be created. Figure 1 select the zone and establish a data list In fact, if a region is selected, Chinese Excel 2000 will automatically set up a data list when needed, but the list will contain all of the cells, automatically find the column header is not always correct. Note: only one data list can be established and used on each worksheet. You should also avoid setting up multiple data lists on a worksheet because some data list management functions, such as filtering, can only be used in one data list at a time. Once the data list is established, you can c