Chapter 1: Building and Maintaining Data Lists

In This Chapter

arrow.png Setting up a data list

arrow.png Adding data to a data list

arrow.png Editing records in a data list

arrow.png Finding records in a data list

arrow.png Sorting records on values in a data list

arrow.png Sorting a list on font color, fill color, or cell icons

arrow.png 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 ...

Get Excel 2013 All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.