Saturday 16 February 2013

Excel Filter: How to filter data according to dates

Excel date filter options
Filter options
Today I will demonstrate Excel's powerful capabilities to filter date columns. You have many options for selecting which time period to show or not to show.

In following video I will show how to select time period
  • by selecting start date and end date
  • by selecting "Last Year" from the menu
  • by selecting any year

Tip: If you have difficulties to see the video, try to maximise it from lower right corner:


No comments:

Post a Comment