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 an 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, 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 instruction on the best way to present results in a formal report.