27.+How+to+Use+Excel's+Data+Manipulation+Features+by+Tom+Kleen

 =Manipulating data with Excel = Most people think of Excel as a number crunching program, but it has some powerful data manipulation features, too. We will look at four of Excel's data manipulation features:  Excel really shows its power when it is manipulating large quantities of data, so we will get a large data set to work with: the daily weather records for Storm Lake for the entire 20th century--36,525 rows of data. Then we will answer some [|questions about Storm Lake weather]
 *  Sorting
 *  Filtering
 *  Pivot Tables
 *  Pivot Charts