Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

6. Reorder and summarize data

In this chapter

• Sort worksheet data

• Sort data by using custom lists

• Outline and subtotal data

One of the most important uses of business information is to keep a record of 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.

Excel includes capabilities you might expect to find only in ...