Filling Blanks Uh-Oh - 1146 - Learn Excel from MrExcel Podcast

Mark asks how to fill blanks in with the data from above. Now...if you've watched this podcast, you've seen the trick for this, but Mark's data has something preventing Go To Special Blanks from working! So - another way to go. Episode 1146 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

AutoFilter Some - 1136 - Learn Excel from MrExcel Podcast

Mary from Louisiana passes along a cool tip for applying AutoFilter dropdowns to a subset of your records. Episode 1136 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Duel: Earliest Matching 2 - 1104 - Learn Excel from MrExcel Podcast

In this Dueling Excel podcast, how to find the earliest date for records that match two criteria. Episode 1104 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 903 - Sorting AutoFilter

Beardless Rot wants to know how to sort filtered data so that the top 10 autofilter will show items high-to-low. Episode 903 will show you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 597 - Show All

After you’ve used an AutoFilter to see just a few records, how can you quickly show all records? Episode 597 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 572 - 2007 Filters

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!

Episode 571 - AutoFilter Doesn’t Contain

Joe asks about using custom autofilters with Excel. He can use a wildcard to find all of the cells that contain *abc*, but how about finding cells that do not contain “abc”? Episode 571 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 546 - Adding Headings

Today’s problem involves a complex data set with headings throughout the data. We want to add new columns to the dataset, but it is incredibly tedious to copy the new column headings throughout the report. Episode 546 shows you how to use a combination of AutoFilter, and Visible Cells Only to solve the problem.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 445 - Filter Copying

A question from Mike in Oklahoma City. Excel is supposed to copy only the visible rows in a dataset where AutoFilter is turned on. However, sometimes this does not work. Episode 445 shows the simple shortcut to make sure that you have only the visible rows.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 440 - Virtual AutoFilters

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!

Episode 439 - AutoFilter Woes

Jim from Montreal calls in wondering why the AutoFilter dropdowns changed radically in Excel 2007. Episode 439 takes a look at the old AutoFilter, and the new AutoFilter.

This blog is the video netcast companion to the books Learn Excel from MrExcel and Excel 2007 Miracle Made Easy. Download a new two minute video every workday to learn a tip for both versions of Excel!

Episode 428 - Table Filters

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!

Episode 418 - Table Formatting

Excel 2007 adds new table intelligence that you can use in probably 90% of your worksheets. In Episode 418, learn how table functionality can easily apply greenbar formatting, autofilters, and more.

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!