Reporting with Advanced Filter
There is an Excel file that teaches how to perform the Reporting with Advanced Filter operation.
Excel Template for Reporting with Advanced Filter
This workbook generates reports from 192 sales records using advanced filtering with criteria from a separate Firms sheet and an 11-row report output.
Hope it is useful.