Chapter 6. Reordering and Summarizing Data
Chapter at a Glance
In this chapter, you will learn how to
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 ...