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!

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!

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!