Look Who it Was Random video

Excel - First Look at the Improved Filters that Debuted in Excel 2007 - Episode 572

489 views · Published 29 June 2009 · 2:20 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: First Look at the Improved Filters that Debuted in Excel 2007.
Welcome back to the MrExcel Netcast! In today's video, we're going to take a look at the improvements that Microsoft has made to Excel 2007, specifically in regards to filters. If you've been using Excel for a while, you may remember the custom auto filters in Excel 2003. Well, in Excel 2007, they've been renamed to simply "filters" and they come with some great new features.

To access the filters in Excel 2007, simply choose a cell and click on the filter icon on the data tab of the ribbon. Just like in Excel 2003, you'll see the dropdowns at the top. However, one major improvement is the ability to select multiple items at once. This means you can easily filter for more than just one item, making your data analysis even more efficient.

Another great addition to the filters in Excel 2007 is the special filters for dates. You can now filter for specific time periods such as today, yesterday, last week, last month, and more. And if you're working with a large amount of data, you'll appreciate that the date fields are automatically grouped by month, making it easier to analyze your data.

But perhaps the most exciting new feature in Excel 2007 filters is the ability to filter by color. This means you can easily filter for cells that are a specific color, making it even easier to analyze and organize your data. So whether you're using Excel 2007 or planning to upgrade in the future, you can look forward to these fantastic new filter features.

Thanks for tuning in to today's netcast from MrExcel. We hope you found this video helpful and informative. Don't forget to subscribe to our channel for more Excel tips and tricks. 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/

Table of Contents:
(00:00) Introduction to Excel 2007 Filter Feature 
(00:24) Renaming of Auto Filter to Filter 
(00:37) Selecting Multiple Items 
(00:57) Special Filters for Text and Date Fields 
(01:10) Automatic Grouping of Date Fields 
(01:20) Formatting Date Fields 
(01:30) New Filter by Color Feature 
(01:40) Summary of Excel 2007 Filter Improvements 
(01:55) 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:
Date filters in Excel 2007
Differences between Excel 2003 and Excel 2007 auto filter
Excel 2007 auto filter
Excel 2007 filter feature
Filter by color in Excel 2007
Formatting date fields in Excel 2007
Grouping date fields in Excel 2007
New features in Excel 2010 or Excel 2014
Selecting multiple items in Excel 2007
Special filters in Excel 2007
Upgrading to Excel 2010 or Excel 2014

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



Excel 2007 adds some amazing new features to the Excel 2003 AutoFilter technology. Learn how you can filter to multiple items, by month or by color. Episode 572 shows you how.

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

More from this channel