A Guide to Microsoft Excel 2013 for Scientists and Engineers
Auteur : Liengme Bernard
Completely updated guide for students, scientists and engineers who want to use Microsoft Excel 2013 to its full potential. Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data.
2. Basic Operations
3. Printing in Excel
4. Using Functions
5. Decision Functions
6. Data Mining
7. Charting
8. Regression Analysis
9. VBA User-Defined Functions
10. VBA Subroutines
11. Modeling I
12. Using Solver
13. Numerical Integration
14. Differential Equations
15. Modeling II
16. Statistics for Experimenters
Undergraduate science and engineering students; professional scientists and engineers
- Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with the new Microsoft Office release of Excel 2013
- Features of Excel 2013 are illustrated through a wide variety of examples based in technical contexts, demonstrating the use of the program for analysis and presentation of experimental results
New to this edition:
- The Backstage is introduced (a new Office 2013 feature); all the ‘external’ operations like Save, Print etc. are now in one place
- The chapter on charting is totally revised and updated – Excel 2013 differs greatly from earlier versions
- Includes many new end-of-chapter problems
- Most chapters have been edited to improve readability
Date de parution : 03-2015
Ouvrage de 382 p.
19x23.3 cm
Thèmes d’A Guide to Microsoft Excel 2013 for Scientists and Engineers :
Mots-clés :
basic operations; quick-access toolbar; worksheet; printing in Excel; functions; spreadsheets; formulae; autosum tool; trigonometry functions; exponential functions; financial functions; Boolean functions; conditional summing; quadratic equation solver; curve-fitting; macros; data mining; pivot tables; charting; regression analysis; Excel Solver; differential equations; visual basic editor; VBA functions; Monte Carlo techniques; Euler's method; Runge-Kutta method; second-order equations