microsoft excel training company borough high street london - Excel: filters and sorting

Hi Havva,

Hope you enjoyed your Excel Intermediate and Advanced training courses. I'm sure you'll get some good use out of this forum, too.

I'll start with sorting.

You can use the Sort Ascending or Sort Descending buttons to sort your data accordingly, whether it's numbers or text.

For a more advanced sort, select the data you want to sort, and choose Data -> Sort. This will bring a dialogue box with more sorting options.

Filtering is a quick and easy way to find and work with a subset of data in a list. A filtered list displays only the rows that meet the criteria you specify for a column. Excel provides two commands for filtering lists:
1) AutoFilter, which includes filter by selection, for simple criteria
2) Advanced Filter, for more complex criteria

Unlike sorting, filtering does not rearrange a list. Filtering temporarily hides rows you do not want displayed. Also, when Excel filters rows, you can edit, format, chart, and print your list subset without rearranging or moving it.

To apply a filter, go to Data -> Filter and follow the wizards or dialogue boxes.

And remember experimentation is sometimes the best way to learn!

Hope this helps.

Regards, Rich