Chapter 7. Reordering and Summarizing Data

Reordering and Summarizing Data

Chapter 7 at a Glance

In this chapter you will learn to:

✓ Sort a data list.

✓ Organize data into levels.

Most of the time, when you enter data in a Microsoft Excel worksheet, you will enter it in chronological order. For instance, you would probably enter hourly sales data in a worksheet at the end of each day, starting with the first hour your store was open and moving to closing time. 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 row in your worksheet ...

Get Microsoft® Office Excel® 2003 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.