A Guide to Microsoft Excel 2007 for Scientists and Engineers

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

Selected pages

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
Index
321
Copyright

Other editions - View all

A Guide to Microsoft Excel 2007 for Scientists and Engineers
Bernard Liengme
Snippet view - 2009

Common terms and phrases

active cell add-in Alpha approximation array formula average button calculation Chap9.xlsm Chapter color column command companion website compute copy data series digits display End Function enter the formula enter the text Enter the values error value Euler's method example Excel Exercise fill handle font Format formula bar give Goal Seek header Insert integral intercept LINEST lookup loop macro markers matrix method Microsoft Microsoft Excel module Note Null hypothesis Options parameters Pivot Table plot pooled standard deviation Print Preview problem radians range reference resistor returns ribbon Right click root Runge–Kutta Runge–Kutta method Save the workbook Select Sheet shortcut shown in Figure solution solve Solver standard deviation subroutine SUMPRODUCT syntax temperature text shown tool trapezoid rule trendline user-defined function variable Visual Basic wish x-values XY chart zero

About the author (2008)

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.

Bibliographic information

TitleA Guide to Microsoft Excel 2007 for Scientists and Engineers
AuthorBernard Liengme
Editionrevised
PublisherAcademic Press, 2008
ISBN0080923518, 9780080923512
Length336 pages
Subjects ›  › 

Computers / Business & Productivity Software / Business Intelligence
Technology & Engineering / Engineering (General)
  
Export CitationBiBTeX EndNote RefMan