CO
Upload
Alert icon

Highline Excel Class 19: Advanced Filter Extract Data 9 Examples

ExcelIsFun ExcelIsFun·2,044 videos
87,421
91,249
Like     Dislike 4

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like ExcelIsFun's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike ExcelIsFun's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add ExcelIsFun's video to your playlist.

Uploaded on Apr 13, 2009

Download Excel file: http://people.highline.edu/mgirvin/ex...

Learn about using Advanced Filter to extract data from an Excel List / Table / Database. See these 7 Advanced Filter examples:
1. Extract data with 1 criteria
2. See how Criteria and Extract areas get Named
3. Extract data with 2 or more AND criteria
4. Extract data with 2 or more OR criteria
5. Extract Unique Records
6. Extract data To Different Worksheet
7. Extract data To Different Workbook
8. Add column with True False Formula
9. Extract data with formula criteria
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

The interactive transcript could not be loaded.
Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Uploader Comments (ExcelIsFun)

  • funda dumlupinar

    funda dumlupinar 1 month ago

    you are totally amazing and a very good teacher! thank you for your useful videos, i learn so many things for my work which is heavily excel based so thank you thank you and endlessļ»æ thank you!!!

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate funda dumlupinar's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate funda dumlupinar's comment.
  • ExcelIsFun

    ExcelIsFun 1 month ago

    You are welcome!ļ»æ

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate ExcelIsFun's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate ExcelIsFun's comment.
    in reply to funda dumlupinar (Show the comment)
  • chenteng100

    chenteng100 4 months ago

    Great video, many thanks,ļ»æ throughly enjoyed Excel is fun.

    · 2

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate chenteng100's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate chenteng100's comment.
  • ExcelIsFun

    ExcelIsFun 4 months ago

    I am gladļ»æ that the video helped!

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate ExcelIsFun's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate ExcelIsFun's comment.
    in reply to chenteng100 (Show the comment)
  • VerindraGproductions

    VerindraGproductions 6 months ago

    Thankļ»æ you

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate VerindraGproductions's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate VerindraGproductions's comment.
  • ExcelIsFun

    ExcelIsFun 6 months ago

    You are welcome!ļ»æ

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate ExcelIsFun's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate ExcelIsFun's comment.
    in reply to VerindraGproductions (Show the comment)

Video Responses

This video is a response to Highline Excel Class 18: Subtotals

All Comments (78)

Sign in now to post a comment!
  • Mohammad Taha

    Mohammad Taha 2 weeks ago

    It's unbelievable how powerful excel is

    and you manļ»æ is such an amazing one

    I want to be like you

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Mohammad Taha's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Mohammad Taha's comment.
  • funda dumlupinar

    funda dumlupinar 1 month ago

    :)ļ»æ

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate funda dumlupinar's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate funda dumlupinar's comment.
    in reply to ExcelIsFun (Show the comment)
  • im vuthea

    im vuthea 3 months ago

    have more than orļ»æ not

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate im vuthea's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate im vuthea's comment.
  • Warren forman jr.

    Warren forman jr. 3 months ago

    Like aļ»æ schedule

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Warren forman jr.'s comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Warren forman jr.'s comment.
  • Warren forman jr.

    Warren forman jr. 3 months ago

    How can you vlookup somethingļ»æ a week at a time...

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Warren forman jr.'s comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Warren forman jr.'s comment.
  • planiolro

    planiolro 3 months ago

    Oldies but Goldies ļ»æ

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate planiolro's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate planiolro's comment.
  • Norbert Van Houten

    Norbert Van Houten 4 months ago

    no yourļ»æ awesome dude!

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Norbert Van Houten's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Norbert Van Houten's comment.
    in reply to Norbert Van Houten (Show the comment)
  • Norbert Van Houten

    Norbert Van Houten 4 months ago

    dude your soļ»æ awesome

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Norbert Van Houten's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Norbert Van Houten's comment.
    in reply to Norbert Van Houten (Show the comment)
  • Loading comment...
Loading...
Advertisement
Loading...
Working...
Sign in to add this to Watch Later