A guide to Microsoft Excel for scientists and engineers
Microsoft Excel has a range of functions that can be utilised for the analysis and presentation of experimental results. This text provides a straightforward introduction to these tools directed specifically toward their use in technical subjects. It begins with a basic introduction to spreadsheets in general and Microsoft Excel in particular, before discussing formulas, charts, curve-fitting, equation solving, macros, statistical functions, logic functions, differentiation, integration and many associated functions. Two chapters on modelling are also incorporated bringing all the material together to show how Excel can be used to model an entire system. It rounds up with a chapter on report writing providing valuable instruction on the best way to present results in a formal report. Aimed specifically at scientists and engineers, this is is a book that will be referred to again and again. The author provides invaluable information on the more technical functions of Microsoft Excel in an accessible and user friendly style.
What people are saying - Write a review
We haven't found any reviews in the usual places.
The Microsoft Excel Window Concepts
The Menu Bar
66 other sections not shown
Other editions - View all
active cell aﬁer angle approximation arguments array ATAN2 axis best ﬁt calculations cell address CHAP6.XLS chapter Chart Wizard Click the OK column compute constant Copy cubic equation decimal places deﬁned dialog box differential equation displayed enter the formula Enter the text Enter the values error value evaluate example ﬁgure ﬁle ﬁnd ﬁrst Format formula bar Goal Seek icon integral intercept leﬁ linear loop Macintosh markers matrix menu bar method Microsoﬁ Microsoft Excel module sheet mouse pointer name the cells Note option plot area Preview previous exercise problem quadratic equation radians radio button result retum the value Right click round-off errors Runge—Kutta Save the workbook Sheetl shown in Figure Simpson simultaneous equations solution solve Solver speciﬁed statement strips text and values trapezoid rule user-deﬁned function values shown variable Visual Basic wish worksheet function XY chart zero