Chapter 7. Reordering and Summarizing Data
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 ...