Select Page

Lesson 8 demonstrates a cool new feature in Excel 2007, label filters. Label filters allow you to filter rows and columns based on the text of the label. Excel offers a variety of logical choices to filter with (Begins with, Doesn’t begin with, Ends with, Doesn’t end with, Contains, Doesn’t contain, etc.) Also notice what happens when you put date fields in a Pivot Table instead of text. Label filters turns into Date filters, and your filter options turn into a wide variety of date based choices (Before, After, Between, This week/month/quarter/year, Last week/month/quarter/year, Next week/month/quarter/year, Year to date, etc.) These filtering options make it very easy to keep Pivot Table filters current as the data refreshes.

Today we hit 800 times videos have been watched on the site. Thanks for watching!

I hope you enjoy the video. Happy Thanksgiving!