When using Microsoft Excel 2007 or 2010 for statistics and scientific purposes I can recommend the following books:
- Microsoft® Excel® 2010 Inside Out (ISBN13: 9780735626881)
- Microsoft® Excel® 2010: Data Analysis and Business Modeling, Third Edition (ISBN13: 9780735643369)
- Microsoft® PowerPivot for Excel® 2010 (ISBN13: 0790145300546)
The first book introduces you from the basics into advanced functions of Excel.
The second book introduces data analysis and modelling tools. The examples are for commercial targets but you should be able to adapt them to your own needs.
The third book teaches you Pivot tables using the PowerPivot Add-in for complex projects.
