Loading...

Highline Excel 2016 Class 19: Transform Data Sets using Advanced Filter (8 Examples)

22,679 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 3, 2016

Download Files: https://people.highline.edu/mgirvin/A...
In this video learn about:
(00:14) Introduction to Advanced Filter
1. (02:50) Extract Records based on AND Logical Test (AND Criteria). Comprehensive Example including Defined Names that are created and how to run the Advanced Filter a second or third time.
2. (09:48) Extract Records based on OR Logical Test (OR Criteria)
3. (10:39) Extract Records based on "Contains" Criteria ("Partial Text" Criteria)
4. (12:00) Advanced Filter with Complex Criteria
5. (13:00) Advanced Filter Extract to Different Sheet. Extract Data for a given year. See how to create formulas to create criteria base on year. See the functions, DATE and TEXT.
6. (18:00) Advanced Filter to get a Unique List from Column
7. (19:53) Advanced Filter with Helper Column Formula to Create Table Report with Professional and Neat Formatting and Page Setup. See the functions: AND and SEARCH.
8. (29:32) Advanced Filter with Formula Criteria on Large Data Set to Create Report

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...