ABSTRACT
Excel can store both data and instructions about what the computer is to do with that data. To be of practical use, the data must be stored in a systematic fashion. In database parlance the column is referred to as a field and the row as a record. The first row of the sheet should be used to designate the name of the field, as this will be important later. Users use Sort and Filter commands to perform more complex searches. Basic data entry from sales etc is initially a matter of considerable spadework, but once done users can rapidly access any information with the Sort facility. To finding a particular property knowing its reference number is of course a simple matter if users use the Menu Edit Find command and enter the number. By filtering users can effectively hide all records except those which the users are interested in, and for this purpose users have several alternatives.
