Microsoft Office Tutorials and References
In Depth Information
Sorting worksheet data
Excel also has a capability you might expect to find only in a database program—you can
enter a value in a cell and have Excel look in a named range to find a corresponding value.
For instance, you can have a two-column named range with one column displaying
customer identification numbers and the second column displaying the name of the company
assigned each number. When you use a VLOOKUP formula that references the named
range, colleagues using your workbook can enter a customer identification number in a cell
and have the name of the corresponding company appear in the cell that has the formula.
In this chapter, you’ll sort your data by using one or more criteria, calculate subtotals,
organize your data into levels, and look up information in a worksheet.
PRACTICE FILES To complete the exercises in this chapter, you need the practice files
contained in the Chapter06 practice file folder. For more information, see “Download
the practice files” in this topic’s Introduction.
Sorting worksheet data
Although Excel makes it easy to enter your business data and to manage it after you’ve
saved it in a worksheet, unsorted data will rarely answer every question you want to ask it.
For example, you might want to discover which of your services generates the most profits
or which service costs the most for you to provide. You can discover that information by
sorting your data.
When you sort data in a worksheet, you rearrange the worksheet rows based on the
contents of cells in a particular column or set of columns. For instance, you can sort a
worksheet to find your highest-revenue services.
You can sort a group of rows in a worksheet in a number of ways, but the first step is to
identify the column that will provide the values by which the rows should be sorted. In the
revenue example, you could find the highest revenue totals by sorting on the cells in the
Revenue column. First you would select the cells in the Revenue column and display the
 
Search JabSto ::




Custom Search