# Excel Scientific and Engineering Cookbook ( examples)

#### Tag: Office

Posted on 2007-06-24, updated at 2009-09-29. By anonymous.

Description

• Author: David Bourg

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.

The purpose of this book is to show you how to leverage Excel as a capable computing tool to solve a variety of both routine and complex problems. As a practicing engineer and researcher, I've used Excel extensively for everything from routine data analysis to sophisticated design optimization problems. There's little doubt Excel spreadsheets are quick and easy to use. Excel's convenient spreadsheet interface and functionality combined with its integrated Visual Basic for Applications programming language make it a powerful, versatile computing tool. Its ready availability makes it even more attractive.

It's tough to dismiss Excel as a computing tool when it's very likely sitting right there on your work and home computers. You probably already use Excel to some extent for routine calculations. I'd like to show you how you can leverage Excel for some calculations that are not so routine. Don't worry if you're new to Excel, because I cover the basics as well.

This book is full of real-world uses of Excel, many of which I have personally performed either for my own work or for clients. Throughout this book, I try to use easily recognizable, yet real-world, examples wherever possible. To this end, I draw examples from a variety of scientific disciplines, ranging from biology and chemistry to physics to structural engineering. I hope to show you how to leverage Excel to solve problems you may face in your everyday scientific or engineering tasks.

Chapter 01. Using Excel

Chapter 02. Getting Acquainted with Visual Basic for Applications

Chapter 03. Collecting and Cleaning Up Data

Chapter 04. Charting

Chapter 05. Statistical Analysis

Chapter 06. Time Series Analysis

Chapter 07. Mathematical Functions

Chapter 08. Curve Fitting and Regression

Chapter 09. Solving Equations

Chapter 10. Numerical Integration and Differentiation

Chapter 11. Solving Ordinary Differential Equations

Chapter 12. Solving Partial Differential Equations

Chapter 13. Performing Optimization Analyses in Excel

Chapter 14. Introduction to Financial Calculations

5608 dl's @ 2871 KB/s
9369 dl's @ 3978 KB/s
6953 dl's @ 2053 KB/s

Search More...
Excel Scientific and Engineering Cookbook ( examples)

Related Books

2 Comments for "Excel Scientific and Engineering Cookbook ( examples)":

1. Me pueden indicar cual es la clave, por fa?
Posted by jicos on 2008-11-13 04:15, email hidden.
2. i thank u so much!
Posted by guest on 2009-09-29 04:23, email hidden.