|  |
Table of ContentsPart 1 Excel Fundamentals
Chapter 1 Engineering Analysis and Spreadsheets
1.1 A Spreadsheet Overview
1.2 General Problem-Solving Techniques
1.3 Applicable Engineering Fundamentals
1.4 Mathematical Solution Procedures
Chapter 2 Creating an Excel Worksheet
2.1 Entering and Leaving Excel
2.2 Getting Help
2.3 Moving around the Worksheet
2.4 Entering Data
2.5 Correcting Errors
2.6 Using Formulas
2.7 Using Functions
2.8 Saving and Retrieving a Worksheet
2.9 Printing a Worksheet
Chapter 3 Editing an Excel Worksheet
3.1 Editing the Worksheet
3.2 Undoing Changes
3.3 Copying and Moving Formulas
3.4 Inserting and Deleting Rows and Columns
3.5 Inserting and Deleting Individual Cells
3.6 Smart Tags
3.7 Adjusting Column Widths
3.8 Formatting Data Items
3.9 Editing Shortcuts
3.10 Hyperlinks
3.11 Displaying Cell Formulas
3.12 Closing Remarks
Chapter 4 Graphing Data
4.1 Characteristics of a Good Graph
4.2 Creating a Graph in Excel
4.3 X-Y Graphs (Excel XY Charts, or Scatter Charts)
4.4 Adding Data to an Existing Data Set
4.5 Semi-Log Graphs
4.6 Log-Log Graphs
4.7 Line Graphs (Excel Line Charts)
4.8 Bar Graphs (Excel Column Charts)
4.9 Pie Charts
4.10 Closing Remarks
Chapter 5 Organizing Data
5.1 Creating a List in Excel
5.2 Sorting Data in Excel
5.3 Filtering Data in Excel
5.4 Pivot Tables
Chapter 6 Transferring Data
6.1 Importing Data from a Text File
6.2 Exporting Data to a Text File
6.3 Transferring HTML Data
6.4 Transferring Data to Microsoft Word
6.5 Transferring Data to Microsoft PowerPoint
Part 2 Engineering Applications
Chapter 7 Converting Units
7.1 Simple Conversions
7.2 Simple Conversions in Excel
7.3 Converting Temperatures
7.4 Complex Conversions
7.5 Complex Conversions in Excel
Chapter 8 Analyzing Data Statistically
8.1 Data Characteristics
8.2 Histograms
8.3 Cumulative Distributions
Chapter 9 Fitting Equations to Data
9.1 Linear Interpolation
9.2 The Method of Least Squares
9.3 Fitting a Straight Line to a Set of Data
9.4 Least Squares Curve Fitting in Excel
9.5 Fitting Other Functions to a Set of Data
9.6 Selecting the Best Function for a Given Data Set
Chapter 10 Solving Single Equations
10.1 Characteristics of Nonlinear Algebraic Equations
10.2 Solving Equations Graphically
10.3 Solving Equations Numerically
10.4 Solving Equations in Excel Using Goal Seek
10.5 Solving Equations in Excel Using Solver
Chapter 11 Solving Simultaneous Equations
11.1 Matrix Notation
11.2 Matrix Operations in Excel
11.3 Solving Simultaneous Equations in Excel Using Matrix Inversion
11.4 Solving Simultaneous Equations in Excel Using Solver
Chapter 12 Evaluating Integrals
12.1 The Trapezoidal Rule
12.2 Simpson's Rule
12.3 Integrating Measured Data
Chapter 13 Making Logical Decisions (IF-THEN-ELSE)
13.1 Logical (Boolean) Expressions
13.2 The IF Function
13.3 Nested IF Functions
Chapter 14 Recording and Running Macros
14.1 Recording a Macro
14.2 Executing a Macro
14.3 Cell Addressing within a Macro
14.4 Saving a Macro
14.5 Viewing a Macro
14.6 Editing a Macro
Chapter 15 Comparing Economic Alternatives
15.1 Compound Interest
15.2 The Time Value of Money
15.3 Uniform, Multipayment Cash Flows
15.4 Irregular Cash Flows
15.5 Internal Rate of Return
Chapter 16 Finding Optimum Solutions
16.1 Optimization Problem Characteristics
16.2 Solving Optimization Problems in Excel
Appendix
Index
|
|
|
2007 McGraw-Hill Higher Education