![Liengme's Guide to Excel 2016 for Scientists and Engineers](https://secure-ecsd.elsevier.com/covers/80/Tango2/large/9780128182499.jpg)
Book Companion
Liengme's Guide to Excel 2016 for Scientists and Engineers
Edition 1
Welcome to our companion site for Liengme's Guide to Excel 2016 for Scientists and Engineers (Windows and Mac).
Welcome to our companion site for Liengme's Guide to Excel 2016 for Scientists and Engineers (Windows and Mac).
Resources
Downloadable content
Chapter 05
Chapter 06
Chapter 07
Chapter 10
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.
About the Authors
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.
Click the links above for Excel documents and other data for the chapters listed.
Click the links below to access supporting videos,
Chapter 01
Exercise 1: Customizing the QATopens in new tab/window
Exercise 2: Customizing the Ribbon Controlopens in new tab/window
Welcome to Excel 2016opens in new tab/window
Chapter 02
Copying Formulas What Happens to Referencesopens in new tab/window
Exercise 1: Simple Arithmeticopens in new tab/window
Exercise 2: The Mathematical Operatorsopens in new tab/window
Exercise 3: Formatting (Displayed and Stored Values)opens in new tab/window
Exercise 4: Working with Fractionsopens in new tab/window
Exercise 5: A Practical Worksheetopens in new tab/window
Exercise 6: Another Practical Exampleopens in new tab/window
Exercise 7: The Evaluate Formula Toolopens in new tab/window
Chapter 03
Exercise 1: Quick Print and Print Previewopens in new tab/window
Exercise 2: The Page Layout Tabopens in new tab/window
Exercise 3: Headeropens in new tab/window
Exercise 4: Documentation and Printing Formulasopens in new tab/window
Chapter 04
Exercise 1: The AutoSum Toolopens in new tab/window
Exercise 2: Computing a Weighted Average and Exerciseopens in new tab/window
Exercise 4: Trigonometry Functionsopens in new tab/window
Exercise 5: Exponential Functionsopens in new tab/window
Exercise 6: The ROUND,ROUNDUP and ROUNDDOWN Functionsopens in new tab/window
Exercise 7: Matrix Functionsopens in new tab/window
Exercise 8: Solving Systems of Equationsopens in new tab/window
Exercise 9: Borrower Bewareopens in new tab/window
Chapter 05
Exercise 1: Boolean Functionsopens in new tab/window
Exercise 2: Practical Exampleopens in new tab/window
Exercise 3: Resistors Revisitedopens in new tab/window
Exercise 5: Protecting a Worksheetopens in new tab/window
Exercise 6: A Simple Lookupopens in new tab/window
Exercise 7: A Two-Valued Lookupopens in new tab/window
Exercise 8: Conditional Arithmeticopens in new tab/window
Exercise 9: Array Formulasopens in new tab/window
Exercise 10: The SUMPRODUCT functionopens in new tab/window
Exercise 11: Conditional Formattingopens in new tab/window
Chapter 06
PivotTableopens in new tab/window
Chapter 07
Exercise 1: An XY Chartopens in new tab/window
Exercise 2: Plotting Functions,Changing the positionopens in new tab/window
Exercise 3: Adding and Deleting Data Seriesopens in new tab/window
Exercise 4: XY Chart with Two Y-axesopens in new tab/window
Exercise 5: Chart with Control Linesopens in new tab/window
Exercise 6: Large Numbers and Log Scalesopens in new tab/window
Exercise 7: Error Barsopens in new tab/window
Exercise 8: Plotting Parametric Equationsopens in new tab/window
Exercise 9: Polar (Radar) Chartopens in new tab/window
Exercise 10: Surface Chartsopens in new tab/window
Exercise 11: Combination Chartsopens in new tab/window
Exercise 12: Bar Chartsopens in new tab/window
Chapter 08
Exercise 1: Trendline, SLOPE, and INTERCEPTopens in new tab/window
Exercise 2: Interpolation and FORECASTopens in new tab/window
Exercise 3: The LINEST Functionopens in new tab/window
Exercise 4: Fixed Interceptopens in new tab/window
Exercise 5: Multi-linear Regressionopens in new tab/window
Exercise 6: A Polynomial Fitopens in new tab/window
Exercise 7: A Logarithmic Fit (LOGEST)opens in new tab/window
Exercise 8: The FORECAST, TREND and GROWTH functionsopens in new tab/window
Shop for books, journals, and more.
Discover over 2,960 journals, 48,300 books, and many iconic reference works.