Excel: Slicers – Pivot table

Excel: Slicers – Pivot table


Excel: Slicers – YOUR OBJECTIVE
You created a pivot table and now want to filter it using a variety of criteria. Until now you’ve used report filters to do this. A disadvantage of report filters is that it is not always easy to recognize which items have been filtered, especially when multiple filters have been applied. Excel now offers Slicers that give you the capability of filtering pivot tables quickly and dynamically, but above all in such a fashion that you can immmediately recognize the current filtering state. [Read more...]

Using the excel Top 10 Filter

Using the excel Top 10 Filter

YOUR OBJECTIVE

You created an Excel table which lists your customers’ orders. You would now like to find out which five orders had the highest dollar value. You can use Excel ‘s Top 10 Filter function, a capability within AutoFilter, to display just those orders.In this learning module, you will be shown how to use the excel Top 10 AutoFilter, in Excel 2010.

[Read more...]