Microsoft Excel 2021365 - Beginner to Advanced - Using the Advanced Filter

What is the purpose of using the advanced filter option in Excel?

How can you extract a unique list of values from a data set using Excel's advanced filter?

What steps must be taken to specify the action when using the advanced filter?

What is the significance of selecting 'unique records only' when using the advanced filter?

What criteria can be used to filter records in Excel using the advanced filter?

Describe how the advanced filter can be used to extract values based on specific criteria.

Explain how to perform an OR filter using the advanced filter in Excel.