Engineering with Excel

  • Share this:
Share with a friend
Sign into your email account to send this page to a friend:
Outlook or Apple Mail
or other default program

Save $25 when you open a Walmart® Credit Card and spend $75 today.*

*Offer subject to credit approval
Learn More
or Apply Now

  • Browse Related Products

Engineering with Excel

Format:  Paperback,

709 pages

Publisher: Pearson College Div

Publish Date: Jan 2012

ISBN-13: 9780132788656

ISBN-10: 0132788659

Buy from Walmart

Shipping & Pickup

In stock for:

  • Store information not available.

Buy from Marketplace

Shipping & Additional Information

Book Information

The following content was provided by the publisher.

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.


Publisher: Pearson College Div
Publish Date: Jan 2012
ISBN-13: 9780132788656
ISBN-10: 0132788659
Format: Paperback
Number of Pages: 709
Shipping Weight (in pounds): 2.45
Product in Inches (L x W x H): 8.0 x 0.9 x 9.8

Chapter outline

About This Bookp. vii
Introduction To Excelp. 1
Introductionp. 1
What's new in Excel 2010?p. 4
A Starting Excelp. 5
A Little Windows“p. 6
Excel Basicsp. 16
Organizing Your Worksheetsp. 35
Printing the Worksheetp. 36
Saving and Opening Workbooks, Exiting Excelp. 41
Using Excel's Ribbonp. 53
Navigating the Ribbonp. 54
Using the Clipboard Groupp. 54
Using the Font Groupp. 71
Using the Alignment Groupp. 79
Formatting Numbersp. 85
Using the Styles Groupp. 93
Inserting, Deleting and Formatting Rows and Columnsp. 104
Graphing With Excelp. 122
Introductionp. 122
Getting Ready to Graphp. 123
Creating an XY Scatter Graphp. 124
Editing an Existing Graphp. 128
Printing the Graphp. 146
Other Types of Graphsp. 146
Graphing Web Datap. 156
Importing Text Filesp. 159
Excel Functionsp. 175
Introduction to Excel Functionsp. 175
Excel's Built-in Functionsp. 176
Using the CONVERT Function to Convert Unitsp. 179
Simple Math Functionsp. 181
Computing Sumsp. 183
Trigonometric Functionsp. 187
Advanced Math Functionsp. 195
Error Functionp. 197
Bessel Functionsp. 198
Working with Complex Numbersp. 198
Working with Binary, Octal, and Hexadecimal Valuesp. 198
Miscellaneous Functionsp. 200
Matrix Operations In Excelp. 221
Introductionp. 221
Matrices, Vectors, and Arraysp. 222
How Excel Handles Matrix Mathp. 223
Basic Matrix Operationsp. 223
Solving Systems of Linear Equationsp. 237
Linear Regression In Excelp. 256
Introductionp. 256
Linear Regression Using Excel Functionsp. 257
Linear Regression Using Excel's Trendlinesp. 259
Other Two-Coefficient Linear Regression Modelsp. 263
Polynomial Regressionp. 265
Linear Regression Using Excel's Regression Analysis Packagep. 266
Excel's Statistics Functionsp. 291
Overviewp. 291
Populations and Samplesp. 291
Standard Deviations and Variancesp. 294
Errors, Deviations, and Distributionsp. 297
Confidence Intervalsp. 304
Excel's Financial Functionsp. 318
Time, Money, and Cash Flowsp. 318
Interest Rates and Compoundingp. 321
Moving Amounts Through Timep. 325
Net Present Valuep. 335
Internal Rate of Returnp. 338
Economic Alternatives: Making Decisionsp. 340
Depreciation of Assetsp. 344
Iterative Solutions Using Excelp. 357
Introductionp. 357
Iterative Solutionsp. 358
Using a Plot to Search for Rootsp. 359
Simple "Guess and Check" Iterationp. 361
Direct-Substitution Techniquep. 363
Using Goal Seek in Excelp. 368
Introduction to Excel's Solverp. 371
Optimization Using the Solverp. 378
Nonlinear Regressionp. 383
Linear Programmingp. 394
Sharing Excel Information With Other Programsp. 415
Introduction to Sharing Excel Information with Other Programsp. 415
Using Copy and Paste to Move Informationp. 416
Embedded and Linked Objectsp. 428
External Data Sourcesp. 438
Excel Pivot Tablesp. 451
Introductionp. 451
Preparing to Create a Pivot Tablep. 452
ABasic Pivot Tablep. 453
Sorting and Filtering a Pivot Tablep. 455
Pivoting the Pivot Tablep. 459
What Can Be Done with a Pivot Table?p. 461
Pivot Chartsp. 464
Macros And User-Written Functions For Excelp. 470
Introductionp. 470
Macros and Virusesp. 471
Recorded Macrosp. 473
Programmed Macros (VBA)p. 504
User-Written Functions For Excelp. 524
Introductionp. 524
Macro-Enabled Worksheetsp. 526
Introduction to Visual Basic for Applicationsp. 529
Writing Your Own Functionp. 534
Using Your Functions in Other Workbooksp. 537
Examples of User-Written Functionsp. 538
Programming In Excel With VBAp. 547
Introductionp. 547
Virus Protection and Macro-Enabled Workbooksp. 548
Visual Basic for Applications (VBA)p. 549
Projects, Forms, and Modulesp. 551
Flowchartsp. 556
Fundamental Elements of Programmingp. 560
Working with Formsp. 583
Numerical Differentiation Using Excelp. 605
Introductionp. 605
Finite Differencesp. 605
Filtering Datap. 613
Curve Fitting and Differentiationp. 620
Numerical Integration Using Excelp. 631
Introductionp. 631
Integrating for Area under a Curvep. 632
Integrating for Area between Two Curvesp. 632
Numerical Integration Methodsp. 633
Using Regression Equations for Integrationp. 646
Numerical Integration Techniques For Differential Equations Using Excelp. 662
Introductionp. 662
Euler's Methodp. 663
Fourth-Order Runge-Kutta Methodp. 671
Integrating Two Simultaneous ODEs by Using the Runge-Kutta Methodp. 677
Implicit Integration Methodsp. 683

Customer Product Reviews


Gifting Plans

Financing Offers

Enjoy Great Financing!

Make the most of your shopping experience with the Walmart Discover® or Walmart Credit Card.

Save $25 when you open a Walmart® Credit Card and spend $75 today.*

*Offer subject to credit approval

Learn More or Apply Now

No Payments + No Interest if Paid in Full in 6 Months!
Enjoy no payments for 6 months. You'll have 6 months with no payments, and no interest if paid in full within 6 months on orders over $250. Otherwise, interest will be charged from the original date of purchase. Bill Me Later is the quick, easy, secure way to buy online without using your credit card. Simply select Bill Me Later at checkout. Subject to credit approval.

See Terms