The advanced find in Microsoft CRM is a great way to filter your data and then either create a view, run marketing against the results, export to Excel and so on.
The video tutorial link below takes you through setting up a simple advanced find that filters on two entities, it then shows how to save the find as a view and then share that view with others.