Excel – Filter a PivotTable with a Timeline

Microsoft Excel Tips and Tricks

Excel filters are great. So are Excel PivotTables. They are two of the most popular Excel features. Did you know you can filter date fields in a PivotTable with a Timeline? The Timeline shows Years, Quarters, Months, and Days. Timelines are an easy way to change your data which is a date field and see what criteria you are using.

Credit Chris Menard

Please support our Sponsors here :