Timeline Slicers

Last night's tip explained how to apply slicers to multiple pivot tables on an Excel worksheet. It's also possible to use slicers on Pivot tables to apply timelines on pivot tables which include a date field. You can slide a date range back and forth to change the data calculated in the pivot table.

Begin simply by selecting any cell in a pivot table. In the PivotTable Tools menu, select Analyze. Next to Insert Slicer, click on Insert Timeline. You will be prompted to select any date fields in the table.

A sliding scale will appear that you can move in increments of years, quarters, months, or days.