Pivot Tables are covered in detail on our Advanced Excel Training course. However, for some basic pivot table tips, read How to Create a Pivot Table and How to Change the Function of a Pivot Table. If pivot tables are a bit advanced for you and you’re looking to start afresh then our beginners Excel Training might be perfect for you. Click the link to read the full course description.
Pivot Table Slicers Tutorial
In a Pivot Table you can apply filters to your data, using the report filter and by filtering within the row or column fields. When using the multiple items in a report filter it is not obvious which criteria you have specified and likewise with the row and column filters.
So what can you do? The answer is to use Slicers in Excel 2010 and this is how to do it: Read the rest of “Excel 2010 Tutorial – Pivot Table Slicers”