I have been doing a lot of work lately with SharePoint 2007 and came across 2 scenarios where I needed to utilise the Data View Web Part (DVWP) available from within SharePoint Designer (SPD). I honestly think that this is one of the many under utilised tools from within SharePoint.
The Data Source Library appears on the right providing us with the ability to select a SharePoint List from the current site or you could connect to another library from other sites in the site collection.
Click on the required list and then select Show Data. Finally click on Insert Selected Fields as and then select Multiple item view. As you can see from the Common Data View Tasks you can easily create filters, sort, add or remove columns and in my case I was also able to apply Conditional Formatting.