From the course: Excel: PivotTable Tips

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Configuring slicers and timelines

Configuring slicers and timelines - Microsoft Excel Tutorial

From the course: Excel: PivotTable Tips

Start my 1-month free trial Buy for my team

Configuring slicers and timelines

“

and talk about one of my favorite PivotTable features, adding visual filters with slicers and timelines. Now, they sound like very fancy, complex tools, but they're actually quite simple. Slicers are basically just interactive versions of a filter, and Timelines are just slicers that work with dates. So, it's as simple as that. Inserting these are very simple as well. or if you're looking at a date-specific field, Add as Timeline. And when you add that slicer in, it will create a new workbook object containing a list of possible user selections and those selections will dynamically tie back and filter the PivotTable itself, just like a regular filter in a dropdown cell. Now, by default, Slicers will only interact with the PivotTable from which they were created. But that said, if you have multiple PivotTables generated from the same source data, you can use your Report Connection options from your Slicer Tools menu to essentially tie a single slicer to multiple PivotTables. And in the…

Contents