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

Message Board

MrExcel Store



Click here to order the book!


  Excel 2007 offers significant new features over previous versions of Excel.

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 2007 for Scientists and Engineers

"Training for Excel 2007 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. With examples from the world of science and engineering, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Physicists and engineers can learn the tips and techniques of Excel—and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more. Ideal for students and professionals alike, this handbook will enable greater productivity and efficiency. Excel 2007 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 with 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, and 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 (

-Excel 2007 VBA
-Excel 2007 for Scientists
-Excel 2007 Expert
-Your Access to the World
-Master the Web
-Access VBA Made Accessible

-See Sharper with C#

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

PART 1: General Techniques
  • Navigation in Excel 2007
  • The Fill Handle
  • Relative Vs. Absolute Cell References
  • Range Names
  • Nested Functions
  • Excercises: Part-1
PART 2: Data Analysis
  • Auto-numbering
  • Subtotals
  • Summary Functions
  • Unique Lists
  • Data Validation
  • Conditional Formatting
  • Filtering Tools
  • Lookups
  • Working with Trends
  • Fixing Numbers
  • Copying Formulas
  • Multi-cell Arrays
  • Single-cell Arrays
  • Date Manipulation
  • Time Manipulation
  • Excercises: Part-2
PART 3: Plotting Data
  • Types of Graphs
  • A Graph’s Data Source
  • Combining Graph Types
  • Changing Graph Locations
  • Templates and Defaults
  • Axis Scales
  • More Axes
  • Error Bars
  • More Bars
  • Line Markers
  • Interpolation
  • Graph Formulas
  • Excercises: Part-3
PART 4: Regression Analysis
  • Linear Regression
  • Nonlinear Regression
  • Curve Fitting
  • Sigmoid Curves
  • Predictability
  • Correlation
  • Multiple Regression: Linear Estimates
  • Reiterations and Matrixes
  • Solving Equations
  • What-If Controls
  • Syntax of Functions
  • Worksheet Functions
  • Excercises: Part-4
PART 5: Statistical Analysis
  • Why Statistics?
  • Types of Distributions
  • Simulating Distributions
  • Sampling Techniques
  • Each Test Has Its Own Conditions
  • Estimating Means
  • Estimating Proportions
  • Significant Means
  • Significant Proportions
  • Significant Frequencies
  • More on the Chi-Squared Test
  • Analysis of Variance
  • Power Curves
  • Excercises: Part-5

Click here to order the book!

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

Product Details
Paperback: 198 Pages ; Dimensions (in inches): 8" x 10" x 9.5mm
Publisher: Holy Macro! Books; Second edition edition (April 1, 2008)
ISBN-10: 1932802355
ISBN-13: 978-1932802351
Price: $29.95

Click here to order the book!

Ideal for students and professionals alike, this handbook will enable greater productivity and efficiency.


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

All contents Copyright 1998-2007 by MrExcel Consulting.