Print Book $44.99
Print+PDF
$58.49
Print Book £31.99
By David M. Bourg
January 2006
Pages: 442
Series: Cookbooks
ISBN 10: 0-596-00879-1 |
ISBN 13: 9780596008796
(Average of 4 Customer Reviews)
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
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.
Register your book | Submit Errata | Examples
Browse within this book
Cover | Table of Contents | Index | Sample Chapter | Colophon
Book details
First Edition: January 2006
Series:
Cookbooks
ISBN: 0-596-00879-1
Pages: 442
Average Customer Reviews: (Based on 4 Reviews)
Featured customer reviews
a good book, December 19 2007
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
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
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.
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
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
"The book is good value for the money...I usually avoid other reviews of a book I’m trying to review, but after most of this was written, I took a peek at Amazon’s reader reviews. This book gets high marks from some professional people."
-- Rip Lowman, eJournal of the Tucson Computer Society
"This most excellent book aims to present Excel as a cradle to the grave computing environment for scientific and engineering computations. More importantly, this book shows you how to use Excel and VBA in general, how to import data from a variety of sources, analyze data, perform calculations, and finally visualize the results for interpretation and presentation."
-- John Vacca, Amazon.com
"If you are going to use Excel, and you expect to occasionally need to try something new, I heartily recommend this book. If nothing else, your spouse will appreciate not hearing you cuss yourself blue in the face."
-- Bill Bruml, Mouse Tales
"The book is filled with real world examples of solutions to scientific and engineering problems. A utility book for the science and engineering students, the book is also recommended for the Excel and other spreadsheet enthusiasts."
-- Ganadeva Bandyopadhyay, Desicritics.org
"This is a great reference book to people in the scientific and engineering community who have used Excel, but would like to dig a little deeper and be able to better utilize more of Excel's capability. I've used Excel for over a decade, and still found this book to be a good reference. The author covers a wide variety of subjects such as: importing data into Excel, VBA, Statistical Analysis and Curve Fitting/Regression Testing, Solving Differential Equations, etc. The cookbook approach, along with a decent index make it easy to locate a relevant function/recipe that a person is looking for. Excel 2003 is covered (although older versions are also referred to). I recommend the book to anybody using Excel and wanting to further explore its capabilities."
-- Nick Bulitka, Amazon.com
