Loose Leaf for Spreadsheet Tools for Engineers Using Excel

by Byron S. Gottfried

Overview

This practical text is a perfect fit for introductory engineering courses by successfully combining an introduction to Excel fundamentals with a clear presentation on how Excel can be used to solve common engineering problems. Updated to ensure compatibility with Excel 2016, Spreadsheet Tools provides beginning engineering students with a strong foundation in problem solving using Excel as the modern day equivalent of the slide rule.


The book is intended primarily as a textbook for use in introductory engineering courses, although it may also be of interest to more advanced students and many practicing engineers.


The author provides plenty of background information on technical terms, and provides numerous examples illustrating both traditional and spreadsheet solutions for a variety of engineering problems. The first three chapters introduce the basics of problem solving and Excel fundamentals. Beyond that, the chapters are largely independent of one another. Topics covered include graphing data, unit conversions, data analysis, interpolation and curve fitting, solving equations, evaluating integrals, creating macros, and comparing economic alternatives.

Product Details

ISBN-13:	9781260486070
Publisher:	McGraw Hill LLC
Publication date:	02/14/2018
Edition description:	4th ed.
Pages:	544
Product dimensions:	7.00(w) x 9.10(h) x 0.80(d)
Age Range:	18 Years

About the Author

Byron S. Gottfried is a Professor of Industrial Engineering and Academic Director of the Freshman Engineering Program at the University of Pittsburgh. He has written eleven college textbooks, including Schaum's Outline of Programming with Basic.

Table of Contents

1. Engineering Analysis and Spreadsheets

2. Creating an Excel Worksheet

3. Editing an Excel Worksheet

4. Making Logical Decisions (IF-THEN-ELSE)

5. Graphing Data

6. Analyzing Data Statisically

7. Fitting Equations to Data

8. Sorting and Filtering Data

9. Transferring Data

10. Converting Units

11. Solving Single Equations

12. Solving Simultaneous Equations

13. Evaluating Integrals

14. Creating and Executing Macros and Functions

15. Comparing Economic Alternatives

16. Finding Optimum Solutions

Appendix

Index