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