Rent 9780130176967 | Engineering With Excel | Larsen, Ronald W. @knetbooks.com

Summary Table of Contents

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

(45)

Introduction

(3)

Nomenclature

2... MORE

(1)

Examples and Application Problems

(1)

What Is a Spreadsheet?

(1)

Why Use a Spreadsheet?

(1)

Starting Excel

(2)

Starting Excel Using the Excel Icon on the Start Menu

(1)

Starting Excel Using New Office Document

(1)

A Little Windows

(4)

Title Bar

(1)

Control Buttons

(1)

Menu Bar

(1)

Standard Toolbar

(1)

Formatting Toolbar

(1)

Formula Bar

(1)

Spreadsheets and Workbooks

(2)

Status Bar

(1)

Spreadsheet Basics

(22)

Labels, Numbers, Formulas

(1)

Entering Formulas

(1)

Copying Cell Ranges to Perform Repetitive Calculations

(1)

Using the Fill Handle

(2)

Relative and Absolute Addressing

(2)

Using Named Cells

(2)

Editing the Active Cell

(1)

Using Built-In Functions

(1)

Error Messages in Excel

(1)

Formatting Cells

(3)

Hyperlinks in Excel

(3)

Splitting and Freezing Panes

(4)

Printing the Spreadsheet

(3)

Setting the Print Area

(1)

Printing Using Current Options

(1)

Changing Printing Options

(1)

Saving, Opening Workbooks, and Exiting

(11)

Saving the Workbook

(1)

Opening a Previously Saved Workbook

(1)

Exiting Excel

(11)

Graphing with Excel

(38)

Introduction

(1)

Getting Ready to Graph: Importing Text Files

(3)

Creating an XY Scatter Plot

(4)

Editing an Existing Graph

(9)

Modifying Graph Features

(4)

Adding TrendLine

(3)

Adding Error Bars

(2)

Creating Graphs with Multiple Curves

(6)

Adding an Additional Curve

(4)

Printing the Graph

(1)

Types of Graphs

(15)

Excel Functions

(42)

Introduction to Excel Functions

(1)

Excel's Built-in Functions

(3)

Function Syntax

(3)

Using the CONVERT ( ) Function to Convert Units

(4)

Checking to see if CONVERT ( ) is available

(2)

Once the CONVERT ( ) function is available

(2)

Simple Math Functions

(2)

Common Math Functions

(2)

Computing Sums

(3)

The SUM ( ) Function

(1)

The Auto Sum Button

(1)

Logarithm and Exponentiation Functions

(1)

Trigonometric Functions

(3)

Standard Trigonometric Functions

(2)

Inverse Trigonometric Functions

100

(4)

Advanced Math Functions

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)

Adding Two Matrices

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)

Saving Your Macro Project

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)

Saving Your Project

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)

Embedded and Linked Objects

305

(14)

Embedded and Linked Objects in Word and Excel

305

(2)

Embedded and Linked Objects in MATHCAD and Excel

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)

Multiple Instrument Readings

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

RENT TEXTBOOKS

Engineering With Excel

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products