Excel 2010 Tutorial – Pivot Table Slicers

Written by | Published March 1, 2012

excel-tutorial-pivot-table-slicersPivot 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”

Posted in Blog Posts, Excel Tips, Excel Training, How To | Tagged , , , , , , , , , , , , | No comments yet

Excel Tutorial: How to Create a Pivot Table

Written by | Published November 15, 2011

Pivot tables are covered in full as part of Advanced Excel Training. If you would like learn the basics first we also offer Beginners Excel Training. Microsoft Excel is essential to any career using computers so make sure you have all the necessary skills to conquer spreadsheets.

Pivot tables allow you to quickly summarize and analyze large amounts of data in lists and tables–independent of the original data layout in your spreadsheet–by dragging and dropping columns to different rows, columns, or summary positions.

Creating A Pivot Table Step 1

Creating A Pivot Table Step 2Click on any cell in the list/database area

Select the INSERT Menu, PIVOTTABLE

Click on the PIVOT TABLE button Read the rest of “Excel Tutorial: How to Create a Pivot Table”

Posted in Blog Posts, Excel Tips, How To | Tagged , , , , | No comments yet