BUY THIS BOOK
Add to Cart

Print Book $44.99


Add to Cart

PDF $35.99

Safari Books Online

What is this?

Add to UK Cart

Print Book £31.99

What is this?

Looking to Reprint or License this content?

Excel Scientific and Engineering Cookbook

By David M. Bourg
First Edition  January 2006 
Pages: 442
Series: Cookbooks
ISBN 10: 0-596-00879-1 | ISBN 13: 9780596008796
starstarstarstarstar (Average of 4 Customer Reviews)

Buy 2 Get 1 Free Free ShippingGuarantee

Book description

This quick, look-up reference is perfect for anyone in the science and engineering community who wants to improve upon their Excel skills. You'll learn how to leverage Excel to perform both routine and complex calculations, and then visualize the results for presentation. Features practical data analysis techniques and real-world examples from a range of scientific disciplines.
Full Description

Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice.

Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others:

  • Use Excel and VBA in general
  • Import data from a variety of sources
  • Analyze data
  • Perform calculations
  • Visualize the results for interpretation and presentation
  • Use Excel to solve specific science and engineering problems

Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks.

High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.

Browse within this book

Cover | Table of Contents | Colophon




Featured customer reviews

Write a Review


a good book,  December 19 2007
Rating: StarStarStarStarStar
Submitted by AS   [Respond | View]

By the time I read this book I had already discovered, on my own, many of the things presented. However I would have saved considerable time and frustration had I read the book first. It it definitely a good book, not just for learning, but also as a reference. If you plan to use Excel for science and engineering, read this book first.


Head and Shoulders above the rest,  October 23 2007
Rating: StarStarStarStarStar
Submitted by luriol   [Respond | View]

I've been trying to find a book which could help my physics students analyze laboratory data using excel. There are so many badly written excel books out there that I almost gave up. Then I found the Excel Scientific Engineering Cookbook. Great book! The information is layed out so you can find what you need easily and the level of detail is just right. Also a great chapter on VBA which lets you jump right in and do stuff.


Really A Book for Beginner,  July 21 2007
Rating: StarStarStarStarStar
Submitted by paldopal   [Respond | View]

I have seen and read a lot of books on Excel but no one meet my needs.This book is like that the someone is sitting in front of u and explaing u every thing that u want to know and understand.
And once the person reads this book it cann't control itself to turn out the next page of this wonderful book.

Thanks to OReilly and the author of this book.
Please say my words to the author that u r great.

Read all reviews


Wow! Just what was needed,  March 23 2006
Submitted by Anonymous Reader   [Respond | View]

I discovered the title while I was taking a break at work and came to oreilly.com looking for an Excel book.

I d/l chapter 9, Solving Equations and then I d/l the excel files and all-in-all, I was astonished at the quality of information I was looking at... immediately ordered the book.

Am now considering buying Bourg's other book, "Physics for Game Developers," simply for the reason that the chapter I d/l on at the book link was a chapter concerning projectile motion which was cool, but as I was looking through that chapter, I about fell off my chair when I saw his comments concerning the Reynolds Number ... to me, this was too amazing since I use this value every day at work!


Wow! Just what was needed,  January 24 2006
Rating: StarStarStarStarStar
Submitted by dtsitrelis   [Respond | View]

A treasure trove of numerical methods for spreadsheets. While using Excel in this way won't replace a more general-purpose mathematical package like Mathematica, Maple, etc. it leverages spreadsheet applications to provide widely available solutions.

I especially liked that the authors included a little theory when explaining each technique and that they provide such a fair use policy of the included code.


Media reviews
"Scientists and engineers will find this book an excellent guide to the problem-solving and information-visualization capabilities of Excel. In fact, anyone—including students—required to report concisely on research data and results would find this book useful."
-- Charlene Brown, Big Blue & Cousins (BB&C)


"If you are into complex formulas and functions, then this book has quite a few recipes to choose from to help you get your work done. Five out of five stars. Weaknesses: None."
-- Robert Pritchett, MacCompanion


"You'll find this book a compilation of practical information and you'll refer to it often as you analyze and present data. I particularly liked Bourg's chapter on charting. Although I use Excel to display simple graphs, I never mastered the use of multiple axes. The how-to examples and descriptions provide the instructions needed to add extra axes to plots. And I learned how to effectively plot 3D surfaces, too. I recommend this book highly."
-- Jon Titus, Design News



Read all reviews

See larger cover


"Scientists and engineers will find this book an excellent guide to the problem-solving and information-visualization capabilities of Excel."
--Charlene Brown, Big Blue & Cousins (BB&C)