IN THIS CHAPTER
Setting up a data list
Adding data to a data list
Editing records in a data list
Finding records in a data list
Sorting records on values in a data list
Sorting a list on font color, fill color, or cell icons
Subtotaling data in a data list
In addition to its considerable computational capabilities, Excel is also very accomplished at maintaining vast collections of related data in what are referred to as database tables or, more often, data lists (which is a little more accurate). This chapter covers all the basic procedures for creating and then maintaining different types of data lists in the Excel worksheet.
This basic information includes how to design the basic data list and then format it as a table so that you can ...