Excel Filtering
One of the basic Excel requirements for anyone working with large amounts of data is the Excel filter. Excel has two main filtering types, which are described in the links below.
-
Excel Advanced Filter
The Excel Advanced Filter can be used to perform more complex filtering than the basic Excel Autofilter.
-
Excel AutoFilter (Basic Filter)
The basic Excel filter (also known as the Excel Autofilter) allows you to view specific rows in an Excel spreadsheet, while hiding the other rows in the worksheet.