From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using slicers to clarify and manipulate fields

Using slicers to clarify and manipulate fields - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Using slicers to clarify and manipulate fields

If you want greater control over a Pivot Table when you're making a presentation or when you're simply analyzing data, you need to know about Slicers. This is a relatively new feature in Pivot Tables introduced in Excel 2010. In this particular Pivot Table we're seeing Salespersons in the row labels area, Product in the column labels area. Now, suppose we want to see just some of the products. A standard way to make this choice is to click the drop arrow for Product and unselect the items we don't want to see. So maybe we don't want to see the two tables here and we're not seeing them and the totals are adjusted. Now, do we know which fields were not seeing? Well, if we just made the change, yes. But, we might be looking at the Pivot Table in later time. Do we know our product list that well? Do we know what's not being seen? So, one aspect of using these arrows is that we might at different times want to know not just what we are seeing but what we're not seeing. And maybe we want to…

Contents