Excel Filter Tool

Excel has a range of filter tools to enable easy sorting of data.  Data can be filtered by the values in the data set or by the Colour of highlighted cells.

filter

Using the Countries and their associated Continents as an example we can filter the data based on the continent by highlighting the Continent cell and navigating to Filter function.

Excel filter

Excel filter 2

The various options can be utilised to locate any data that is required.  In the example above we are able to select just certain continents to display the data.

Excel filter 3