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. |