Chapter 6. Reordering and Summarizing Data

Chapter at a Glance

Reordering and Summarizing Data

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

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

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