From the course: Excel 2016 Essential Training

Unlock the full course today

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

Using slicers to clarify and manipulate fields

Using slicers to clarify and manipulate fields

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using slicers to clarify and manipulate fields

“

- As you're working with PivotTables, it certainly makes sense at times to see less information, so we've got filters in a variety of locations, and also a relatively new feature, introduced in Excel 2010 called Slicers. We're looking at a worksheet called Slicers in our workbook 14-PivotTables. Within the PivotTable Fields List, you'll see a section called Filters. It's going to be less important in the future because of this new feature called Slicers. Let's talk about how it works. First of all, let's bring in the Product field into the filters area. Now, as you keep your eye on the PivotTable to the left, look what happens above it. It's actually part of the PivotTable, but we haven't used it just yet. It's for Product. Let's click the drop arrow here. Maybe we only want to look at Bamboo Coffee Tables. Click there. Okay, that's all we're seeing. And we're reminded of that. We see that in the heading, and of course PivotTable gets wider at some points, but we're not seeing the…

Contents