Completed
) 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.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Transform Data Sets Using Advanced Filter - Excel 2016
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to Advanced Filter
- 2 ) 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.
- 3 ) Extract Records based on OR Logical Test (OR Criteria)
- 4 ) Extract Records based on "Contains" Criteria ("Partial Text" Criteria)
- 5 ) Advanced Filter with Complex Criteria
- 6 ) 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.
- 7 ) Advanced Filter to get a Unique List from Column
- 8 ) Advanced Filter with Helper Column Formula to Create Table Report with Professional and Neat Formatting and Page Setup. See the functions: AND and SEARCH.
- 9 ) Advanced Filter with Formula Criteria on Large Data Set to Create Report
