How to use the FILTER function in Excel If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you need.