Skip to main content
Spreadsheet Tools for Engineers Using Excel

ISBN10: 1259875962 | ISBN13: 9781259875960

Spreadsheet Tools for Engineers Using Excel
ISBN10: 1259875962
ISBN13: 9781259875960
By Byron Gottfried

* The estimated amount of time this product will be on the market is based on a number of factors, including faculty input to instructional design and the prior revision cycle and updates to academic research-which typically results in a revision cycle ranging from every two to four years for this product. Pricing subject to change at any time.

Instructor Information

Quick Actions (Only for Validated Instructor Accounts):

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

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

About the Author

Byron Gottfried

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.

Need support?   We're here to help - Get real-world support and resources every step of the way.

Top