Chapter 1

Building and Maintaining Data Lists


check Setting up a data list

check Adding data to a data list

check Editing records in a data list

check Finding records in a data list

check Sorting records on values in a data list

check Sorting a list on font color, fill color, or cell icons

check 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 2019 All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.