Wintersalen Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | September 30, 2014

    Benjamin Parzybok: IMG A Brief History of Video Games Played by Mayors, Presidents, and Emperors



    Brandon Bartlett, the fictional mayor of Portland in my novel Sherwood Nation, is addicted to playing video games. In a city he's all but lost... Continue »

    spacer
Qualifying orders ship free.
$101.40
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
5 Remote Warehouse Engineering- General Engineering

This title in other editions

Engineering with Excel

by

Engineering with Excel Cover

 

Synopses & Reviews

Publisher Comments:

For introductory courses in Engineering and Computing

Based on¿Excel 2010, Engineering with Excel, 4e takes a comprehensive look at using Excel in engineering.¿ This book focuses on applications and is intended to serve as both a textbook and a reference for students.

Synopsis:

This package contains:

01032103257: MATLAB for Engineers

0132788659: Engineering with Excel

About the Author

Ronald W. Larsen, Ph.D., P.E., is the Department Head of the Chemical and Biological Engineering Department at Montana State University.

Table of Contents

ABOUT THIS BOOK vii

1 • INTRODUCTION TO EXCEL 1

1.1 Introduction 1

1.2 What’s new in Excel 2010? 4

1.2A Starting Excel 5

1.3 A Little Windows® 6

1.4 Excel Basics 16

1.5 Organizing Your Worksheets 35

1.6 Printing the Worksheet 36

1.7 Saving and Opening Workbooks, Exiting Excel 41

2 • USING EXCEL’S RIBBON 53

2.1 Navigating the Ribbon 54

2.2 Using the Clipboard Group 54

2.3 Using the Font Group 71

2.4 Using the Alignment Group 79

2.5 Formatting Numbers 85

2.6 Using the Styles Group 93

2.7 Inserting, Deleting and Formatting Rows and Columns 104

3 • GRAPHING WITH EXCEL 122

3.1 Introduction 122

3.2 Getting Ready to Graph 123

3.3 Creating an XY Scatter Graph 124

3.4 Editing an Existing Graph 128

3.5 Printing the Graph 146

3.6 Other Types of Graphs 146

3.7 Graphing Web Data 156

3.8 Importing Text Files 159

4 • EXCEL FUNCTIONS 175

4.1 Introduction to Excel Functions 175

4.2 Excel’s Built-in Functions 176

4.3 Using the CONVERT Function to Convert Units 179

4.4 Simple Math Functions 181

4.5 Computing Sums 183

4.6 Trigonometric Functions 187

4.7 Advanced Math Functions 195

4.8 Error Function 197

4.9 Bessel Functions 198

4.10 Working with Complex Numbers 198

4.11 Working with Binary, Octal, and Hexadecimal Values 198

4.12 Miscellaneous Functions 200

5 • MATRIX OPERATIONS IN EXCEL 221

5.1 Introduction 221

5.2 Matrices, Vectors, and Arrays 222

5.3 How Excel Handles Matrix Math 223

5.4 Basic Matrix Operations 223

5.5 Solving Systems of Linear Equations 237

6 • LINEAR REGRESSION IN EXCEL 256

6.1 Introduction 256

6.2 Linear Regression Using Excel Functions 257

6.3 Linear Regression Using Excel’s Trendlines 259

6.4 Other Two-Coefficient Linear Regression Models 263

6.5 Polynomial Regression 265

6.6 Linear Regression Using Excel’s Regression Analysis Package 266

7 • EXCEL’S STATISTICS FUNCTIONS 291

7.1 Overview 291

7.2 Populations and Samples 291

7.3 Standard Deviations and Variances 294

7.4 Errors, Deviations, and Distributions 297

7.5 Confidence Intervals 304

8 • EXCEL’S FINANCIAL FUNCTIONS 318

8.1 Time, Money, and Cash Flows 318

8.2 Interest Rates and Compounding 321

8.3 Moving Amounts Through Time 325

8.4 Net Present Value 335

8.5 Internal Rate of Return 338

8.6 Economic Alternatives: Making Decisions 340

8.7 Depreciation of Assets 344

9 • ITERATIVE SOLUTIONS USING EXCEL 357

9.1 Introduction 357

9.2 Iterative Solutions 358

9.3 Using a Plot to Search for Roots 359

9.4 Simple “Guess and Check” Iteration 361

9.5 Direct-Substitution Technique 363

9.6 Using Goal Seek in Excel 368

9.7 Introduction to Excel’s Solver 371

9.8 Optimization Using the Solver 378

9.9 Nonlinear Regression 383

9.10 Linear Programming 394

10 • SHARING EXCEL INFORMATION WITH OTHER PROGRAMS 415

10.1 Introduction to Sharing Excel Information with Other Programs 415

10.2 Using Copy and Paste to Move Information 416

10.3 Embedded and Linked Objects 428

10.4 External Data Sources 438

11 • EXCEL PIVOT TABLES 451

11.1 Introduction 451

11.2 Preparing to Create a Pivot Table 452

11.3 A Basic Pivot Table 453

11.4 Sorting and Filtering a Pivot Table 455

11.5 Pivoting the Pivot Table 459

11.6 What Can Be Done with a Pivot Table? 461

11.7 Pivot Charts 464

12 • MACROS AND USER-WRITTEN FUNCTIONS FOR EXCEL 470

12.1 Introduction 470

12.2 Macros and Viruses 471

12.3 Recorded Macros 473

12.4 Programmed Macros (VBA) 504

13 • USER-WRITTEN FUNCTIONS FOR EXCEL 524

13.1 Introduction 524

13.2 Macro-Enabled Worksheets 526

13.3 Introduction to Visual Basic for Applications 529

13.4 Writing Your Own Function 534

13.5 Using Your Functions in Other Workbooks 537

13.6 Examples of User-Written Functions 538

14 • PROGRAMMING IN EXCEL WITH VBA 547

14.1 Introduction 547

14.2 Virus Protection and Macro-Enabled Workbooks 548

14.3 Visual Basic for Applications (VBA) 549

14.4 Projects, Forms, and Modules 551

14.5 Flowcharts 556

14.6 Fundamental Elements of Programming 560

14.7 Working with Forms 583

15 • NUMERICAL DIFFERENTIATION USING EXCEL 605

15.1 Introduction 605

15.2 Finite Differences 605

15.3 Filtering Data 613

15.4 Curve Fitting and Differentiation 620

16 • NUMERICAL INTEGRATION USING EXCEL 631

16.1 Introduction 631

16.2 Integrating for Area under a Curve 632

16.3 Integrating for Area between Two Curves 632

16.4 Numerical Integration Methods 633

16.5 Using Regression Equations for Integration 646

17 • NUMERICAL INTEGRATION TECHNIQUES FOR DIFFERENTIAL EQUATIONS USING EXCEL 662

17.1 Introduction 662

17.2 Euler’s Method 663

17.3 Fourth-Order Runge–Kutta Method 671

17.4 Integrating Two Simultaneous ODEs by Using the Runge–Kutta Method 677

17.5 Implicit Integration Methods 683

Product Details

ISBN:
9780132788656
Author:
Larsen, Ronald W.
Publisher:
Pearson Education
Subject:
Engineering-General Engineering
Subject:
Engineering - General
Copyright:
Edition Description:
Trade paper
Publication Date:
20120106
Binding:
TRADE PAPER
Language:
English
Pages:
720
Dimensions:
10 x 8 x 1 in 1207 gr

Related Subjects

Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Engineering » Engineering » General Engineering

Engineering with Excel New Trade Paper
0 stars - 0 reviews
$101.40 In Stock
Product details 720 pages Prentice Hall - English 9780132788656 Reviews:
"Synopsis" by , This package contains:

01032103257: MATLAB for Engineers

0132788659: Engineering with Excel

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.