Slicers and timelines sound complex and tend to impress people way more than they should. The thing is, a slicer is just a basic filter dressed up to look fancy, and a timeline is just a slicer designed to work with dates. In this tip, you can practice inserting slicers and timelines, linking them to multiple pivots, and creating a user-friendly way to interact with an Olympic athlete data set.
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. …
Note: The instructor uses Office 365 ProPlus. Some features may not be available in all versions of Excel.
- Customizing a PivotTable field list
- Grouping dates and values
- Enabling multiple filters
- Conditional formatting
- Refreshing source data
- Adding custom sort lists