CART

(0) items

Spreadsheet Tools for Engineers Using Excel ® 2007,9780073385860
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

Spreadsheet Tools for Engineers Using Excel ® 2007

by
Edition:
1st
ISBN13:

9780073385860

ISBN10:
0073385867
Format:
Paperback
Pub. Date:
1/22/2009
Publisher(s):
McGraw-Hill Science/Engineering/Math
Includes 2-weeks free access to
step-by-step solutions for this book.
Step-by-Step solutions are actual worked out problems to the questions at the end of each chapter that help you understand your homework and study for your exams. Chegg and eCampus are providing you two weeks absolutely free. 81% of students said using Step-by-Step solutions prepared them for their exams.
List Price: $101.59

Rent Textbook

(Recommended)
 
Term
Due
Price
$30.24

Hurry!

Only one copy
in stock at this price.

Buy Used Textbook

In Stock Usually Ships in 24 Hours.
U9780073385860
$60.95

Buy New Textbook

Usually Ships in 3-4 Business Days
N9780073385860
$99.05

eTextbook


 
Duration
Price
$65.02
More New and Used
from Private Sellers
Starting at $100.97
See Prices

Questions About This Book?

Why should I rent this book?
Renting is easy, fast, and cheap! Renting from eCampus.com 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 inclue 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.

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.


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