Have a personal or library account? Click to login
Excel 2013 for Scientists Cover

Excel 2013 for Scientists

Master advanced Excel techniques and data analysis tailored for scientific research and workflows

Paid access
|Dec 2024
Product purchase options

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
PDF ISBN: 978-1-83702-972-3
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2024
Language: English
Pages: 321