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.
