# Engineering With Excel

• ISBN13:

• ISBN10:

## 0130176966

• Edition: 1st
• Format: Paperback
• Publisher: PRENTICE HALL
• Purchase Benefits
• Free Shipping On Orders Over \$35!
Your order must be \$35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
• Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: \$49.75

### Summary

For courses in Computer Methods. An extensive text thoroughly covering the application of Excel to Engineering. This book is best for those who will spend a significant amount of time covering Excel during a semester or quarter, those who require that their students have a complete engineering reference to excel, or those who want to learn to apply excel to engineering problems on their own. This text is designed for all users from introductory to graduate students.

 Introduction to Excel
1(45)
 Introduction
1(3)
 Nomenclature
2(1)
 Examples and Application Problems
2(1)
2(1)
3(1)
 Starting Excel
4(2)
 Starting Excel Using the Excel Icon on the Start Menu
4(1)
 Starting Excel Using New Office Document
5(1)
 A Little Windows
6(4)
 Title Bar
6(1)
 Control Buttons
6(1)
7(1)
 Standard Toolbar
7(1)
 Formatting Toolbar
7(1)
 Formula Bar
8(1)
8(2)
 Status Bar
10(1)
10(22)
 Labels, Numbers, Formulas
10(1)
 Entering Formulas
11(1)
 Copying Cell Ranges to Perform Repetitive Calculations
12(1)
 Using the Fill Handle
13(2)
15(2)
 Using Named Cells
17(2)
 Editing the Active Cell
19(1)
 Using Built-In Functions
20(1)
 Error Messages in Excel
21(1)
 Formatting Cells
22(3)
25(3)
 Splitting and Freezing Panes
28(4)
32(3)
 Setting the Print Area
33(1)
 Printing Using Current Options
34(1)
 Changing Printing Options
34(1)
 Saving, Opening Workbooks, and Exiting
35(11)
 Saving the Workbook
35(1)
 Opening a Previously Saved Workbook
35(1)
 Exiting Excel
35(11)
 Graphing with Excel
46(38)
 Introduction
46(1)
 Getting Ready to Graph: Importing Text Files
47(3)
 Creating an XY Scatter Plot
50(4)
 Editing an Existing Graph
54(9)
 Modifying Graph Features
54(4)
58(3)
61(2)
 Creating Graphs with Multiple Curves
63(6)
65(4)
 Printing the Graph
69(1)
 Types of Graphs
69(15)
 Excel Functions
84(42)
 Introduction to Excel Functions
84(1)
 Excel's Built-in Functions
85(3)
 Function Syntax
85(3)
 Using the CONVERT ( ) Function to Convert Units
88(4)
 Checking to see if CONVERT ( ) is available
88(2)
 Once the CONVERT ( ) function is available
90(2)
 Simple Math Functions
92(2)
 Common Math Functions
92(2)
 Computing Sums
94(3)
 The SUM ( ) Function
94(1)
 The Auto Sum Button
95(1)
 Logarithm and Exponentiation Functions
96(1)
 Trigonometric Functions
97(3)
 Standard Trigonometric Functions
98(2)
 Inverse Trigonometric Functions
100(4)
104(2)
 Logical Functions
104(2)
 Conditional Formatting
106(2)
 Error Function
108(1)
 Bessel Functions
109(1)
 Working with Complex Numbers
110(1)
 Working with Binary, Octal, and Hexadecimal Values
110(1)
 Miscellaneous Functions
111(15)
 Working with Random Numbers
111(1)
 Odd, Even
111(1)
 Date and Time Functions
111(3)
 Text Handling Functions
114(1)
 Lookup and Reference Functions
114(12)
 Matrix Operations in Excel
126(27)
 Matrix Manipulations: Vectors, Matrices, and Arrays
126(1)
 How Excel Handles Matrix Math
127(1)
 Basic Matrix Operations
127(10)
127(1)
 Multiplying a Matrix by a Scalar
128(2)
 Multiplying Two Matrices
130(3)
 Transposing a Matrix
133(2)
 Inverting a Matrix
135(1)
 Matrix Determinant
136(1)
 Solving Systems of Linear Equations
137(16)
 Linear Regression in Excel
153(34)
 Introduction
153(1)
 Linear Regression Using Excel Functions
154(2)
 A Simple Example
154(2)
 Linear Regression Using Excel's Trend Line Capability
156(4)
 Simple Slope-Intercept Linear Regression
156(4)
 Forcing the Regression Line through the Origin (0,0)
160(1)
 Other Two-Coefficient Linear Regression Models
160(2)
 Polynomial Regression
162(2)
 Linear Regression Using Excel's Regression Analysis Package
164(23)
 A Simple Linear Regression for Slope and Intercept
164(6)
 Polynomial Regression Using the Regression Analysis Package
170(2)
 Other Linear Models
172(1)
 Forcing the Regression Line through the Origin (O, O)
173(14)
 Iterative Solutions Using Excel
187(38)
 Introduction
187(1)
 Iterative Solutions
188(10)
 Standard Forms
188(1)
 Using a Plot to Search for Roots
189(2)
 Simple ``Guess and Check'' Iteration
191(1)
 Writing Your Equation in Standard Form 2 (``Guess and Check'' Form)
192(2)
 Direct Substitution
194(2)
 In-Cell Iteration
196(2)
 Introduction to Excel's Solver
198(6)
 To Activate the Solver
198(1)
 To Install the Solver
198(1)
 To Use the Solver
199(5)
 Optimization Using the Solver
204(4)
 Nonlinear Regression
208(5)
 Testing the Regression Result
213(12)
 Using Macros in Excel
225(43)
 Introduction
225(2)
 Formulas, Functions, Macros, VBA Programs: Which One and When?
226(1)
 Macros and Viruses
227(1)
 Recorded Macros
227(19)
 Recording a Macro
228(2)
 Testing the Recorded Macro
230(2)
 Using Absolute Cell References When Recording Macros
232(1)
 Including an Absolute Cell Reference in a Macro Recorded Using Relative Referencing
232(1)
 Editing a Recorded Macro
233(13)
 Programmed Macros (VBA)
246(22)
 Starting Visual Basic for Applications (VBA)
246(2)
 Modules, Subs, and Functions
248(2)
 A Simple Border Macro
250(1)
 Running the Macro
251(1)
252(1)
 Using a Programmed Macro from Another Workbook
252(1)
 Common Macro Commands
253(15)
 Programming in Excel with VBA
268(28)
 Introduction
268(1)
 Visual Basic for Applications (VBA) Overview
269(1)
 Starting the VBA Editor
269(1)
 Forms and Modules
270(8)
 Inserting a Module
270(1)
 Overview of Writing a Function
271(3)
 The Difference Between Subs (subprograms) and Functions
274(1)
 The Scope of Variables and Functions
274(1)
 Passing Values through an Argument List
275(1)
 Declaring Data Types for Variables
276(1)
 Using the Function Name as the Return Variable Name
277(1)
 Working with Forms
278(10)
288(1)
 Using the Form from the Spreadsheet
288(8)
 Sharing Excel Information with Other Programs
296(39)
 Introduction to Sharing Excel Information with Other Programs
296(1)
 Using Copy and Paste to Move Information
297(8)
 Moving Information Between Excel and Word
297(4)
 Moving Information Between Excel and MATHCAD
301(3)
 Moving Information Between Excel and the World Wide Web
304(1)
305(14)
 Embedded and Linked Objects in Word and Excel
305(2)
307(12)
 External Data Sources
319(16)
 Text Files as Data Sources for Excel
319(6)
 Database Files as Data Sources for Excel
325(7)
 Excel Files as Data Sources for Excel Spreadsheets
332(3)
 Time Value of Money with Excel
335(28)
 Time, Money, and Cash Flows
335(3)
 Cash Flows
336(1)
 Types of Expenses
337(1)
 Types of Income
338(1)
 Interest Rates and Compounding
338(4)
 Periodic Interest Rates, ip
339(1)
 Nominal Interest Rates (inom)
339(1)
 Effective Annual Interest Rates (ie)
340(2)
 Moving Amounts through Time
342(12)
 Present and Future Values
342(5)
 Regular Payments
347(4)
 Discounting Factor Tables and Nomenclature
351(3)
 Economic Alternatives: Making Decisions
354(9)
 Financial Calculations with Excel
363(24)
 Introduction
363(1)
 Internal Rate of Return and Net Present Value
364(6)
 Net Present Value
364(4)
 Internal Rate of Return
368(2)
 Depreciation of Assets
370(17)
 Methods of Depreciation
370(17)
 Excel's Statistics Functions
387(22)
 Overview
387(1)
 Populations and Samples
388(1)
 Alternative Example
388(1)
388(1)
 Arithmetic Mean, or Average
389(1)
 Standard Deviations and Variances
389(3)
 Population Statistics
391(1)
 Samples of a Population
391(1)
 Errors, Deviations, and Distributions
392(6)
 Frequency Distributions
394(4)
 Confidence Intervals
398(11)
 Confidence Levels and the Level of Significance
398(1)
 Confidence Intervals: Bounding the Extent of Uncertainty
399(10)
 Numerical Differentiation Using Excel
409(24)
 Finite Differences
409(8)
 Derivatives as Slopes
410(2)
 Caution on Using Finite Differences with Noisy Data
412(1)
 Common Finite-Difference Forms
413(3)
 Accuracy and Error Management
416(1)
 Filtering Data
417(6)
 Moving Average
417(4)
 Exponential Smoothing
421(2)
 Curve-Fitting and Differentiation
423(10)
 Numerical Integration Using Excel
433(26)
 Integrating for Area under a Curve
433(1)
 Integrating for Area Between Two Curves
434(1)
 Numerical Integration Methods
434(13)
 Integration Using Rectangles
435(4)
 Integration Using Trapezoids
439(5)
 Integration Using Smooth Curves (Simpson's Rule)
444(1)
 Simpson's Rule Procedure
444(3)
 Using Regression Equations for Integration
447(12)
 Numerical Integration Techniques for Differential Equations Using Excel
459(31)
 Euler's Method
459(8)
 Choosing an Integration Step Size
459(5)
 Checking the Accuracy of the Result
464(1)
 Error
465(2)
 Fourth-Order Runge-Kutta Method
467(6)
 Evaluating the Derivative: Function dDdl()
467(1)
 How the Fourth-Order Runge-Kutta Method Works
468(2)
 Automating Fourth-Order Runge-Kutta: Function rk4()
470(1)
 Implementing Fourth-Order Runge-Kutta in a Spreadsheet
471(2)
 Integrating Two Simultaneous ODEs Using the Runge---Kutta Method
473(6)
 Checking for Accuracy
478(1)
 Implicit Methods
479(11)
 Using the Method of Lines to Get the General Finite-Difference Equation
479(11)
Index 490