Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

 


Click here to order the book!

 

  "Step by step instructions
will have you up to speed
in no time."
-Erin Beal,
Wyeth BioPharma


Excel for Scientist & Engineers

"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 PhD 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.


Click here to order the book!

About the Author

Dr. Gerard M. Verschuuren is a Microsoft Certified Professional specialized in VB, VBA, and VB.NET. This book covers the same concepts taught during Dr. Verschuuren's Excel Seminars. He has taught this course to major pharmaceutical and other scientific companies with rave reviews!

Dr. Gerard M. Verschuuren has more than 20 years of experience in teaching at colleges and corporations. Dr. Verschuuren holds Master's degrees in Biology (Human Genetics) and in Philosphy, plus a Doctorate in the Philosophy of Science from Unversities in Europe.

He is the author of Life Scientists, Their Convictions, Their Activities, and Their Values (1995, Genesis Publishing Company).

He is also the author behind the Visual Learning Series (MrExcel.com):

-Slide Your Way Through Excel VBA (2003)
-Join the Excellers League (2004)
-Your Access to the World (2004)
-Master the Web (2005)
-Access VBA Made Accessible (2005)

-Excel for Scientists(2003)


Click here to order the book!

If you can't hire Gerry to come to your office, the next best thing is to buy this book!"

Table of Contents

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.

Click here to order the book!

"If you want to save hours per day in Microsoft Excel --- You Need This Book!"


Product Details
Paperback: 116 Pages ; Dimensions (in inches): 8" x 10" x 9.5mm
Publisher: Holy Macro!; ISBN 1-932802-10-X (Sep 2005)
Price: $24.95

Order
Click here to order the book!

 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.