A Guide to Microsoft Excel 2007 for Scientists and Engineers

By

  • Bernard Liengme, St Francis Xavier University, Antigonish, NS, Canada

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.
View full description

Audience

Undergraduate science and engineering students; professional scientists and engineers.

 

Book information

  • Published: November 2008
  • Imprint: ACADEMIC PRESS
  • ISBN: 978-0-12-374623-8


Table of Contents

1. The Microsoft Excel Window2. Basic Operations3. Printing a Worksheet4. Using Functions5. Decision Functions6. Charts7. Curve Fitting8. User-defined Functions9. Modelling I10. Solving Equations11. Numerical Integration12. Differential Equations13. Modelling II14. Statistics for Experimenters15. Report Writing