| Engineering Analysis and Spreadsheets | p. 1 |
| General Problem-Solving Techniques | p. 1 |
| Applicable Engineering Fundamentals | p. 3 |
| Mathematical Solution Procedures | p. 5 |
| The Role of Spreadsheets | p. 7 |
| Additional Reading | p. 12 |
| Excel Fundamentals | p. 13 |
| Entering and Leaving Excel | p. 14 |
| Moving around the Worksheet | p. 22 |
| Entering Data | p. 24 |
| Correcting Errors | p. 27 |
| Using Formulas | p. 28 |
| Using Functions | p. 38 |
| Editing the Worksheet | p. 42 |
| Saving and Retrieving the Worksheet | p. 61 |
| Printing the Worksheet | p. 61 |
| Displaying Cell Formulas | p. 64 |
| Recording and Running Macros | p. 65 |
| Closing Remarks | p. 70 |
| Additional Reading | p. 70 |
| Graphing Data | p. 71 |
| Creating a Graph in Excel | p. 71 |
| Bar Graphs (Excel Column Charts) | p. 73 |
| Line Graphs (Excel Line Charts) | p. 80 |
| X-Y Graphs (Excel XY Charts, or Scatter Charts) | p. 84 |
| Semi-Log Graphs | p. 93 |
| Log-Log Graphs | p. 98 |
| Pie Charts | p. 104 |
| Closing Remarks | p. 110 |
| Additional Reading | p. 110 |
| Converting Units | p. 111 |
| Simple Conversions | p. 111 |
| Simple Conversions in Excel | p. 112 |
| Complex Conversions | p. 116 |
| Complex Conversions in Excel | p. 117 |
| Additional Reading | p. 121 |
| Transferring Data | p. 122 |
| Importing Data from a Text File | p. 122 |
| Exporting Data to a Text File | p. 128 |
| Transferring HTML Data | p. 134 |
| Transferring a Worksheet to Microsoft Word | p. 137 |
| Transferring a Worksheet to Microsoft PowerPoint | p. 142 |
| Additional Reading | p. 147 |
| Analyzing Data | p. 148 |
| Data Characteristics | p. 148 |
| Histograms | p. 156 |
| Cumulative Distributions | p. 163 |
| Additional Reading | p. 171 |
| Organizing Data | p. 173 |
| Creating a List in Excel | p. 174 |
| Sorting Data in Excel | p. 177 |
| Retrieving (Filtering) Data in Excel | p. 180 |
| Pivot Tables | p. 187 |
| Additional Reading | p. 197 |
| Fitting Equations to Data | p. 198 |
| The Method of Least Squares | p. 199 |
| Fitting a Straight Line to a Set of Data | p. 200 |
| Derivation of the Least Squares Equations | p. 213 |
| Fitting Other Functions to a Set of Data | p. 214 |
| Selecting the Best Function for a Given Data Set | p. 229 |
| Additional Reading | p. 246 |
| Interpolating between Data Points | p. 247 |
| Linear Interpolation | p. 248 |
| Polynomial Interpolation Using Forward Differences | p. 254 |
| Polynomial Interpolation Using Backward Differences | p. 262 |
| Other Interpolation Techniques | p. 268 |
| Additional Reading | p. 272 |
| Solving Single Equations | p. 273 |
| Characteristics of Nonlinear Algebraic Equations | p. 274 |
| Graphical Solutions | p. 276 |
| Solving Equations in Excel Using Goal Seek | p. 278 |
| Solving Equations in Excel Using Solver | p. 281 |
| Interval-Reduction Techniques | p. 290 |
| Iterative Techniques | p. 293 |
| Additional Reading | p. 297 |
| Solving Simultaneous Equations | p. 298 |
| Matrix Notation | p. 299 |
| Matrix Operations in Excel | p. 309 |
| Solving Simultaneous Equations in Excel Using Matrix Inversion | p. 311 |
| Solving Simultaneous Equations in Excel Using Solver | p. 315 |
| Additional Reading | p. 330 |
| Making Logical Decisions (IF-THEN-ELSE) | p. 331 |
| Logical Expressions | p. 331 |
| The IF Function | p. 332 |
| Nested IF Functions | p. 332 |
| Additional Reading | p. 339 |
| Evaluating Integrals | p. 340 |
| The Trapezoidal Rule | p. 341 |
| Simpson's Rule | p. 354 |
| Additional Reading | p. 365 |
| Comparing Economic Alternatives | p. 366 |
| Compound Interest | p. 366 |
| The Time Value of Money | p. 378 |
| Uniform, Multipayment Cash Flows | p. 381 |
| Irregular Cash Flows | p. 389 |
| Internal Rate of Return | p. 397 |
| Additional Reading | p. 404 |
| Finding Optimum Solutions | p. 406 |
| Optimization Problem Characteristics | p. 407 |
| Solving Optimization Problems in Excel | p. 419 |
| Additional Reading | p. 436 |
| Answers to Selected Problems | p. 438 |
| Index | p. 465 |
| Table of Contents provided by Syndetics. All Rights Reserved. |