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