Gottfried B.S. Spreadsheet Tools for Engineers Using Excel 2007

New York, USA, The McGraw-Hill Companies, Inc., 2010. — 529 p. — ISBN: 9780073385860.Excel, developed by the Microsoft Corporation, is the world’s most widely used spreadsheet program. It is most frequently used for budgeting, financial planning, and record-keeping activities. However, it also includes special features for solving many of the problems that typically arise in engineering analysis, such as solving algebraic equations, fitting curves through data sets, analyzing data statistically, carrying out studies in engineering economic analysis, and solving complicated optimization problems. Excel can also be used to solve other types of technical problems, such as the evaluation of integrals and the solution of interpolation problems, even though it lacks special features that automate these tasks. It is especially well suited for displaying data in various graphical formats. Armed with these tools, Excel thus becomes the modern-day equivalent of the engineer’s classical sliderule.Engineering Analysis and Spreadsheets
Creating an Excel Worksheet
Editing an Excel Worksheet
Making Logical Decisions (IF-THEN-ELSE)
Graphing Data
Analyzing Data Statistically
Fitting Equations to Data
Sorting and Filtering Data
Transferring Data
Converting Units
Solving Single Equations
Solving Simultaneous Equations
Evaluating Integrals
Creating and Executing Macros and Functions
Comparing Economic Alternatives
Finding Optimum Solutions