Microsoft Excel Tips and TricksExcel 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