If you are using a list in Excel, a key skill to have is the ability to filter. Filtering allows you to extract records that meets certain criteria out of your list, so for example if you wanted to find all the transactions you had with a particular company between certain dates, a filter is an ideal tool for that. The filters in Excel 2007 and later are very user friendly and will vary depending on the data they contain..See the video below for how it works.
The video below
Click on the link to download a file you can use to practise with – filtering_in_excel