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.
