Improving the AutoFilter in Office 12

In class we've been getting to know both the autofilter and the advanced filter... one of the developers of Excel has just (as in two days ago) given us an example of how the Office12 Excel application will improve Autofilters.

From Autofilter Improvements: much more than just multi-select (sounds easy already ;-)):

Sorting and filtering are two of the most important types of basic analysis that you can do with data. In Excel 12, we have improved sort and filter functionality to better expose common tasks, to make key tasks simple, and to enable scenarios that were not possible in earlier versions. We have done work in AutoFilter, our sort functionality (Data|Sort), and in PivotTables. I will cover the first two (AutoFilter and Sort) in posts this week and PivotTables in a few weeks when I review all our PivotTable work. Today, I will focus on AutoFilter.

Read more...