Microsoft Excel 2007 Advanced Guide
By the end of this course you will be able to use PivotTables to summarise and analyse data; use a collection of data management tools and functions to extract data from large data lists; import and export data to and from Excel and record and execute macros.
PivotTables and PivotCharts
What If Analysis
Excel 2007 Macros