This first link includes the following topics on the Lightning Conductor Web Part for SharePoint 2007:
- installing
- configuring
- filtering
- presentation

Getting Started using the Lightning Conductor Web Part

Rolling up lists and libraries with custom columns.

Rolling up content type information from SharePoint

Configure and set custom XSL styles for the web part