Wiley Excel 2010 All-in-One For Dummies 978-0-470-48959-8 Manuale Utente
Codici prodotto
978-0-470-48959-8
Chapter 1: Building and
Maintaining Data Lists
Maintaining Data Lists
In This Chapter
✓
Understanding what goes into making 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
I
n addition to its considerable computational abilities, Excel is also very
accomplished at maintaining vast collections of related data in what are
accomplished at maintaining vast collections of related data in what are
referred to as database tables or data lists (which is a little more accurate).
This chapter covers all the basic procedures for creating and then maintain-
ing different types of data lists in the Excel worksheet.
This chapter covers all the basic procedures for creating and then maintain-
ing 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 add new data to the list without having
to redefine it and can sort its data so that it’s arranged the way you like to
see the information. For data lists that contain numerical data, you also find
out how to subtotal and total the data. For information on how to find data
in the data list and produce subsets of the list with just the data you need,
refer to Book VI, Chapter 2.
format it as a table so that you can add new data to the list without having
to redefine it and can sort its data so that it’s arranged the way you like to
see the information. For data lists that contain numerical data, you also find
out how to subtotal and total the data. For information on how to find data
in the data list and produce subsets of the list with just the data you need,
refer to Book VI, Chapter 2.
Data List Basics
In Excel, a data list or database is a table of worksheet data that utilizes a
special structure. Unlike the other types of data tables that you might create
in an Excel spreadsheet, a data list uses only column headings (technically
known as field names) to identify the different kinds of items that the data
list tracks. Each column in the data list contains information for each item
you track in the database, such as the client’s company name or telephone
number (technically known as a field of the data list). Each row in the data
list contains complete information about each entity that you track in the
data list, such as ABC Corporation or National Industries (technically known
as a record of the data list).
special structure. Unlike the other types of data tables that you might create
in an Excel spreadsheet, a data list uses only column headings (technically
known as field names) to identify the different kinds of items that the data
list tracks. Each column in the data list contains information for each item
you track in the database, such as the client’s company name or telephone
number (technically known as a field of the data list). Each row in the data
list contains complete information about each entity that you track in the
data list, such as ABC Corporation or National Industries (technically known
as a record of the data list).
30_489598-bk06ch01.indd 571
30_489598-bk06ch01.indd 571
3/27/10 12:46 PM
3/27/10 12:46 PM
COPYRIGHTED MATERIAL