Liengme's Guide to Excel 2016 for Scientists and Engineers

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 on a PC or a Mac. 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 the functions of Excel, guiding the reader from basic principles to more complicated areas, such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and how to present quantitative data.

• 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
• Presents the features of Excel 2016 that are illustrated through a wide variety of examples based in technical contexts
• Demonstrates the differences between the PC and Mac versions of Excel
• Includes many new end-of-chapter problems at varying levels of difficulty

Undergraduate science and engineering students; professional scientists and engineers

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