Excel for Scientists and Engineers: Numerical Methods 1st Edition

by E. Joseph Billo (Author)

17 customer reviews

ISBN-13: 978-0471387343

ISBN-10: 0471387347

Why is ISBN important?

Sell yours for a Gift Card
We'll buy it for $10.82
Learn More
Trade in now

Have one to sell? Sell on Amazon

Added to

Unable to add item to List. Please try again.

Buy new

$41.64

Only 5 left in stock - order soon.

Sold by TEXTBookAMAZING and Fulfilled by Amazon. Gift-wrap available.

This item ships to France. Want it Wednesday, April 11? Choose AmazonGlobal Priority Shipping at checkout. Learn more

List Price: $81.95 Save: $40.31 (49%)

20 New from $35.64

Select delivery location

Turn on 1-Click ordering

More Buying Choices

20 New from $35.64 22 Used from $35.64

42 used & new from $35.64

See All Buying Options

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations

With this text as your guide, you can significantly enhance Microsoft Excel's® 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® 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:

Use worksheet functions to work with matrices
Find roots of equations and solve systems of simultaneous equations
Solve ordinary differential equations and partial differential equations
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 highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix.

The CD-ROM that accompanies this text provides several useful features:

All the spreadsheets, charts, and VBA code needed to perform the 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 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

Frequently bought together

Total price: $79.30

These items are shipped from and sold by different sellers. Show details

Buy the selected items together

This item:Excel for Scientists and Engineers: Numerical Methods by E. Joseph Billo Paperback $41.64
Only 5 left in stock - order soon.
Sold by TEXTBookAMAZING and ships from Amazon Fulfillment.
FREE Shipping. Details
A Guide to Microsoft Excel 2013 for Scientists and Engineers by Bernard Liengme Paperback $37.66
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping. Details

Customers who bought this item also bought

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

David M Bourg

18

Paperback
$35.71
Bernard Liengme

4

Paperback
$37.66
Francis Hauser
Paperback
$24.99
S. C. Bloch

6

Paperback
22 offers from $2.99
Gerard M. Verschuuren…

14

Paperback
$23.89
Kenneth R. Baker

5

Hardcover
$74.90

Editorial Reviews

Review

"I thoroughly enjoyed this book and recommend it to anyone who finds themselves using Excel to do numerical computations beyond the basic spreadsheet operations. The CD provides a wealth of custom functions that extend the usefulness of Excel plus virtually all of the spreadsheets, charts, and VBA code needed to perform the example problems given in the text. This paperback edition and CD are a real bargain." (Technometrics, May 2008)

"This is a wonderful book for power users of Excel or those wanting to learn VBA and could also be useful as a course book in numerical methods…"" (IEEE Electrical Insulation Magazine, July/August 2008)

"I am wiser now, and you should be, too! This book is strongly recommended for all engineers, scientists, undergraduate and graduate students that have ever used EXCEL." (Materials and Manufacturing Processes, Volume 22, Issue 7 2007)

"An excellent volume for practicing scientists or engineers encountering numerical methods." (CHOICE, October 2007)

From the Back Cover

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations

Use worksheet functions to work with matrices
Find roots of equations and solve systems of simultaneous equations
Solve ordinary differential equations and partial differential equations
Perform linear and non-linear regression
Use random numbers and the Monte Carlo method

The CD-ROM that accompanies this text provides several useful features:

All the spreadsheets, charts, and VBA code needed to perform the examples from the text
Solutions to most of the end-of-chapter problems
An add-in workbook with more than twenty custom functions

See all Editorial Reviews

Product details

Paperback: 480 pages
Publisher: Wiley-Interscience; 1 edition (April 6, 2007)
Language: English
ISBN-10: 0471387347
ISBN-13: 978-0471387343
Product Dimensions: 7 x 1 x 10 inches
Shipping Weight: 12.6 ounces (View shipping rates and policies)
Average Customer Review: 17 customer reviews
Amazon Best Sellers Rank: #952,478 in Books (See Top 100 in Books)
- #351 in Books > Computers & Technology > Software > Microsoft > Microsoft Excel
- #580 in Books > Computers & Technology > Business Technology > Software > Spreadsheets
- #4662 in Books > Textbooks > Engineering

Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?

NO_CONTENT_IN_FEATURE

Customer Reviews

2 star (0%)

1 star (0%)

Write a customer review

See all 17 customer reviews

Rated by customers interested in

What's this?

Engineering & Transportation Books

5.0 out of 5 stars

Computer Books

5.0 out of 5 stars

Business & Economics Books

4.2 out of 5 stars

Is this feature helpful?

Thank you for your feedback.

Top customer reviews

There was a problem filtering reviews right now. Please try again later.

Persnickety one

This book is really helpful but dated

July 9, 2012

Format: PaperbackVerified Purchase

First, the negatives: this book is based on Excel 2003 -- now a couple of version old. The menus and icons have changed plus the language is continuing to evolve. There are also some errors in the index (page numbers off by a page or two -- which is Wiley's problem not the author's). So I can't give it five stars.

Now the positives: most significantly the author is trying to be helpful and explain things. This stands in sharp contrast to the online documentation Microsoft has put out. He is a retired professor and it shows: he is a good teacher. He does simple things like have short snippets of code that illustrate one thing (vs. Microsoft which favors examples that require an understanding of how to dynamically redimension arrays in order to illustrate the basics like how you pass arrays to functions). Many authors of computer books seem to be trying to convince us how smart they are. Prof. Billo seems content to help us learn to be smart. I think this is a very wise choice.

The book is also targeted to technical people. I want to work with numbers not printing. That may not seem surprising given the title, but the ability of the author to clearly define his audience, write to them, focus on helping them and deliver what is promised is very much appreciated. If you are reading this review, you are one of us -- and if you can live with an older book, you have a winner.

Comment 2 people found this helpful. Was this review helpful to you?

Yes

ChemProf

good reference book

October 30, 2013

Format: PaperbackVerified Purchase

I purchased this for my use and use it as a reference text.
It is a little better description of specific numeric methods than the authors Excel for Chemists text with no specific examples to chemistry (why I use it as a reference and don't require it for my students)
It is written for use with Excel 2007 or lower and some of the material in the text is not applicable to Excel 2010 or Excel 2013 (hence, the four stars instead of five). With a little bit of work on my part, I was able to eventually use what wasn't applicable in Excel 2013.
i especially like the included CD with all of the spreadsheets discussed in the text

Comment 2 people found this helpful. Was this review helpful to you?

Yes

Namir C. Shammas

Excellent Book on Excel VBA Programming

December 10, 2007

Format: PaperbackVerified Purchase

My library holds many books on using Excel and programming in Excel VBA. Billo's book has brought valuable hints and techniques that have enhanced my VBA programming skills. The book offers a well balanced coverage of numerical analysis and statistical regression topics. While the examples are more geared for the chemists, they should not be a turn off for readers who are in other scientific and engineering disciplines.

Billo offers an interesting approach to using VBA code and shows you, throughout the book, how to write functions (in modules) that you can use as "custom functions" in your spreadsheets. Excel invokes these functions automatically whenever you alter a cell value and trigger automatic recalculations. This technique frees you from having to repeatedly invoke VBA macros to recalculate values in a spreadsheet. The "custom functions" you learn to build become a custom extension to the Excel library of built-in functions.

I highly recommend this fine book and congratulate the author on his clever work. Billo's book stands out among other Excel VBA books.

Comment 35 people found this helpful. Was this review helpful to you?

Yes

Starship1974

This book is the REAL DEAL......

July 10, 2008

Format: PaperbackVerified Purchase

Excel for Scientists and Engineers: Numerical Methods
I am very pleased with my purchase of this book. This book is the REAL DEAL.....if you are looking to do advanced numerical math with an Excel spreadsheet. Many other "Excel books for Scientists" simply offer elementary methods on error detection, lists of items and simple math like rounding off, etc. This book is completely different. It starts of on doing matrices with Excel, then goes through Interpolation, differentiation, Integration, Simultaneos Equations, Partial Differential equations, then finishes off with both Linear as well as Non-Linear Regression techniques and Curve Fitting.

In and of itself, even if it didn't show methods to do these things with an Excel spreadsheet, the book would be well worth the read simply as a refresher course in these topics. However, it does show lucid, well-thought out examples of implementing complex numerical methods with standard Excel spreadsheets.

The only thing that this book is lacking in, is a coverage of normal level usage of VBA. It does start off in the very first few chapters with a cursory coverage of VBA, but that is pretty much all that we hear of VBA throughout the rest of the book. However, this is not too much of a drawback, because there are many volumes of other books which cover VBA in wonderful detail. What would be a marriage made in Heaven would be this book with more step-by-step integration with VBA, showing advanced programming techniques in Excel with regards to the great coverage of numerical methods.

Comment 18 people found this helpful. Was this review helpful to you?

Yes

Rick Rusty

Excellent Collection of Recipies

September 28, 2011

Format: PaperbackVerified Purchase

This is a great collection of numerical recipies for finding roots, interpolation, calculus and differential equations, both ordinary and partial. Both the algorithms and code are given and a CD is included if you don't like to type them in yourself.

The methods are well-presented and all of the ones I've played with have worked great. This is not a book to learn Excel VBA programming. It has a short intro to this but a newcomer to VBA could not learn it very easily from here, even if they have programmed before. This is a grad-level text. You will have to be very competent at VBA to understand many of the code examples.

I needed some hard-hitting algorithms that I could implement in VBA and this book is just what I was looking for.

CommentWas this review helpful to you?

Yes

Amazon Customer

Three Stars

August 23, 2016

Format: PaperbackVerified Purchase

Outdated newer versions of excel have been released

Comment One person found this helpful. Was this review helpful to you?

Yes

HMC

EXCELLENT

October 11, 2015

Format: PaperbackVerified Purchase

EXCELLENT

Comment One person found this helpful. Was this review helpful to you?

Yes

Robert K

Five Stars

November 23, 2015

Format: PaperbackVerified Purchase

Great book! Highly recommend this book to anyone wanting to get a more technical approach to excel.

Comment One person found this helpful. Was this review helpful to you?

Yes

Most recent customer reviews

Indra Ghosh

Good.

Good book. Liked it.

Published on November 6, 2014

CHAD A SPENCER

Need a template?

Great book for what it is--a quick and productive way to use Excel. Topics are not covered extremely in-depth, nor should they...Read more

Published on August 18, 2014

V. Isoz

Très bon ouvrage

La quasi totalité des livres sur le marché comprenant dans l'intitulé "pour ingénieurs" ou "pour scientifiques" ne dépassent rarement pas le...Read more

Published on December 14, 2012

HCh

Excellent refresher, Useful and Very Effectively Presented

Into the working life and using more applied formulas and methods, some of the origin to the aplied formulas have been rusty.Read more

Published on January 6, 2012

Manu

A really good book

This is definitely the book you need if you want you gain skill in programing tasks.

Congratulations to the author!

Published on June 27, 2011

Cesar A. Real Ramirez

About the book and CD

It has been a useful material to recommend my students different math sources.

The book has interesting material but the complementary CD is neccesary

Published on March 30, 2010

Mark Backes

Good as described

The book contained well written material for the use of doing math at a higher level with Excel software, as described. I liked it.

Published on October 1, 2009

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway

This item: Excel for Scientists and Engineers: Numerical Methods

Set up a giveaway

Customers who viewed this item also viewed

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Bernard Liengme

4

Paperback
$37.66
Dr. Gerard Verschuuren

3

Paperback
$25.15
David M Bourg

18

Paperback
$35.71
William J. Orvis

10

Paperback
19 offers from $6.46
Ronald W. Larsen

26

Paperback
31 offers from $39.00
Francis Hauser
Paperback
$24.99

Pages with related products. See and discover other items: electronics engineer

Excel for Scientists and Engineers: Numerical Methods 1st Edition

Turn on 1-Click ordering

Frequently bought together

Sponsored products related to this item (What's this?)

Customers who bought this item also bought

Editorial Reviews

Review

From the Back Cover

Product details

Sponsored products related to this item (What's this?)

Customer Reviews

Top customer reviews

There was a problem filtering reviews right now. Please try again later.

Most recent customer reviews

Set up an Amazon Giveaway

Customers who viewed this item also viewed

Excel for Scientists and Engineers: Numerical Methods 1st Edition

Sorry, there was a problem.

Sorry, there was a problem.

Turn on 1-Click ordering

Frequently bought together

Sponsored products related to this item (What's this?)

Customers who bought this item also bought

Editorial Reviews

Review

From the Back Cover

Product details

Sponsored products related to this item (What's this?)

Customer Reviews

Top customer reviews

There was a problem filtering reviews right now. Please try again later.

Most recent customer reviews

Set up an Amazon Giveaway

Customers who viewed this item also viewed