Spreadsheet Tools for Engineers Using Excel ® 2007
by Gottfried, ByronEdition: 1st
Format: Paperback
Pub. Date: 2009-01-22
Publisher(s): McGraw-Hill Education
Other versions by this Author
-
Free Shipping on All Orders!
*excludes Marketplace items.
-
We Buy This Book Back!
List Price: $74.14
Buy New
Usually Ships in 5-7 Business Days
$69.63
Buy Used
In Stock
$1.33
Rent Book
Select for Price
Rent Digital
$31.29
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
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 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. |
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.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
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.