Utilizing the Advanced Search is the best way to report and filter through your opportunities.

This advanced search tool is the most effective way to get the results you are after, and it allows you to export the results to an Excel file

The advanced search allows for AND/OR conditions  - for more details on the Advanced search


The opportunities advanced search allows you to search opportunity fields and cross search against company fields or keywords.