Engineering with Excel / Edition 4

Paperback (Print)
Rent
Rent from BN.com
$20.22
(Save 79%)
Est. Return Date: 10/29/2014
Buy New
Buy New from BN.com
$83.81
Buy Used
Buy Used from BN.com
$60.73
(Save 37%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $48.33
Usually ships in 1-2 business days
(Save 49%)
Other sellers (Paperback)
  • All (23) from $48.33   
  • New (11) from $79.36   
  • Used (12) from $48.33   

Overview

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.

Read More Show Less

Editorial Reviews

From The Critics
This textbook for a first-year engineering course explains how to apply the Excel spreadsheet program to perform common engineering calculations. Topics include graphing, matrix operations, linear regression, macros, Visual Basic for applications, financial calculations, statistics functions, and numerical integration techniques for differential equations. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780132788656
  • Publisher: Prentice Hall
  • Publication date: 1/20/2012
  • Edition description: New Edition
  • Edition number: 4
  • Pages: 720
  • Sales rank: 192,453
  • Product dimensions: 8.00 (w) x 10.00 (h) x 1.00 (d)

Meet the Author

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

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
Read More Show Less

Preface

ESource–The Prentice Hall Engineering Source–
www.prenhall.com/esource

ESource—The Prentice Hall Engineering Source gives professors the power to harness the full potential of their text and their first-year engineering course. More than just a collection of books, ESource is a unique publishing system revolving around the ESource website— www.prenhall.com/esource. ESource enables you to put your stamp on your book just as you do your course. It lets you:

  • Control: You choose exactly what chapter or sections are in your book and in what order they appear. Of course, you can choose the entire book if you'd like and stay with the authors' original order.
  • Optimize: Get the most from your book and your course. ESource lets you produce the optimal text for your students needs.
  • Customize: You can add your own material anywhere in your text's presentation, and your final product will arrive at your bookstore as a professionally formatted text. Of course, all titles in this series are available as stand-alone texts, or as bundles of two or more books sold at a discount. Contact your PH sales rep for discount information.

ESource ACCESS

Professors who choose to bundle two or more texts from the ESource series for their class, or use an ESource custom book will be providing their students with complete access to the library of ESource content. All bundles and custom books will come with a student password that gives web ESource ACCESS to all information on the site. This passcode is free and is valid for one yearafter initial logon. We've designed ESource ACCESS to provide students a flexible, searchable, on-line resource. Professors may also choose to deliver custom ESource content via the web only using ESource ACCESS passcodes. Contact your PH sales rep for more information.

ESource Content

All the content in ESource was written by educators specifically for freshman/first-year students. Authors tried to strike a balanced level of presentation, an approach that was neither formulaic nor trivial, and one that did not focus too heavily on advanced topics that most introductory students do not encounter until later classes. Because many professors do not have extensive time to cover these topics in the classroom, authors prepared each text with the idea that many students would use it for self-instruction and independent study Students should be able to use this content to learn the software tool or subject on their own.

While authors had the freedom to write texts in a style appropriate to their particular subject, all followed certain guidelines created to promote a consistency that makes students comfortable. Namely, every chapter opens with a clear set of Objectives, includes Practice Boxes throughout the chapter, and ends with a number of Problems, and a list of Key Terms. Applications Boxes are spread throughout the book with the intent of giving students a real-world perspective of engineering. Success Boxes provide the student with advice about college study skills, and help students avoid the common pitfalls of first-year students. In addition, this series contains an entire book titled Engineering Success by Peter Schiavone of the University of Alberta intended to expose students quickly to what it takes to be an engineering student.

Creating Your Book

Using ESource is simple. You preview the content either on-line or through examination copies of the books you can request on-line, from your PH sales rep, or by calling 1-800-526-0485. Create an on-line outline of the content you want, in the order you want, using ESource's simple interface. Either type or cut and paste your own material and insert it into the text flow. You can preview the overall organization of the text you've created at anytime (please note, since this preview is immediate, it comes unformatted.), then press another button and receive an order number for your own custom book. If you are not ready to order, do nothing—ESource will save your work. You can come back at any time and change, re-arrange, or add more material to your creation. Once you're finished and you have an ISBN, give it to your bookstore and your book will arrive on their shelves four to six weeks after they order. Your custom desk copies with their instructor supplements will arrive at your address at the same time.

To learn more about this new system for creating the perfect textbook, go to www.prenhall.com/esource. You can either go through the on-line walkthrough of how to create a book, or experiment yourself.

Supplements

Adopters of ESource receive an instructor's CD that contains professor and student code from the books in the series, as well as other instruction aides provided by authors. The website also holds approximately 350 PowerPoint transparencies created by Jack Leifer of University of Kentucky-Paducah available to download. Professors can either follow these transparencies as pre-prepared lectures or use them as the basis for their own custom presentations.

Read More Show Less

Customer Reviews

Average Rating 1
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(1)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted February 18, 2012

    Order was cancelled

    I ordered this book and a few days later my order was cancelled by Barnes and Noble. I ended up buying this book from the bookstore at my college and it cost me at least 20 dollars more. Barnes and Noble, please do not accept orders and give an anticipated arrival date until you know you will have the material in that time.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)