Great book that will assist you in creating pivot table reports in Excel from external data sources. It takes you through step by step for each different data source. includes MS Query and SQL. includes instructions for pivot table creation. For intermediate to advanced users.
Excel 2007 Advanced Report Development (Wiley Publishing)