„I thoroughly enjoyed this book and recommend it to anyone whofinds themselves using Excel to do numerical computations beyondthe basic spreadsheet operations. The CD provides a wealth ofcustom functions that extend the usefulness of Excel plus virtuallyall of the spreadsheets, charts, and VBA code needed to perform theexample problems given in the text. This paperback edition and CDare a real bargain.“ (Technometrics, May 2008)
„This is a wonderful book for power users of Excel or thosewanting to learn VBA and could also be useful as a course book innumerical methods...“„ (IEEE Electrical InsulationMagazine, July/August 2008)
“I am wiser now, and you should be, too! This book is stronglyrecommended for all engineers, scientists, undergraduate andgraduate students that have ever used EXCEL.„ (Materials andManufacturing Processes, Volume 22, Issue 7 2007)
“An excellent volume for practicing scientists or engineersencountering numerical methods." (CHOICE, October 2007)
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
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
