A Guide to Microsoft Excel 2013 for Scientists and Engineers

by Bernard Liengme

Overview

Completely updated guide for students, scientists and engineers who want to use Microsoft Excel 2013 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.

Product Details

ISBN-13:	9780128028179
Publisher:	Elsevier Science
Publication date:	03/13/2015
Edition description:	New Edition
Pages:	382
Product dimensions:	9.20(w) x 7.50(h) x 0.70(d)

About the Author

Dr. Bernard Liengme attended Imperial College in London and received a BSc & Ph.D. in Chemistry. He also received post-docs at Carnegie-Mellon University in Pittsburgh and the University of British Columbia. He has conducted extensive research 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. He is the author of four previous versions of “A Guide to Microsoft Excel for Scientists and Engineers,” most recently the Excel 2013 version.

Table of Contents

1. Welcome to Microsoft Excel 2013
2. Basic Operations
3. Printing in Excel
4. Using Functions
5. Decision Functions
6. Data Mining
7. Charting
8. Regression Analysis
9. VBA User-Defined Functions
10. VBA Subroutines
11. Modeling I
12. Using Solver
13. Numerical Integration
14. Differential Equations
15. Modeling II
16. Statistics for Experimenters

What People are Saying About This

From the Publisher

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