98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training company borough high street london - Excel: filters and sorting
microsoft excel training company borough high street london - Excel: filters and sorting
Resolved · Low Priority · Version Standard
Havva has attended:
Excel Intermediate course
Excel Advanced course
Excel: filters and sorting
please tell me about filters and the sort buttons
RE: Excel
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
Training information:
- Microsoft excel training company borough high street london
- Excel-courses-london
- Microsoft Excel Training London
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create Charts with One keystrokeCreate a graph with one click |