Completed
) 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.
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
