Excel – Filter a PivotTable with a Timeline

nnn

Microsoft Excel Tips and Tricks

nExcel 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.nnnn

Credit Chris Menard

n

Leave a Reply

Your email address will not be published. Required fields are marked *