Learn how to transform data sets using Advanced Filter in Excel 2016 through 8 examples. The course covers extracting records based on logical tests, creating unique lists, and using formula criteria on large data sets. The teaching method includes step-by-step demonstrations and explanations. This course is intended for individuals looking to enhance their Excel skills, particularly in data analysis and manipulation.
Overview
Syllabus
) Introduction to Advanced Filter.
) 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..
) Extract Records based on OR Logical Test (OR Criteria).
) Extract Records based on "Contains" Criteria ("Partial Text" Criteria).
) Advanced Filter with Complex Criteria.
) 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..
) Advanced Filter to get a Unique List from Column.
) Advanced Filter with Helper Column Formula to Create Table Report with Professional and Neat Formatting and Page Setup. See the functions: AND and SEARCH..
) Advanced Filter with Formula Criteria on Large Data Set to Create Report.
Taught by
ExcelIsFun
