Completely updated guide for scientists, engineers and students who want to use Microsoft Excel 2007 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 utilized for the modeling, analysis and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data.
- Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with the new Microsoft Office release of Excel 2007.
- Features of Excel 2007 are illustrated through a wide variety of examples based in technical contexts, demonstrating the use of the program for analysis and presentation of experimental results.
- Updated with new examples, problem sets, and applications.
|Edition description:||New Edition|
|Product dimensions:||7.40(w) x 9.10(h) x 0.70(d)|
About the Author
Bernard Liengme attended Imperial College in London and received a BSc & PhD in Chemistry. He also received post-docs at Carnegie-Mellon University in Pittsburg and the University of British Columbia. He has conducted extensive reseach in surface chemistry and Mossbauer Effect. He has been at St Francis Xavier University in Canada since 1968 as professor, Associate Dean and Registrar as well as teaching chemistry and computer science.
Table of Contents
1. The Microsoft Excel Window
2. Basic Operations
3. Printing a Worksheet
4. Using Functions
5. Decision Functions
7. Curve Fitting
8. User-defined Functions
9. Modelling I
10. Solving Equations
11. Numerical Integration
12. Differential Equations
13. Modelling II
14. Statistics for Experimenters
15. Report Writing