If you have reams of sales data to sort through or analyse, filtering data is a useful tool. You can, for example, use the filter tool to sort through columns of sales figures and display the top ten, or sort into ascending or descending order. There’s even a custom filter function. Here’s how to filter data in Microsoft Excel 2003…
1. Open Excel
2. Compile your data > Select data by highlighting it
3. Click on Data in the main toolbar
4. Click Autofilter
5. Go to your data > Click the drop down arrows, choose how you wish to sort your data and it will be sorted accordingly.