Liengme's Guide to Excel 2016 for Scientists and Engineers
(Windows and Mac)

The indispensable guide for all scientists, engineers and students who wish to use Microsoft Excel to its full potential, now updated for Excel 2016

Bernard Liengme (Author), Keith Hekman (Author)

9780128182499, Elsevier Science

Paperback, published 14 August 2019

414 pages, Approx. 265 illustrations
23.4 x 19 x 2.6 cm, 0.84 kg

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.

1. Welcome to Microsoft Excel 20162. Basic Operations3. Printing in Excel4. Using Functions5. Decision Functions6. Data Mining7. Charting8. Regression Analysis9. VBA User-Defined Functions10. VBA Subroutines11. Modeling I12. Using Solver13. Numerical Integration14. Differential Equations15. Modeling II16. Statistics for Experimenters

Subject Areas: Computer science [UY], Enterprise software [UFL], Mechanical engineering [TGB], Maths for engineers [TBJ], Technology: general issues [TB]