Chapter 6. Reordering and Summarizing Data

Chapter at a Glance

Reordering and Summarizing Data

In this chapter, you will learn how to

✓

Sorting Worksheet Data.

✓

Organizing Data into Levels.

✓

Looking Up Information in a Worksheet.

Most of the time, when you enter data in a Microsoft Excel worksheet, you will enter it in chronological order. For example, 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 you entered it, but that might not always be the best arrangement to answer your questions. For instance, you might want to sort your data so that the ...

Get Microsoft® Excel® 2010: Step by Step now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.