Excel for Scientists and Engineers

Learn to fully harness the power of Microsoft Excel® toperform scientific and engineering calculations
With this text as your guide, you can significantly enhanceMicrosoft Excel's® capabilities to execute the calculationsneeded to solve a variety of chemical, biochemical, physical,engineering, biological, and medicinal problems. The text beginswith two chapters that introduce you to Excel's Visual Basic forApplications (VBA) programming language, which allows you to expandExcel's® capabilities, although you can still use the textwithout learning VBA. Following the author's step-by-stepinstructions, here are just a few of the calculations you learn toperform:
* Use worksheet functions to work with matrices
* Find roots of equations and solve systems of simultaneousequations
* Solve ordinary differential equations and partial differentialequations
* Perform linear and non-linear regression
* Use random numbers and the Monte Carlo method
This text is loaded with examples ranging from very basic to highlysophisticated solutions. More than 100 end-of-chapter problems helpyou test and put your knowledge to practice solving real-worldproblems. Answers and explanatory notes for most of the problemsare provided in an appendix.
The CD-ROM that accompanies this text provides several usefulfeatures:
* All the spreadsheets, charts, and VBA code needed to performthe examples from the text
* Solutions to most of the end-of-chapter problems
* An add-in workbook with more than twenty custom functions
This text does not require any background in programming, so it issuitable for both undergraduate and graduate courses. Moreover,practitioners in science and engineering will find that this guidesaves hours of time by enabling them to perform most of theircalculations with one familiar spreadsheet package