There are two main ways to filter data by multiple criteria in Excel:

1. Using the Filter Dropdown Menus (Simple Criteria):

This method works well when you have a limited number of criteria and want to filter based on selections from dropdown menus.

* Steps:
1. Select the data table you want to filter.
2. Click on the filter arrow in the header row of the column you want to filter by.
3. Check the boxes next to the criteria you want to include in your filter. You can hold Ctrl (Windows) or Command (Mac) to select multiple options.
4. (Optional) Repeat steps 2 and 3 for additional columns with filtering criteria.
5. Your data table will be filtered to only show rows that meet all selected criteria.

2. Using the Advanced Filter Option (Complex Criteria):

This method is more powerful and allows you to define complex criteria using comparisons, logical operators (AND, OR), and wildcards.

* Steps:
1. Copy your data table to another location on your sheet (optional, but recommended for clarity).
2. Decide on your filtering criteria.
3. In a separate area of your sheet, create a header row with titles matching your data table columns.
4. Below the headers, enter your specific filtering criteria for each column you want to filter by. You can use comparisons (e.g., ">50"), text matching with wildcards (* or ?), and logical operators (& for AND, | for OR) in your criteria.
5. Go to the "Data" tab.
6. Click on "Advanced" within the "Sort & Filter" group.
7. In the "Advanced Filter" window:
- Set the "Action" to "Copy to another location."
- Define the "Copy to" range by selecting the top left corner of your desired output area (where the filtered data will be displayed).
- In the "List range" box, enter the cell range of your original data table (including the header row).
- In the "Criteria range" box, enter the cell range containing your filtering criteria (including the header row).
8. Click "OK" to apply the filter.

Using either method, you can filter your data based on multiple criteria. Remember to choose the approach that best suits your needs and the complexity of your filtering requirements.