Chapter 13. Working with Data

[ LiB ]

Chapter 13. Working with Data

Excel can store data that can be used in logical conditions such as sorting or filtering to locate specific pieces of information. This is called a database, and each row of related information is called a record. After you enter data into a worksheet, you may find it easier to locate particular pieces of information if the data were sorted. You can also create filters that specify to display only the data that meets certain criteria, and if you want, you can also stipulate that any data that meets the certain criteria be formatted in a specified pattern.

In this chapter, you'll learn how to:

• Sort data by rows and columns

• Filter your data for specific data

• Work with data subtotals

• Apply conditional formatting

[ LiB ]