98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training - Advance Filtering Dates on Excel
excel+training - Advance Filtering Dates on Excel
Resolved · Low Priority · Version Standard
Thu 13 Dec 2007, 17:17Delegate Angelie said...
Angelie has attended:
Excel Advanced course
Excel Intermediate course
Advance Filtering Dates on Excel
How can you filter dates by year?
Mon 17 Dec 2007, 11:33Trainer Rajeev said...
RE: Advance Filtering Dates on Excel
Dear Angelie
Thank for joining the Intermediate and Advanced training with us!!
The quickest and easiest way of filtering is by using the Auto filter feature!!
Ensure that you are anywhere inside the list of data that you have and also please remove any unnecessary blank rows and columns from you list of data.
Choose Data from the Menu Bar
Choose Filter and then Auto filter
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:Difference between Two DatesThe DATEDIF function computes the difference between two dates. The DATEDIF function is as follows: |
