Learn Excel from Bill Jelen with this daily 2 minute video podcast.

## Friday, September 18, 2009

### 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!

Labels: , ,

## Friday, August 28, 2009

### Duel: Multiple Wildcards - 1090 - Learn Excel from MrExcel Podcast

In today's dueling Excel podcast, the question is how to delete all the records which contain either ski or swim. This requires multiple wildcards in a filter. Mike and Bill will compare various methods in Episode 1090 .

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!

Labels: , , , ,

## Thursday, July 16, 2009

### Pivot Sorting - 1059 - Learn Excel from MrExcel

Lisa from Chicago sends in today's question. Why can't you sort the page field in a pivot table? Episode 1059 talks about several ways to sort the row fields in a pivot table and then a method for sorting the filter field.

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!

Labels: , ,

## Thursday, June 25, 2009

### Multi-Column Find - 1044 - Learn Excel from MrExcel Podcast

Isabel asks how to use Ctrl+F to find a row where three criteria are true. Rather than use Ctrl+F, Episode 1044 suggests using a Filter.

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!

Labels:

## Monday, May 04, 2009

### MrExcel's Learn Excel #1006 - Only .edu?

Ileane asks how to get only the .edu e-mail addresses from a database of 20,000 e-mails. Episode 1006 shows you how to use advanced filter with a criteria range to solve this problem.

This video is the 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!

Labels:

## Friday, May 01, 2009

### MrExcel's Learn Excel #1005 - Dueling: Top 5 For a Golfer

Another Dueling podcast: How to filter to the top 5 golf scores for one golfer? The AutoFilter won't let you do it. But Mike and Bill show you how in Episode 1005.

This video is the 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!

Labels:

## Tuesday, April 28, 2009

### MrExcel's Learn Excel #1002 - Multiple VLOOKUP

Peter asks how to return multiple records from a VLOOKUP. In Episode 1002, I will show you how to use an Advanced Filter to achieve this result.

This video is the 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!

Labels: ,

## Monday, March 30, 2009

### MrExcel's Learn Excel #981 - Paste Skip Blanks

Gary sends in a clever solution for Episode 977 which uses the Skip Blanks option of the Paste Special dialog. Watch for how Gary can "reverse" the filtered and hidden rows during the steps shown in Episode 981.

This video is the 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!

Labels: ,

## Tuesday, March 24, 2009

### MrExcel's Learn Excel #977 - Filtered Paste

Joe asks if there is any way to do a Filtered Paste operation. I can't figure it out, so I had to resort to a macro. Check out Episode 977 and see if you have a better way.

This video is the 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!

## Monday, February 09, 2009

### MrExcel's Learn Excel #946 - Countif Filtered

Loh from Malaysia sends in a very hard question. How can you use COUNTIF to analyze only the visible rows from a filtered data set? I knew the solution would have to involve iterating through multiple SUBTOTAL functions, but Aladin from the MrExcel Message board provides the solution. Episode 946 shows you how.

This video is the 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!

Labels: ,

## Friday, December 05, 2008

### 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!

Labels: , ,

## Monday, September 22, 2008

### Episode 851 - Filter by Selection II

Wiebe points out a better solution for Episode #838 - Excel already has an icon for Filter by Selection. It is hard to find and poorly labeled, but it is in there. Episode 851 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!

Labels:

## Monday, August 04, 2008

### Episode 816 - Total Red Cells

Say that you need to add up all of the red cells. This is easier in Excel 2007 using Filter by Color. Episode 816 will show you how to do this in Excel 2007 as well as a clever trick using find by format to do the same thing in Excel 2003.

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!

Labels: ,

## Wednesday, July 02, 2008

### Episode 793 - Pivot Filter Hack

Normally, you can not use AutoFilter within a pivot table. Today, Dan from Philly shares an amazing hack that allows you to filter the results of the pivot table. Episode 793 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!

Labels: ,

## Tuesday, January 23, 2007

### 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!

Labels: ,