Filtering is a very useful tool in Excel, by filtering data you can view the information in your document easier and faster.
All you need to do is click in the column you want to filter, then in the ‘Data’ tab click on the ‘Filter button’
Click on the arrow that appears in the heading of the column and un-check the box ‘Select All’
Here you can select the item you wish to view and then click ‘OK’
If you would like to learn more about Excel and how to make the most of its tools we can show you on one of our Excel courses