Excel for Scientists and Engineers


August 2005

Excel for Scientists and Engineers

Step by step instructions will have you up to speed in no time.

Erin Beal, Wyeth BioPharma

category: Spreadsheets
covers: Excel 2003

Product Details
  • 116 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 1-932802-10-X

"Finally - Excel training written for scientists by a scientist!"

Are you tired of trying to learn Excel from an accountant? This book will cover the topics truly important to science and engineering professionals. Learn about sampling distributions and regressions and graphing.

Excel for scientists and engineers quickly guides the reader through topics such as sampling, estimating, distributions, testing, graphing, and data analysis. Being a scientist, Dr. Verschuuren hits upon the important topics that all accounting-centric books ignore.

"Covers the Basics and More In-Depth Tasks"

Learn the crucial Excel tricks to make your life will Excel more efficient, plus the book delves into statistical analysis, sampling distributions, transformations, estimating, trends, and more. Perform Multi-variate regression analysis with ease using this book.

"Why is it so impossibly hard to create a simple Histogram?"

Clearly, no one at Microsoft is a scientist. Why does it take a Ph.D. to put the columns together to make a histogram? Gerry Verschuuren has figured out the steps. Follow the charting chapter to create great-looking histograms and comparative histograms.

Add trendlines, error bars, normal distributions to your graphs

"I can estimate with confidence that you will enjoy this book!"

Learn how to estimate with confidence and more:

  • Estimating with a T-Distribution
  • Estimating with a Binomial Distribution
  • Testing with Significance
  • Testing with Normal and T-Distribution
  • Testing with Chi-Square Distribution
  • Testing with F-Distributions

I dare you to show the above list to any accountant and see if they have any clue what any of those topics mean. Don't try to learn Excel from an accountant.

  1. General Techniques.

    • Copies & Fills
    • Relative vs. Absolute
    • Telling Appearance from Reality
    • Managing Dates
    • Functions inside of Functions
  2. Statistical Analysis.

    • Sampling Distributions
    • Estimating with confidence
    • Testing with significance
  3. Plotting Graphs.

    • Types of charts
    • Extra Axis
    • Line vs XY Charts
    • Error Bars
    • Histrograms
    • Special Effects & Dynamic Ranges
  4. Regression Analysis

    • Mon-factorial
    • Curve fitting
    • Multiple Regression
  5. Complex Functions

    • If, Index, VLOOKUP, Match
    • Array Formulas
    • Homemade Functions
    • Functions inside Functions
  6. Data Analysis.

    • Validation
    • Sorting Records
    • Creating Subtotals
    • Using data filters
    • Database Functions
    • Calculated Criteria
    • Marked Records
  7. Answers to Excercises.


Where to Buy

This product is currently unavailable.


Other Editions


Excel 2007 for Scientists and Engineers

July 2008

From automatic formula replication to formula autocomplete, these features can have you working faster than ever before. Dr. Verschuuren responds with a second edition covering all of these new features, plus expanded content throughout.


Excel 2013 for Scientists

March 2014

You're a Scientist! Aren't you tired of trying to learn Excel from an accountant's perspective? This book will cover the topics truly important to science as well as engineering professionals. Learn about sampling distributions and regressions and graphing.


Related Products


Excel 2013 For Scientists CD

September 2013

Written by a Scientist for Scientists. Complete Excel 2013 Course for the Sciences.