About Mr.Excel 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 CD! "Finally! The guide to Excel for Scientists, written by a Scientist!" More than twice the pages of the previous version.

# Learn at Your Own Pace

Visual training covering Excel 2007. This 1800 slide, self-paced training package is loaded with informative topics. Pick and choose from the training and learn at your pace on your own schedule.

# Completely Visualized in Full Color!

Learn Excel 2007 in full color. Every slide has rich illustrations to demonstrate the concept.

# Self-Checks to Ensure Comprehension!

Click through the slides at your own pace. Every few slides, there will be a multiple choice question to ensure you've mastered recent concepts. These are the same concepts taught during Dr. Verschuuren's Excel Seminars. If you can't schedule Gerry at your office, then the next best thing is to buy this CD!

# Look at everything you will learn!

You get four complete modules on the CD covering 1800 slides.

Module 1 - Regression Ananlysis (450 slides)

1. Basic Techniques

• Fill Handle
• Relative vs. Absolute
• Range Names
• Nested Functions
2. Single Regression
• Linear Regression
• Non-Linear Regression
• Curve Fitting
• Sigmoid Curves
• Predictability
3. Multiple Regression
• Correlations
• Number Looks
• Linear Estimates
4. Solving Equations
• Re-iterations and Matrices
• Solving Tools
• What-if Controls
5. Building Functions
• Functions Syntax
• Worksheet Functions
Module 2 - Data Analysis (450 slides)

1. Basic Techniques

• Fill Handle
• Relative vs. Absolute
• Range Names
• Nested Functions
2. Summaries
• Auto-numbering
• Subtotals
• Summary Functions
• Unique Lists
• Data Validation
3. Finding Specifics
• Conditional Formatting
• Filtering Tools
• Lookups
• Trends
4. Getting the Right Numbers
• Fixing Numbers
• Copying Formulas
• Multi-cell Arrays
• Single-cell Arrays
• Date Manipulation
• Time Manipulation
Module 3 - Plotting Data (450 slides)

1. Basic Techniques

• Fill Handle
• Relative vs. Absolute
• Range Names
• Nested Functions
2. Graph Basics
• Types of Graphs
• Source Data
• Combining Types
• Changing Locations
• Templates and Defaults
3. Axis Issues
• Scales
• More Axes
4. Bars and Error Bars
• Standard Deviations
• Residuals and More
5. Graph Markers
• Line Markers
• Interpolation
• Formulas
Module 4 - Statistical Analysis (450 slides)

1. Basic Techniques

• Fill Handle
• Relative vs. Absolute
• Range Names
• Nested Functions
2. Statistical Distributions
• Why Statistics
• Types of Distributions
• Simulating Distributions
• Sampling Techniques
• Some Conditions
3. Estimating Margins
• Margins of Means
• Margins of Proportions
4. Testing for Significance
• Significant Means
• Significant Proportions
• Significant Frequencies
5. Alternatives
• Chi-Squared Test
• Analysis of Variance

An Incredible Bargain!
Compare this course to anything else. You could visit a training center at a local computer chain and pay \$225 for a one-day course. Once that course is over, it is over. With the CD-ROM, you can play the course over and over, reviewing just the items that you need to review. Rather than be out of the office for an entire day, you can insert the CD and get training on a certain section on an as-needed basis. Pass the CD around your department and train everyone for one low price. With 1800 slides, this course runs circles around any other training.

Dr. Gerard M. Verschuuren is a Microsoft Certified Professional specialized in VB, VBA, and VB.NET. He is the author of many textbooks and has more than 25 years of experience in teaching at colleges and corporations. He holds master's degrees in Biology and in Philosophy, plus a Doctorate in the Philosophy of Science from Universities in Europe. He is author of Excel 2007 Expert CD-ROM, Excel 2007 for Scientists CD-ROM , Slide Your Way Through Excel VBA, Excel for Scientists, and Join the Excellers League CD-ROM.

Product Details
CD-ROM: 1800 Slides
ISBN 978-1-932802-31-3
System Requirements: PowerPoint 2007
Publisher: Holy Macro! Books;
Price: \$99

If installing in Vista, read this note.

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.