The indispensable guide for all scientists, engineers and students who wish to use Microsoft Excel to its full potential

Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilised for the analysis and presentation of experimental results. This text provides a practical and straightforward guide to using these functions of Microsoft Excel to their full potential, guiding the reader from basic principles through to the more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, logic functions, and databases.

The new edition has been brought fully up to date with the new Microsoft Office XP release of Excel 2002 but can be used alongside any previous version of Excel, with new Excel 2002 features clearly indicated throughout.

Contents

1. The Microsoft Excel window
2. Basic operations
3. Printing a worksheet
4. Using functions
5. Decision functions
6. Charts
7. Curve fitting
8. User-defined functions
9. Modelling 1
10. Solving equations
11. Numerical integration
12. Differential equations
13. Modelling 2
14. Statistics for experimenters
15. Report writing