A Guide to Microsoft Excel 2007 for Scientists and Engineers
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. New website with data sets, downloadable spreadsheets and other useful resources.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Another Practical Example
Printing in Excel
143 other sections not shown
Other editions - View all
active cell add-in Alpha approximation array formula button calculation Chapter column command companion website compute copy data series 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 matrix method Microsoft Microsoft Excel module Null hypothesis Options Pivot Table plot pooled standard deviation Print Preview problem radians range reference resistor returns Right click 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 TK Solver tool trapezoid rule trendline user-defined function variable Visual Basic wish x-values XY chart zero