Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
Purchase Benefits
What is included with this book?
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. |