A Guide to Microsoft Excel 2007 for Scientists and Engineers

Front Cover
Academic Press, Nov 27, 2008 - Computers - 336 pages
3 Reviews
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.
 

What people are saying - Write a review

User Review - Flag as inappropriate

meshu exel furmila

User Review - Flag as inappropriate

I agree with the first review and would add that the most this book is worth is free. Something this poorly edited should have been a freebee. ~ $40 no way

Contents

Chapter 1 Welcome to Microsoft Excel 2007
1
Chapter 2 Basic Operations
12
Chapter 3 Printing in Excel
38
Chapter 4 Using Functions
44
Chapter 5 Decision Functions
69
Chapter 6 Data Mining
91
Chapter 7 Charts
101
Chapter 8 Regression Analysis
130
Chapter 11 Modeling I
194
Chapter 12 Using Solver
211
Chapter 13 Numerical Integration
228
Chapter 14 Differential Equations
247
Chapter 15 Modeling II
261
Chapter 16 Statistics for Experimenters
275
Chapter 17 Report Writing
298
Answers
308

Chapter 9 VBA Userdefined Functions
148
Chapter 10 VBA Subroutines
173

Other editions - View all

Common terms and phrases

About the author (2008)

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.

Bibliographic information