Microsoft Excel 2019 Step by Step, First Edition

6 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

Practice files

For this chapter, use the practice files from the Excel2019SBS\Ch06 folder. For practice file download instructions, see the introduction.

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 ...