Excel Filtering Tips Video

Excel Filtering Tips

This "Excel Filtering Tips" video requires the latest version of Adobe Flash Player.
Download Flash

Get Flash

Excel Filtering Tips -

Another Dueling podcast: How to filter to the top 5 golf scores for one golfer? The AutoFilter won't let you...

Excel Filtering Tips -

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.

Added:

12/12/08

Tags:

Excel Filtering Tips Excel Lesson excel spreadsheets Filtering Tips Microsoft Excel tutorial excel Excel dueling tips filter MrExcel spreadsheets tutorial

URL:

Embed: (More)

Comment on this Video

Your Name: Email (optional):

Are you human?

Comments
Add-ons
Links
Related
Transcript

Get it off your chest – be the first to comment on this video!

No text or picture Add-ons were added yet. How sad!

No Links were listed yet. Go ahead and share!

How to Use Excel 2010s New Features

- A preview of new features coming in Excel 2010: Episode 1066 shows you the Paste Options shortcuts in Excel 2010.

MrExcel's Learn Excel - Use Excel without the Mouse Day

Excel Lesson - Keyboard Shortcuts - Dave from San Francisco suggests you should use Excel without the mouse and challenges you to convert a formula to values in three keystrokes. Episode 958 shows various attempts to solve the problem without using the mouse. Keyboard Shortcuts

MrExcel's Learn Excel #923 - Icon Set Alignment

The one problem with icon sets is that they are always left-justified in the cell. Episode 923 will show you why this is a problem and how to overcome it. 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!

Learn how to Create Sparklines in Excel 2010

- Sparklines are tiny, word-sized charts that can appear in a cell. Excel 2010 makes it easy to create sparklines. In Episode 1070, Mike & Bill show you several examples in Excel 2010. 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!

Multiple XY II - 1032 - Learn Excel from MrExcel Podcast

Yesterday's podcast showed a tedious method for creating a chart with 5 XY series. Today, Episode 1032 shows a method for streamlining the creation of this chart. This 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 377 tips from the book!

MrExcel's Learn Excel #926 - Double Lookup

Excel lessons - Double Lookup - Jim has two lists that he wants to match, but some records are missing from one list or the other. There are many ways to solve this. Episode 926 will show the classic double-lookup method. 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!

MrExcel's Learn Excel #939 - Running Total

Excel Lessons: Running Total within Months in a Pi - Create a running total within months in a pivot table. Episode 939 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!

MrExcel's Learn Excel #943 - Sorting Word Paragraphs

Excel Lessons - Sorting Word Paragraphs - Bill (me) asks... is there any way to sort paragraphs in Word? I still don't know the answer, but in Episode 943, I show you how to take the data to Excel, add a few new columns and successfully sort groups of records in Excel.

Dueling: Frequency Distribution - 1040 - Learn Excel Podcast

In this dueling Excel podcast, Bill and Mike look at ways to do a frequency distribution. Episode 1040 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!

Excel Lesson - Charting Zero

Excel Charting Tutorial - Glenn has a series of line charts showing monthly data for 2009. Most charts work fine, but the total chart shows the line dropping to zero for future months. Episode 1004 shows how to solve this problem, then how to solve the problem from the solution to the original problem!

There is no transcript for this video yet – check back soon.