 |
|
 |
|
 |
 |
 |
 |
 |
 |
|
 |
|
Key Features
- Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with Microsoft Office release of Excel 2016.
- Features of Excel 2016 are illustrated through a wide variety of examples based on technical contexts, demonstrating the use of the program for analysis and presentation of experimental results.
- Where appropriate, demonstrates the differences between the PC and Mac versions of Excel.
- Includes many new end-of-chapter problems at varying levels of difficulty.
|
About the Book
Liengme’s Guide to Excel 2016 for Scientists and Engineers is a completely updated guide for students, scientists, and engineers who want to use Microsoft Excel 2016 to its full potential, whether you’re using a PC or a Mac. 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. Approx. 265 illustrations
Readership
Undergraduate science and engineering students; professional scientists and engineers
Content 1. Welcome to Microsoft Excel 2016 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
|
|
|
|
|