Liengme's Guide to Excel 2016 for Scientists and Engineers
1st Edition
(Windows and Mac)
Description
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.
Key Features
- 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
Readership
Undergraduate science and engineering students; professional scientists and engineers
Table of Contents
- 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
Details
- No. of pages:
- 414
- Language:
- English
- Copyright:
- © Academic Press 2020
- Published:
- 22nd August 2019
- Imprint:
- Academic Press
- Paperback ISBN:
- 9780128182499
About the Author
Bernard Liengme
Bernard Liengme attended Imperial College in London and received a BSc & PhD in Chemistry. He also received post-docs at Carnegie-Mellon University in Pittsburg and the University of British Columbia. He has conducted extensive reseach in surface chemistry and Mossbauer Effect. He has been at St Francis Xavier University in Canada since 1968 as professor, Associate Dean and Registrar as well as teaching chemistry and computer science.
Affiliations and Expertise
St Francis Xavier University, Antigonish, NS, Canada
Keith Hekman
Dr. Hekman received his BSE degree from Calvin College and received his Master's and Ph.D. in Mechanical Engineering from the Georgia Institute of Technology. Currently he is an Associate Professor of Mechanical Engineering at Gordon and Jill Bourns College of Engineering at California Baptist University where he has taught a freshman Excel and AutoCAD course for the past 10 years. Prior to coming to CBU, he taught at Calvin College and the American University of Cairo.
Affiliations and Expertise
Gordon and Jill Bourns College of Engineering, California Baptist University, Riverside, CA, USA