Excel 2013 for Scientists: Master advanced Excel techniques and data analysis tailored for scientific research and workflows
1146696075
Excel 2013 for Scientists: Master advanced Excel techniques and data analysis tailored for scientific research and workflows
14.99 In Stock
Excel 2013 for Scientists: Master advanced Excel techniques and data analysis tailored for scientific research and workflows

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

Excel 2013 for Scientists: Master advanced Excel techniques and data analysis tailored for scientific research and workflows
Add to Wishlist
Excel 2013 for Scientists: Master advanced Excel techniques and data analysis tailored for scientific research and workflows

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

Product Details

ISBN-13: 9781837029723
Publisher: Packt Publishing
Publication date: 12/12/2024
Sold by: Barnes & Noble
Format: eBook
Pages: 321
File size: 44 MB
Note: This product may take a few minutes to download.

About the Author

Holy Macro! Books has been providing top-quality books on Excel, Power Query, and Power BI since 2002. They have published over 100 titles by 30 authors, including numerous Microsoft MVPs.
Dr. Gerard Verschuuren is a Microsoft Certified Professional specializing in VB, VBA, and VB.NET. He is the principal of Genesis PC, where he teaches and advises on the use of curve-fitting software such as Excel and XLfit in data, regression, and statistical analyses. His clients include Abbott, Bose, IBM, Liberty Mutual, Massachusetts General Hospital, and Harvard University. He is the author of numerous computer programming books, including Excel 2007 VBA, From VBA to VSTO, Master the Web, and Slide Your Way Through Excel VBA. He lives in Atkinson, New Hampshire.

Table of Contents

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
From the B&N Reads Blog
Page 1 of

Customer Reviews