Look Who it Was Random video

Excel - Excel Auto Filter: Virtual Date Filters, Numeric Filters, & More! - Episode 440

548 views · Published 9 June 2009 · 2:48 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Excel Auto Filter: Virtual Date Filters, Numeric Filters, & More!

Welcome back to the MrExcel netcast! I'm Bill Jelen and in yesterday's netcast, Jim from Montreal called in with some complaints about the new Auto Filter in Excel 2007. But, to be fair, let me show you some of the great new features that Microsoft has added to the Auto Filter functionality in Excel 2007.

One of my favorite improvements is the new tree view for date filtering. In the past, when you selected the auto filter on a column with dates, you would just get a long list of all the dates. But now, with the tree view, you can easily navigate through different years and months to find the specific range of dates you're looking for. This makes filtering by dates much more efficient and user-friendly.

But that's not all! Excel 2007 also introduces virtual filters, which are a game-changer for text and numeric filtering. With virtual filters, you can quickly filter by specific ranges or categories, such as records from this week, last month, or the top 10 values. These new filters are similar to the ones used in QuickBooks, making it easier for users to adapt to them.

And for those of you who handle large amounts of data, the new numeric filters are a lifesaver. You can now filter by values that are greater than, between, or even the top 10 values. This is a huge improvement from the previous version of Excel and makes the advanced filter feature almost obsolete.

Thanks for tuning in to another netcast from MrExcel! I hope you found these tips helpful and stay tuned for more Excel tips and tricks in our future netcasts. Don't forget to like, comment, and subscribe for more Excel content. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Excel 2007 does offer a number of improvements in the AutoFilter arena. Episode 440 shows the new virtual date filters, such as selecting records from this week, next month, or last quarter.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Table of Contents:
(00:00) Introduction
(00:20) New Features in Excel 2007 Auto Filter
(00:33) Virtual Filters
(01:05) Clearing and Reapplying Filters
(01:15) Virtual Date Filters
(01:29) Other Virtual Filters
(01:39) Improved Text Filtering
(01:49) Numeric Filters
(02:15) Advanced Filter Comparison
(02:25) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Advanced filter in Excel
Excel 2007 Auto Filter
Excel 2007 improvements in Auto Filter
Filtering dates in Excel 2007
Greater than filter in Auto Filter
Microsoft Auto Filter functionality
MrExcel netcast
Numeric filters in Auto Filter
Text filters in Auto Filter
Top 10 filter in Auto Filter
Tree view in Auto Filter
Virtual date filters in Excel 2007

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152450/

More from this channel