Look Who it Was Random video

Excel - Ctrl+T Tables Debut - Automatic Filters and More - Episode 428

534 views · Published 24 September 2009 · 3:33 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Advantages of Ctrl+T tables in Excel.

Welcome back to the MrExcel netcast, where we bring you the latest tips and tricks for mastering Excel. I'm Bill Jelen and today we're diving into the world of table filters. With just seven days left until the release of Excel 2007, we're excited to show you some of the new features that will revolutionize the way you work with data.

One of the first things you'll notice when working with tables in Excel 2007 is the new functionality that allows your headings to change as you scroll through the table. This feature is only available when using table headings and will disappear once your cursor moves outside of the table. While this may not replace the need for Freeze Panes, it's a useful tool to have when working with large tables.

But the real game-changer is the enhanced AutoFilter dropdowns. Not only can you now select multiple values to filter by, but there are also new virtual filters for dates and numeric values. For example, you can now easily filter for records from a specific month or those with sales above or below a certain amount. This improved functionality makes it easier than ever to analyze and manipulate your data.

And for those who prefer the traditional spreadsheet format, don't worry - you can easily convert your table back to a regular range by selecting the "Convert to Range" option in the Table Tools, Design ribbon. This will remove the table formatting and convert all formulas back to their original form. So whether you're a fan of tables or not, Excel 2007 has something for everyone.

With just one week left until the release of Excel 2007, we hope you're as excited as we are about the new features and improvements. Stay tuned for more tips and tricks from MrExcel, and don't forget to grab your copy of Excel 2007 on January 30th. Thanks for watching and we'll see you in the next podcast!

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 MrExcel netcast with Bill Jelen
(00:17) Countdown to Excel 2007 release date
(00:27) Tricks for tables and AutoFilter dropdowns
(00:56) New functionality for tables with headings
(01:17) Interesting features in AutoFilter dropdowns
(02:30) Improved AutoFilter functionality in Excel 2007
(02:46) How to turn off table functionality
(03:09) 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:
AutoFilter dropdowns in Excel 2007
Converting table formulas to regular formulas
Custom filters in AutoFilter
Date filters in AutoFilter
Excel 2007 features
Excel 2007 release date
Freeze Panes in Excel
MrExcel netcast and podcast
Numeric filters in AutoFilter
Tables in Excel 2007
Turning off table functionality in Excel 2007
Using table headings in Excel 2007

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



Excel 2007 offers amazing new AutoFilter functionality. Instead of choosing a single customer from the dropdown, you can filter a dataset to show 3 or more customers, or use new virtual filters to show all records from next month or last year. Episode 428 shows you how.

This blog is the video netcast companion to the upcoming 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!

More from this channel