Excel 2013 for Scientists, Revised and Expanded, Third Edition

  • 3h 20m
  • Gerard M. Verschuuren
  • Tickling Keys
  • 2014

With examples from the world of science, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Scientists 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 and it is updated to include all new functions in Excel 2010 and Excel 2013.

About the Author

Dr. Gerard M. Verschuuren is a Microsoft Certified Professional specialized in VB, VBA, VBScript, VB.NET, and C#-NET. He has more than 25 years of experience in teaching at colleges and corporations.

He holds master's degrees in biology (human genetics) and philosophy, as well as a doctorate in the philosophy of science from universities in Europe.

He is the author of From VBA to VSTO (2006, Holy Macro! Books), and the author of Excel Simulations (2013, Holy Macro! Books).

He is also the author behind the Visual Learning series, which includes:

  • Your Access to the World (2004)
  • Access 2007 VBA (2008)
  • Visual C# Express DVD (2008)
  • Excel 2007 Expert (2007)
  • Excel VBA 2007 (2008)

Excel 2013 For Scientists, by Dr. Gerard Verschuuren

Excel Simulations: Solve Problems with Excel, by Dr. Gerard Verschuuren

In this Book

  • Navigation in Excel
  • The Fill Handle
  • Relative vs. Absolute Cell References
  • Range Names
  • Nested Functions
  • Exercises
  • 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
  • Exercises
  • Types of Charts and Graphs
  • A Chart's or Graph's Data Source
  • Combining Chart Types
  • Changing Graph Locations
  • Templates and Defaults
  • Axis Scales
  • More Axes
  • Error Bars
  • More Bars
  • Line Markers
  • Interpolation
  • Graph Formulas
  • Exercises
  • 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
  • Exercises
  • Why Statistics?
  • Types of Distributions
  • Simulating Distributions
  • Sampling Techniques
  • Test Conditions and Outliers
  • Estimating Means
  • Estimating Proportions
  • Significant Means
  • Significant Proportions
  • Significant Frequencies
  • More on Chi-Squared Testing and Box-Cox Power
  • Analysis of Variance
  • Exercises