Excel for Scientists and Engineers Numerical Methods by E. Joseph Billo
Learn to fully harness the power of Microsoft Excel(r) to perform scientific and engineering calculations.
With this text as your guide, you can significantly enhance Microsoft Excel’s(r) capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel’s Visual Basic for Applications (VBA) programming language, which allows you to expand Excel’s(r) capabilities, although you can still use the text without learning VBA. Following the author’s step-by-step instructions, here are just a few of the calculations you learn to perform.
A Note About Visual Basic Programming:
Visual Basic for Applications, or VBA, is a “dialect” of Microsoft’s Visual Basic programming language. VBA has keywords that allow the programmer to work with Excel’s workbooks, worksheets, cells, charts, etc. I expect that although many readers of this book will be procient VBA programmers, others may not be familiar with VBA but would like to learn to program in VBA.
The rst two chapters of this book provide an introduction to VBA programming – not enough to become procient, but enough to understand and perhaps modify the VBA code in this book.
For readers who have no familiarity with VBA, and who do not wish to learn it, do not despair. Much
of the book (perhaps 50%) does not involve VBA. In addition, you can still use the VBA custom functions that have been provided. Appendix 1 provides a list of VBA keywords that are used in this book.
The appendix provides a description of the keyword, its syntax, one or more examples of its use, and reference to related keywords. The information is similar to what can be found in Excel’s On-Line
Help, but readers may nd it helpful at those times when they are reading the book without simultaneous access to a PC.
This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package.
- Publisher: Wiley-Interscience
- Language: English
- Pages: 477
- Size: 31.5 MB
- Format: PDF
- Author: E. Joseph Billo
Download Excel for Scientists and Engineers Numerical Methods by E. Joseph Billo in PDF format for free.