COOKING WITH SCIENCE AND ENGINEERING!!

Do you have scientific or engineering calculations to perform? If you do, then this book is for you! Author David M Bourg, has done an outstanding job of writing a book that shows you how to leverage Excel as a capable computing tool to solve a variety of both routine and complex problems.

Bourg, begins by covering a variety of fundamental topics, including navigating Excel's interface, entering data and formulas, and formatting cells. Then, the author covers a variety of fundamental VBA programming topics, including VBA syntax, using the VBA editor, and integrating VBA code with Excel spreadsheets. Next, he shows you how to import data into Excel from a variety of sources, including text files, databases, and the Web. The author then shows you how to visualize data in Excel. He continues by showing you how to perform standard statistical calculations in Excel, such as computing summary statistics, calculating confidence intervals, and performing analysis of variance, among other calculations. Then, the author shows you how to conduct various time series analysis tasks, including forecasting and Fourier transforms in Excel. Next, he introduces you to many of Excel's useful math functions. The author continues the discussion of data analysis, specifically focusing on curve fitting and regression analysis. Then, the author shows you how to leverage Excel to solve linear and nonlinear equations, as well as linear and nonlinear systems. Next, he shows you how to perform various numerical integration calculations, such as computing areas and moments of areas, among others. The author then shows you how to solve initial value and boundary value problems using standard numerical techniques such as the Runge-Kutta and shooting methods. He continues by showing you how to leverage Excel to help solve problems involving partial differential equations. Then, the author shows you how to perform optimization analysis using Excel's built-in optimization tools. Finally, he introduces you to some of Excel's extensive financial analysis capabilities.

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.

Other Reviews

• quick and easy tool : Excel - Take every usefulness from it.
• PROBLEM SOLUTION DISCUSSION
• Excel Cookbook Half Baked
• an alternative point of view
• COOKING WITH SCIENCE AND ENGINEERING!!