Admittedly, the ”normal” filter offers you lots of possibilities to select your data and to filter data according to the required criteria, but if, for example, you not only want to filter data at the same point, but to copy these to a particular sheet directly after filtering, you will not get very far with the ”normal” filter. In this video you'll learn how to use a special filter in Excel 2010.