From the course: Excel 2016 for the Mac: Managing and Analyzing Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Date filters

Date filters - Microsoft Excel for Mac Tutorial

From the course: Excel 2016 for the Mac: Managing and Analyzing Data

Start my 1-month free trial

Date filters

“

- [Instructor] We're looking at a worksheet called Date Filter, in our chapter two file. And you can see pretty quickly that column G has higher dates in it. Now, we might want to use a filter on this. Excel once again, as you saw in the previous movie with regard to numeric data, Excel recognizes date type data. So if we click anywhere in this worksheet and activate Filter from the Data tab of the ribbon, Filter, click in the drop arrow, the filter arrow for column G, we see some choices here. First of all, by year, that could be handy at times. We can check and uncheck those. When we go to choose one, we see quite a few choices here, and an arrow at the bottom. So if this is historical data, in terms of the dates, and it is, we can see all the dates before a certain date. We could see yesterday's date, last week's date, if that were pertinent here, and sales data might be perhaps not here as much but Last Month, Last Quarter, Last Year. Lots of choices here, or Year To Date. So…

Contents