Spreadsheet Tools for Engineers Using Excel ® 2007

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780073385860 | 0073385867
Cover: Paperback
Copyright: 1/22/2009

Rent

(Recommended)

$24.48

Term

Due

Price

Semester

Jul 9

$25.77

Quarter

May 29

$24.48

Short Term

Apr 30

$23.20

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping bag.
Buy Used

In Stock Usually Ships in 24 Hours.

$2.16
eBook

Available Instantly

Online: 180 Days

Downloadable: 1825 Days

*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.

$31.29*

Through previous versions, this practical text has found a permanent spot in many 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 Excel 2007, this version of Spreadsheet Tools for Engineers provides engineering students with a strong foundation in problem solving as well as specific instructions in the use of Excel 2007.

Engineering Analysis and Spreadsheets	p. 1
A Spreadsheet Overview	p. 1
General Problem-Solving Techniques	p. 6
Applicable Engineering Fundamentals	p. 7
Mathematical Solution Procedures	p. 14
Creating an Excel Worksheet	p. 17
Entering and Leaving Excel	p. 18
Getting Help	p. 21
Moving around the Worksheet	p. 24
Entering Data	p. 26
Correcting Errors	p. 30
Using Formulas	p. 31
Using Functions	p. 45
Saving and Retrieving a Worksheet	p. 52
Printing a Worksheet	p. 55
Editing an Excel Worksheet	p. 62
Editing the Worksheet	p. 62
Undoing Changes	p. 68
Copying and Moving Formulas	p. 68
Inserting and Deleting Rows and Columns	p. 70
Inserting and Deleting Individual Cells	p. 73
Smart Tags	p. 75
Adjusting Column Widths	p. 77
Formatting Data Items	p. 78
Editing Shortcuts	p. 80
Hyperlinks	p. 80
Displaying Cell Formulas	p. 84
Closing Remarks	p. 86
Making Logical Decisions (IF-THEN-ELSE)	p. 87
Logical (Boolean) Expressions	p. 87
The IF Function	p. 88
Nested IF Functions	p. 89
Graphing Data	p. 97
Characteristics of a Good Graph	p. 97
Creating a Graph in Excel	p. 100
X-Y Graphs (Excel Scatter Charts, or XY Charts)	p. 102
Adding Data to an Existing Data Set	p. 107
Semi-Log Graphs	p. 115
Log-Log Graphs	p. 120
Line Graphs (Excel Line Charts)	p. 126
Bar Graphs (Excel Column Charts)	p. 130
Pie Charts	p. 135
Closing Remarks	p. 140
Analyzing Data Statistically	p. 141
Data Characteristics	p. 141
Histograms	p. 151
Cumulative Distributions	p. 160
Fitting Equations to Data	p. 169
Linear Interpolation	p. 170
The Method of Least Squares	p. 176
Fitting a Straight Line to a Set of Data	p. 178
Least Squares Curve Fitting in Excel	p. 183
Fitting Other Functions to a Set of Data	p. 192
Selecting the Best Function for a Given Data Set	p. 207
Sorting and Filtering Data	p. 225
Creating a List in Excel	p. 226
Sorting Data in Excel	p. 227
Filtering Data in Excel	p. 237
Tables	p. 244
Pivot Tables	p. 245
Pivot Charts	p. 255
Transferring Data	p. 258
Importing Data from a Text File	p. 258
Exporting Data to a Text File	p. 264
Transferring HTML Data	p. 270
Transferring Data to Microsoft Word	p. 273
Transferring Data to Microsoft PowerPoint	p. 286
Converting Units	p. 295
Simple Conversions	p. 295
Simple Conversions in Excel	p. 296
Converting Temperatures	p. 301
Complex Conversions	p. 303
Complex Conversions in Excel	p. 304
Solving Single Equations	p. 309
Characteristics of Nonlinear Algebraic Equations	p. 310
Solving Equations Graphically	p. 312
Solving Equations Numerically	p. 314
Solving Equations in Excel Using Goal Seek	p. 321
Solving Equations in Excel Using Solver	p. 330
Solving Simultaneous Equations	p. 340
Matrix Notation	p. 341
Matrix Operations in Excel	p. 351
Solving Simultaneous Equations in Excel Using Matrix Inversion	p. 353
Solving Simultaneous Equations in Excel Using Solver	p. 357
Evaluating Integrals	p. 373
The Trapezoidal Rule	p. 374
Simpson's Rule	p. 387
Integrating Measured Data	p. 396
Creating and Executing Macros and Functions	p. 402
Recording a Macro	p. 402
Executing a Macro	p. 404
Cell Addressing within a Macro	p. 408
Saving a Macro	p. 412
Viewing a Macro in VBA	p. 414
Editing a Macro in VBA	p. 418
User-Defined Functions	p. 424
Comparing Economic Alternatives	p. 434
Compound Interest	p. 434
The Time Value of Money	p. 447
Uniform, Multipayment Cash Flows	p. 449
Irregular Cash Flows	p. 457
Internal Rate of Return	p. 464
Finding Optimum Solutions	p. 473
Optimization Problem Characteristics	p. 474
Solving Optimization Problems in Excel	p. 486
Appendix	p. 504
Index	p. 507
Table of Contents provided by Ingram. All Rights Reserved.

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Spreadsheet Tools for Engineers Using Excel ® 2007

Summary

Table of Contents

Supplemental Materials