Chapter 7. Reordering and Summarizing Data

Chapter at a Glance

Reordering and Summarizing Data

In this chapter, you will learn to:

Sort a data list.

Organize data into levels.

Look up information in a data list.

Most of the time, when you enter data in a Microsoft® Office Excel® 2007 worksheet, you will enter it in chronological order. For instance, you could enter hourly shipment data in a worksheet, starting with the first hour of the day and ending with the last hour. The data would naturally be displayed in the order in which you entered it, but that might not always be the best order to answer your questions. For instance, you might want to sort your data so that the top ...

Get Microsoft® Office Excel® 2007 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.