Wiley 978-0-470-48959-8 Datasheet

Chapter 1: Building and Maintaining Data ListsIn This Chapter✓ Understanding what goes into making a data list✓ Adding data to a data list✓ Editing re

580Data List Basicsyou click the Find Next button or press Enter, which brings you to Sherry Caulfield’s record, as shown in Figure 1-5. Having locate

Book VIChapter 1Building and Maintaining Data Lists581Data List Basics ✦ Less than or equal to (<=): Finds records the same as the text charac-ters

582Data List BasicsEliminating records with duplicate fieldsYou can use Excel’s Eliminate Duplicates feature to quickly find and remove duplicate reco

Book VIChapter 1Building and Maintaining Data Lists583Sorting DataSorting DataYou can use the Sort & Filter Data command button on the Ribbon’s Ho

584Sorting DataSorting records on multiple fieldsWhen you need to sort a data list on more than one field, you use the Sort dialog box (shown in Figur

Book VIChapter 1Building and Maintaining Data Lists585Sorting DataTo sort records in a data list using the Sort dialog box, follow these steps: 1. Pos

586Sorting DataFigure 1-8 illustrates sorting the employee data list first in ascending order by location and then in descending order by salary. For

Book VIChapter 1Building and Maintaining Data Lists587Sorting DataFigure 1-9 shows you the Sort dialog box after defining these as the columns on five

588Sorting DataSorting the columns of a data listYou can use Excel’s column sorting capability to change the order of the fields in a data list withou

Book VIChapter 1Building and Maintaining Data Lists589Sorting Data You can’t sort data you’ve formally formatted as a data table in this manner until

572Data List BasicsAfter you’ve organized your data into a data list that follows this structure, you can then use a variety of commands on the Ribbon

590Sorting Data 10. Click the Format as Table command button on the Home tab (or press Alt+HT) and then click a table style from the Light, Medium, or

Book VIChapter 1Building and Maintaining Data Lists591Sorting DataSorting a data list on font and fill colors and cell iconsAlthough you normally sort

592Subtotaling DataWhen you finish defining all the levels for the sort, click OK to have Excel go ahead and sort the list’s records. You can sort th

Book VIChapter 1Building and Maintaining Data Lists593Subtotaling DataHere, I selected the Dept field as the field for which the subtotals are to be c

594Subtotaling DataAs you can see in Figure 1-14, when you use the Subtotals command, Excel outlines the data at the same time that it adds the rows w

Book VIChapter 1Building and Maintaining Data Lists573Data List Basics 2. Make the first entries in the appropriate columns of the row immedi-ately be

574Data List Basics Figure 1-1: Creating an employee data list with the row of field names and first data record. The original formula for calculating

Book VIChapter 1Building and Maintaining Data Lists575Data List Basics To avoid losing data or disturbing the layout of data located outside of the da

576Data List Basics If you’re adding the Form button to the Quick Access toolbar, you can simply click the Add button to add it to the end of the t

Book VIChapter 1Building and Maintaining Data Lists577Data List Basicsthis point). On the right side of the dialog box, the data form indicates the cu

578Data List BasicsNote that the data form does not allow you to select and edit calculated fields (such as the Years of Service field shown in Figure

Book VIChapter 1Building and Maintaining Data Lists579Data List BasicsFinding records with the data formYou can use the Criteria button in the data fo