9780073385860

Spreadsheet Tools for Engineers Using Excel 2007

by
  • ISBN13:

    9780073385860

  • ISBN10:

    0073385867

  • Edition: 1st
  • Format: Paperback
  • Copyright: 1/22/2009
  • Publisher: McGraw-Hill Education

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

Purchase Benefits

  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
  • We Buy This Book Back!
    In-Store Credit: $26.25
    Check/Direct Deposit: $25.00

Supplemental Materials

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 access cards, study guides, lab manuals, CDs, etc.
  • The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

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.

Rewards Program

Write a Review