Excel 2013 For Scientists CD
September 2013
Product Details
- 1900 Pages
- Publisher: Holy Macro! Books
- ISBN: 978-1-61547-024-2
Finally - visual training written for scientists by a scientist. Are you tired of trying to learn Excel with examples from accounting? With over 1900 slides, this self-paced training package is loaded with informative samples from the world of science plus frequent self-tests to enhance your learning. Learn the pitfalls of Excel for scientists and how to work around them.
-
Module 1: Data Analysis
- Summaries
- Lookups and Trends
- Filtering Tools
- Getting the Right Numbers
- Complex Formulas
-
Module 2: Plotting Data
- Chart Basics
- Axis Issues
- Bars and Error Bars
- Interpolation
- Graph Formulas
-
Module 3: Curve Fitting
- Linear & Non-Linear
- Sigmoid/Logistics Curves
- The Best Fit Test
- Correlations
- Solving Equations
-
Module 4: Statistical Analysis
- Types of Distributions
- Sampling Techniques
- Estimating Margins
- Testing for Significance
- ANOVA and Chi-Squared
