Microsoft Office 2019 Step by Step, First Edition

8

Reorder and summarize data

In this chapter

• Sort worksheet data

• Sort data by using custom lists

• Organize data into levels

• Look up information in a worksheet

One of the most important uses of business information is to record when something happens. Whether you ship a package to a client or pay a supplier, tracking when you took those actions, and in what order, helps you analyze your performance. Sorting your information based on the values in one or more columns helps you discover useful trends, such as whether your sales are generally increasing or decreasing, whether you do more business on specific days of the week, or whether you sell products to lots of customers from certain regions of the world.

Microsoft Excel has capabilities you ...