Spreadsheet Tools for Engineers Using Excel ® 2007

Edition: 1st
Format: Paperback
Pub. Date: 2009-01-22
Publisher(s): McGraw-Hill Education
  • Free Shipping Icon

    Free Shipping on all Orders Over $35!*

    *excludes Marketplace items.

  • Buyback Icon We Buy This Book Back!
    In-Store Credit: $1.05
    Check/Direct Deposit: $1.00
List Price: $74.14

Buy New

Usually Ships in 5-7 Business Days

Buy Used

In Stock

Rent Book

Select for Price
There was a problem. Please try again later.

Rent Digital

Online: 180 Days access
Downloadable: 180 Days
Online: 365 Days access
Downloadable: 365 Days
Online: 1825 Days access
Downloadable: Lifetime Access

This item is being sold by an Individual Seller and will not ship from the Online Bookstore's warehouse. The Seller must confirm the order within two business days. If the Seller refuses to sell or fails to confirm within this time frame, then the order is cancelled.

Please be sure to read the Description offered by the Seller.


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.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.