Amazon no longer offers textbook rentals. We do!

Spreadsheet Tools for Engineers Using Excel ® 2007

by: Gottfried, Byron

Spreadsheet Tools for Engineers Using Excel ® 2007

by: Gottfried, Byron

ISBN 13:
9780073385860
ISBN 10:
0073385867
Edition: 1st
Format: Paperback
Copyright: 01/22/2009
Publisher: McGraw-Hill Education

Rent From $19.82

Used From $9.30

New From $71.56

List Price $74.14 Save

Rent $19.82

TERM	PRICE	DUE
SEMESTER	$22.02	Aug 02
QUARTER	$20.92	Jul 18
SHORT TERM	$19.82	Jun 07

Added Benefits of Renting

Free Shipping Both Ways
Highlight/Take Notes Like You Own It
Purchase/Extend Before Due Date

Add to Cart

List Price $74.14 Save $64.84

Used $9.30

In Stock Usually Ships in 24 Hours.

We Buy This Book Back!

Included with your book

Free Shipping On Every Order

Add to Cart

List Price $74.14 Save $2.58

New $71.56

Usually Ships in 3-4 Business Days

We Buy This Book Back!

Included with your book

Free Shipping On Every Order

Add to Cart

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

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

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.

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.

Amazon no longer offers textbook rentals. We do!

Spreadsheet Tools for Engineers Using Excel ® 2007

Spreadsheet Tools for Engineers Using Excel ® 2007

9780073385860

0073385867

Summary

Table of Contents

Supplemental Materials

Write a Review