Here's how to use advanced filter options like "Begins with" or "Ends with" in Excel:

While the standard filter dropdown doesn't offer these options directly, you can achieve them using the Advanced Filter functionality.

1. Select your data range: Click on any cell within the data table you want to filter.

2. Go to Data tab: Navigate to the "Data" tab on the Excel ribbon.

3. Click Advanced: In the "Sort & Filter" group, click on the "Advanced" button.

4. Choose "Copy to another location": In the "Advanced Filter" window, select the option "Copy to another location."

5. Leave "List range" blank: The "List range" should already be populated with your data table range by default. Leave it as is.

6. Set up criteria for filtering:
- Choose a blank cell outside your data table (preferably above). This will be your criteria cell.
- In this cell, type the text you want to filter by. For "Begins with" criteria, add an asterisk (*) at the end (e.g., "apple*"). For "Ends with" criteria, add the asterisk (*) at the beginning (e.g., "*report").

7. Copy the formula down (optional): If you have multiple criteria using wildcards, enter them in separate rows below your first criteria cell.

8. Define the criteria range: Select the cell containing your first criteria (and any additional criteria cells you created). This becomes your criteria range.

9. Choose the output location: Click in the "Copy to" box and then select the top left corner of the area where you want the filtered results to appear.

10. Click OK: Click the "OK" button to run the advanced filter with your wildcard criteria.

This will copy only the rows that match your "Begins with" or "Ends with" criteria (based on the wildcards) to your chosen output location.