(0) items

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

Spreadsheet Tools for Engineers Using Excel 2007



Pub. Date:
McGraw-Hill Education
List Price: $119.14

Rent Textbook


Buy Used Textbook

In Stock Usually Ships in 24 Hours.

Buy New Textbook

Usually Ships in 3-4 Business Days


More New and Used
from Private Sellers
Starting at $44.76

Questions About This Book?

Why should I rent this book?

Renting is easy, fast, and cheap! Renting from can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.

How do rental returns work?

Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!

What version or edition is this?

This is the 1st edition with a publication date of 1/22/2009.

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
  • The Used copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically only the book itself is included.


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.

Table of Contents

Engineering Analysis and Spreadsheetsp. 1
A Spreadsheet Overviewp. 1
General Problem-Solving Techniquesp. 6
Applicable Engineering Fundamentalsp. 7
Mathematical Solution Proceduresp. 14
Creating an Excel Worksheetp. 17
Entering and Leaving Excelp. 18
Getting Helpp. 21
Moving around the Worksheetp. 24
Entering Datap. 26
Correcting Errorsp. 30
Using Formulasp. 31
Using Functionsp. 45
Saving and Retrieving a Worksheetp. 52
Printing a Worksheetp. 55
Editing an Excel Worksheetp. 62
Editing the Worksheetp. 62
Undoing Changesp. 68
Copying and Moving Formulasp. 68
Inserting and Deleting Rows and Columnsp. 70
Inserting and Deleting Individual Cellsp. 73
Smart Tagsp. 75
Adjusting Column Widthsp. 77
Formatting Data Itemsp. 78
Editing Shortcutsp. 80
Hyperlinksp. 80
Displaying Cell Formulasp. 84
Closing Remarksp. 86
Making Logical Decisions (IF-THEN-ELSE)p. 87
Logical (Boolean) Expressionsp. 87
The IF Functionp. 88
Nested IF Functionsp. 89
Graphing Datap. 97
Characteristics of a Good Graphp. 97
Creating a Graph in Excelp. 100
X-Y Graphs (Excel Scatter Charts, or XY Charts)p. 102
Adding Data to an Existing Data Setp. 107
Semi-Log Graphsp. 115
Log-Log Graphsp. 120
Line Graphs (Excel Line Charts)p. 126
Bar Graphs (Excel Column Charts)p. 130
Pie Chartsp. 135
Closing Remarksp. 140
Analyzing Data Statisticallyp. 141
Data Characteristicsp. 141
Histogramsp. 151
Cumulative Distributionsp. 160
Fitting Equations to Datap. 169
Linear Interpolationp. 170
The Method of Least Squaresp. 176
Fitting a Straight Line to a Set of Datap. 178
Least Squares Curve Fitting in Excelp. 183
Fitting Other Functions to a Set of Datap. 192
Selecting the Best Function for a Given Data Setp. 207
Sorting and Filtering Datap. 225
Creating a List in Excelp. 226
Sorting Data in Excelp. 227
Filtering Data in Excelp. 237
Tablesp. 244
Pivot Tablesp. 245
Pivot Chartsp. 255
Transferring Datap. 258
Importing Data from a Text Filep. 258
Exporting Data to a Text Filep. 264
Transferring HTML Datap. 270
Transferring Data to Microsoft Wordp. 273
Transferring Data to Microsoft PowerPointp. 286
Converting Unitsp. 295
Simple Conversionsp. 295
Simple Conversions in Excelp. 296
Converting Temperaturesp. 301
Complex Conversionsp. 303
Complex Conversions in Excelp. 304
Solving Single Equationsp. 309
Characteristics of Nonlinear Algebraic Equationsp. 310
Solving Equations Graphicallyp. 312
Solving Equations Numericallyp. 314
Solving Equations in Excel Using Goal Seekp. 321
Solving Equations in Excel Using Solverp. 330
Solving Simultaneous Equationsp. 340
Matrix Notationp. 341
Matrix Operations in Excelp. 351
Solving Simultaneous Equations in Excel Using Matrix Inversionp. 353
Solving Simultaneous Equations in Excel Using Solverp. 357
Evaluating Integralsp. 373
The Trapezoidal Rulep. 374
Simpson's Rulep. 387
Integrating Measured Datap. 396
Creating and Executing Macros and Functionsp. 402
Recording a Macrop. 402
Executing a Macrop. 404
Cell Addressing within a Macrop. 408
Saving a Macrop. 412
Viewing a Macro in VBAp. 414
Editing a Macro in VBAp. 418
User-Defined Functionsp. 424
Comparing Economic Alternativesp. 434
Compound Interestp. 434
The Time Value of Moneyp. 447
Uniform, Multipayment Cash Flowsp. 449
Irregular Cash Flowsp. 457
Internal Rate of Returnp. 464
Finding Optimum Solutionsp. 473
Optimization Problem Characteristicsp. 474
Solving Optimization Problems in Excelp. 486
Appendixp. 504
Indexp. 507
Table of Contents provided by Ingram. All Rights Reserved.

Please wait while the item is added to your cart...