Harnessing special date filters


show more Harnessing special date filters provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Harnessing special date filters

In this worksheet called ApplianceSales, there are about 900 records and it covers data over a two-year period. And let's imagine that our filtering needs revolve around Column E, what's happening in the Date column. Let's apply the filter by going to the Data tab, clicking Filter. If you have worked with date filtering in the past, it's been one of the more cumbersome capabilities of Excel in the filter arena and very often in prior versions you needed to go into the so- called Advanced Filter to get these done.

I am going to click the drop arrow here and you will of course see date filters, just as we might have seen numeric filters or text filters, but huge expansions here. And imagine, perhaps thinking of your data, how you might use some of these filters to narrow down the data from certain months or weeks or quarters, and don't overlook the second to last choice here. All Dates in the Period. Now, I remember distinctly how in prior versions if you wanted to get da...

Harnessing special date filters
Video duration: 2m 5s 1h 32m Appropriate for all

Viewers:

Harnessing special date filters provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...