98.7% 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 » excel-training-course - Filter
excel-training-course - Filter
Resolved · Low Priority · Version Standard
Antonia has attended:
Excel Intermediate course
Filter
How to use advanced filter
Any suggestion on scenarios to use filtering
RE: filter
Hi Antonia
Thank you for your question, and apologies for the delay in response.
Filtering is used to be able to reduce down the amount of information that you can see from a list/table in Excel. If you are looking only for rows of data that contain specific information (criteria) from a certain column or columns, then you can apply a filter to temporarily remove from view any rows of data that don't contain the criteria you are looking for.
Most filtering can be done using the AutoFilter feature (Data - Filter - AutoFilter) where you use dropdown arrows at the tops of the columns to be able to select the criteria that you are looking for from a specific column or columns.
The advanced filter is used when you are looking for very specific criteria, that you would not be able to display using the AutoFilter. For example, if you were looking for three different criteria from one column - AutoFilter will only let you display two criteria from a column.
I hope this helps.
Amanda
Training information:
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:Number format shortcutCtrl+Shift+! applies the Number format, with two decimal places |