Page 141 - Ms Excel Note and Workbook
P. 141
MICROSOFT EXCEL NOTE AND WORKBOOK
To use advanced date filters:
Advanced date filters can be used to view information from a certain time period, such as last year,
next quarter, or between two dates. In this example, we'll use advanced date filters to view only
equipment that has been checked out between July 15 and August 15.
1. Select the Data tab, then click the Filter command. A drop-down arrow will appear in
the header cell for each column.
2. Click the drop-down arrow for the column you want to filter. In our example, we'll filter
column D to view only a certain range of dates.
3. The Filter menu will appear. Hover the mouse over Date Filters, then select the desired
date filter from the drop-down menu. In our example, we'll select Between to view
equipment that has been checked out between July 15 and August 15.
132 | P a g e
