Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1

274 Chapter 9 Work with Data and Excel Tables


You can translate the same word into another language by choosing one from the To list.

CLEAN UP Save the ServiceLevels workbook, and then close it.

Defining Excel Tables


With Excel, you’ve always been able to manage lists of data effectively, enabling you to
sort your worksheet data based on the values in one or more columns, limit the data
displayed by using criteria (for example, show only those routes with fewer than 100
stops), and create formulas that summarize the values in visible (that is, unfiltered) cells.
In Excel 2007, the Excel product team extended your ability to manage your data by
introducing Excel tables. Excel 2010 offers you the same capability.
Free download pdf