Liengme's Guide to Excel 2016 for Scientists and Engineers

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. 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.

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