The Excel sort function and Excel filter function are highly useful when working with large amounts of data.
A Microsoft Excel spreadsheet can contain a great deal of information. With more rows and columns than previous versions, Excel 2007 gives you the ability to analyze and work with an enormous amount of data. To most effectively use this data, you may need to manipulate it in different ways.
In this lesson, you will learn how to sort, group, and filter data in various ways that will enable you to most effectively and efficiently use spreadsheets to locate and analyze information.