Liengme's Guide to Excel 2016 for Scientists and Engineers

Liengme's Guide to Excel 2016 for Scientists and Engineers

(Windows and Mac)

1st Edition - August 14, 2019

Write a review

  • Authors: Bernard Liengme, Keith Hekman
  • Paperback ISBN: 9780128182499
  • eBook ISBN: 9780128182505

Purchase options

Purchase options
DRM-free (PDF, EPub)
Sales tax will be calculated at check-out

Institutional Subscription

Free Global Shipping
No minimum order


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.

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.


Undergraduate science and engineering students; professional scientists and engineers

Table of Contents

  • 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

Product details

  • No. of pages: 414
  • Language: English
  • Copyright: © Academic Press 2019
  • Published: August 14, 2019
  • Imprint: Academic Press
  • Paperback ISBN: 9780128182499
  • eBook ISBN: 9780128182505

About the Authors

Bernard Liengme

Dr. Bernard Liengme attended Imperial College in London and received a BSc & Ph.D. in Chemistry. He also received post-docs at Carnegie-Mellon University in Pittsburgh and the University of British Columbia. He has conducted extensive research 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. He is the author of four previous versions of “A Guide to Microsoft Excel for Scientists and Engineers,” most recently the Excel 2013 version.

Affiliations and Expertise

St Francis Xavier University, Antigonish, NS, Canada

Keith Hekman

Dr. Keith 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 a 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 11 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

Ratings and Reviews

Write a review

Latest reviews

(Total rating for all reviews)

  • LesSkinner Fri Apr 03 2020

    Liengme's Guide to Excel 2016

    An excellent "how to" book using Excel 2016. Good examples and exercises in each subchapter. Starts with basics of Excel and goes through advanced features including the new ones added in this version of Excel. A good read and well worth the price.

  • Nicki D. Sun Mar 08 2020

    Excellent primer showing the power of MS Excel

    This is a really useful book, it is clearly laid out and sensibly structured. The authors do an excellent job of showing how useful MS Excel can be for much of the data analysis and modelling the engineers and scientist undertake.