| |
| |
| |
| Engineering Analysis and Spreadsheets | |
| |
| |
| |
| A Spreadsheet Overview | |
| |
| |
| |
| General Problem-Solving Techniques | |
| |
| |
| |
| Applicable Engineering Fundamentals | |
| |
| |
| |
| Mathematical Solution Procedures | |
| |
| |
| |
| Creating an Excel Worksheet | |
| |
| |
| |
| Entering and Leaving Excel | |
| |
| |
| |
| Getting Help | |
| |
| |
| |
| Moving around the Worksheet | |
| |
| |
| |
| Entering Data | |
| |
| |
| |
| Correcting Errors | |
| |
| |
| |
| Using Formulas | |
| |
| |
| |
| Using Functions | |
| |
| |
| |
| Saving and Retrieving a Worksheet | |
| |
| |
| |
| Printing a Worksheet | |
| |
| |
| |
| Editing an Excel Worksheet | |
| |
| |
| |
| Editing the Worksheet | |
| |
| |
| |
| Undoing Changes | |
| |
| |
| |
| Copying and Moving Formulas | |
| |
| |
| |
| Inserting and Deleting Rows and Columns | |
| |
| |
| |
| Inserting and Deleting Individual Cells | |
| |
| |
| |
| Smart Tags | |
| |
| |
| |
| Adjusting Column Widths | |
| |
| |
| |
| Formatting Data Items | |
| |
| |
| |
| Editing Shortcuts | |
| |
| |
| |
| Hyperlinks | |
| |
| |
| |
| Displaying Cell Formulas | |
| |
| |
| |
| Closing Remarks | |
| |
| |
| |
| Making Logical Decisions (IF-THEN-ELSE) | |
| |
| |
| |
| Logical (Boolean) Expressions | |
| |
| |
| |
| The IF Function | |
| |
| |
| |
| Nested IF Functions | |
| |
| |
| |
| Graphing Data | |
| |
| |
| |
| Characteristics of a Good Graph | |
| |
| |
| |
| Creating a Graph in Excel | |
| |
| |
| |
| X-Y Graphs (Excel Scatter Charts, or XY Charts) | |
| |
| |
| |
| Adding Data to an Existing Data Set | |
| |
| |
| |
| Semi-Log Graphs | |
| |
| |
| |
| Log-Log Graphs | |
| |
| |
| |
| Line Graphs (Excel Line Charts) | |
| |
| |
| |
| Bar Graphs (Excel Column Charts) | |
| |
| |
| |
| Pie Charts | |
| |
| |
| |
| Closing Remarks | |
| |
| |
| |
| Analyzing Data Statistically | |
| |
| |
| |
| Data Characteristics | |
| |
| |
| |
| Histograms | |
| |
| |
| |
| Cumulative Distributions | |
| |
| |
| |
| Fitting Equations to Data | |
| |
| |
| |
| Linear Interpolation | |
| |
| |
| |
| The Method of Least Squares | |
| |
| |
| |
| Fitting a Straight Line to a Set of Data | |
| |
| |
| |
| Least Squares Curve Fitting in Excel | |
| |
| |
| |
| Fitting Other Functions to a Set of Data | |
| |
| |
| |
| Selecting the Best Function for a Given Data Set | |
| |
| |
| |
| Sorting and Filtering Data | |
| |
| |
| |
| Creating a List in Excel | |
| |
| |
| |
| Sorting Data in Excel | |
| |
| |
| |
| Filtering Data in Excel | |
| |
| |
| |
| Tables | |
| |
| |
| |
| Pivot Tables | |
| |
| |
| |
| Pivot Charts | |
| |
| |
| |
| Transferring Data | |
| |
| |
| |
| Importing Data from a Text File | |
| |
| |
| |
| Exporting Data to a Text File | |
| |
| |
| |
| Transferring HTML Data | |
| |
| |
| |
| Transferring Data to Microsoft Word | |
| |
| |
| |
| Transferring Data to Microsoft PowerPoint | |
| |
| |
| |
| Converting Units | |
| |
| |
| |
| Simple Conversions | |
| |
| |
| |
| Simple Conversions in Excel | |
| |
| |
| |
| Converting Temperatures | |
| |
| |
| |
| Complex Conversions | |
| |
| |
| |
| Complex Conversions in Excel | |
| |
| |
| |
| Solving Single Equations | |
| |
| |
| |
| Characteristics of Nonlinear Algebraic Equations | |
| |
| |
| |
| Solving Equations Graphically | |
| |
| |
| |
| Solving Equations Numerically | |
| |
| |
| |
| Solving Equations in Excel Using Goal Seek | |
| |
| |
| |
| Solving Equations in Excel Using Solver | |
| |
| |
| |
| Solving Simultaneous Equations | |
| |
| |
| |
| Matrix Notation | |
| |
| |
| |
| Matrix Operations in Excel | |
| |
| |
| |
| Solving Simultaneous Equations in Excel Using Matrix Inversion | |
| |
| |
| |
| Solving Simultaneous Equations in Excel Using Solver | |
| |
| |
| |
| Evaluating Integrals | |
| |
| |
| |
| The Trapezoidal Rule | |
| |
| |
| |
| Simpson's Rule | |
| |
| |
| |
| Integrating Measured Data | |
| |
| |
| |
| Creating and Executing Macros and Functions | |
| |
| |
| |
| Recording a Macro | |
| |
| |
| |
| Executing a Macro | |
| |
| |
| |
| Cell Addressing within a Macro | |
| |
| |
| |
| Saving a Macro | |
| |
| |
| |
| Viewing a Macro in VBA | |
| |
| |
| |
| Editing a Macro in VBA | |
| |
| |
| |
| User-Defined Functions | |
| |
| |
| |
| Comparing Economic Alternatives | |
| |
| |
| |
| Compound Interest | |
| |
| |
| |
| The Time Value of Money | |
| |
| |
| |
| Uniform, Multipayment Cash Flows | |
| |
| |
| |
| Irregular Cash Flows | |
| |
| |
| |
| Internal Rate of Return | |
| |
| |
| |
| Finding Optimum Solutions | |
| |
| |
| |
| Optimization Problem Characteristics | |
| |
| |
| |
| Solving Optimization Problems in Excel | |
| |
| |
| Appendix | |
| |
| |
| Index | |