Excel 2013 for Scientists

Table of Contents

1. Navigation in Excel
2. The Fill Handle
3. Relative vs. Absolute Cell References
4. Range Names
5. Nested Functions
6. Auto-numbering
7. Subtotals
8. Summary Functions
9. Unique Lists
10. Data Validation
11. Conditional Formatting
12. Filtering Tools
13. Lookups
14. Working with Trends
15. Fixing Numbers
16. Copying Formulas
17. Multi-cell Arrays
18. Single-cell Arrays
19. Date Manipulation
20. Time Manipulation
21. Types of Charts and Graphs
22. A Chart's or Graph's Data Source
23. Combining Chart Types
24. Changing Graph Locations
25. Templates and Defaults
26. Axis Scales
27. More Axes
28. Error Bars
29. More Bars
30. Line Markers
31. Interpolation
32. Graph Formulas
33. Linear Regression
34. Nonlinear Regression
35. Curve Fitting
36. Sigmoid Curves
37. Predictability
38. Correlation
39. Multiple Regression: Linear Estimates
40. Reiterations and Matrices
41. Solving Equations
42. What-If Controls
43. Syntax of Functions
44. Worksheet Functions
45. Why Statistics?
46. Types of Distributions
47. Simulating Distributions
48. Sampling Techniques
49. Test Conditions and Outliers
50. Estimating Means
51. Estimating Proportions
52. Significant Means
53. Significant Proportions
54. Significant Frequencies
55. More on Chi-Squared Testing and Box-Cox Power
56. Analysis of Variance