
Spreadsheet Tools for Engineers Using Excel ® 2007
by Gottfried, Byron-
Free Shipping on all Orders Over $35!*
*excludes Marketplace items.
-
We Buy This Book Back!
Buy New
Buy Used
Rent Book
Rent Digital
Downloadable: 180 Days
Downloadable: 365 Days
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.
Summary
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.
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.