ISE Spreadsheet Tools for Engineers Using Excel
1260085074
·
9781260085075
Release date: January 1, 2024
This practical text is a perfect fit for introductory engineering courses as it successfully combines an introduction to Excel fundamentals with a clear presentation on how Excel can be used to solve common engineering problems. Updated to ensure com…
Read More
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
This practical text is a perfect fit for introductory engineering courses as it successfully combines 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 beginner engineering students with a strong foundation in problem solving - with 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 modern 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.
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 modern 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.
Up-to-date and comprehensive text that conforms to the new Excel 2016 user interface.
Supplementary problems have been added to the book.
Dedicated website includes spreadsheet files for all of the examples and problem setup files for some of the lengthier problems. The problem setup files allow you to avoid errors and tedious typing when constructing the problem solutions. These files are available for download free of charge. In addition, problem solutions are available for qualified instructors.
For Connect? users, the ReadAnywhere App is a free, downloadable app available on iOS and Android mobile devices. It gives students mobile freedom to access their eBook anywhere, even offline, on their smartphone or tablet. Once chapters are downloaded, students can use the same tools that are available in the eBook. Any notes or highlights they make in the eBook will sync across platforms. Visit https://www.mheducation.com/highered/explore/readanywhere.html for more information.
The chapter on macros has been expanded to include material on user-defined functions and VBA.
Includes a brief appendix summarizing Excel functions commonly used for engineering applications.
Descriptive captions accompany all figures and tables.
To purchase an electronic eBook version of this title visit www.CourseSmart.com (ISBN 9780077342418, or www.VitalSource.com (ISBN 9780077342425).
.