Spreadsheet Tools for Engineers Using Excel 2007 / Edition 1

Spreadsheet Tools for Engineers Using Excel 2007 / Edition 1

by Byron Gottfried
ISBN-10:
0073385867
ISBN-13:
2900073385869
Pub. Date:
01/22/2009
Publisher:
McGraw-Hill Higher Education

Paperback

View All Available Formats & Editions
Current price is , Original price is $74.14. You
Select a Purchase Option (New Edition)
  • purchase options
    $17.05 $74.14 Save 77% Current price is $17.05, Original price is $74.14. You Save 77.00296735905044%.
    • Free return shipping at the end of the rental period details
    • Textbook Rentals in 3 Easy Steps  details
    icon-error
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.
  • purchase options
    $67.95 $74.14 Save 8% Current price is $67.95, Original price is $74.14. You Save 8%.
  • purchase options
    $37.37 $74.14 Save 50% Current price is $37.37, Original price is $74.14. You Save 50%.
    icon-error
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.

Overview

Spreadsheet Tools for Engineers Using Excel 2007 / Edition 1

This practical text is a perfect fit for introductory engineering courses by successfully combining an introduction to Excel fundamentals with a clear presentation on how Excel can be used to solve common engineering problems. Updated to ensure compatibility with Excel 2007, Spreadsheet Tools for Engineers Using Excel 2007 provides beginning engineering students with a strong foundation in problem solving using Excel as the modern day equivalent of the slide rule.

As part of McGraw-Hill's BEST series for freshman engineering curricula, this text is particularly geared toward introductory students. The author provides plenty of background information on technical terms, and provides numerous examples illustrating both traditional and spreadsheet solutions for a variety of engineering problems. The first three chapters introduce the basics of problem solving and Excel fundamentals. Beyond that, the chapters are largely independent of one another. Topics covered include graphing data, unit conversions, data analysis, interpolation and curve fitting, solving equations, evaluating integrals, creating macros, and comparing economic alternatives.

Product Details

ISBN-13: 2900073385869
Publisher: McGraw-Hill Higher Education
Publication date: 01/22/2009
Edition description: New Edition
Pages: 528
Product dimensions: 7.30(w) x 9.00(h) x 0.90(d)

About the Author

Byron S. Gottfried is a Professor of Industrial Engineering and Academic Director of the Freshman Engineering Program at the University of Pittsburgh. He has written eleven college textbooks, including Schaum's Outline of Programming with Basic.

Table of Contents

Chapter 1 Engineering Analysis and Spreadsheets 1

1.1 A Spreadsheet Overview 1

1.2 General Problem-Solving Techniques 6

1.3 Applicable Engineering Fundamentals 7

1.4 Mathematical Solution Procedures 14

Chapter 2 Creating an Excel Worksheet 17

2.1 Entering and Leaving Excel 18

2.2 Getting Help 21

2.3 Moving around the Worksheet 24

2.4 Entering Data 26

2.5 Correcting Errors 30

2.6 Using Formulas 31

2.7 Using Functions 45

2.8 Saving and Retrieving a Worksheet 52

2.9 Printing a Worksheet 55

Chapter 3 Editing an Excel Worksheet 62

3.1 Editing the Worksheet 62

3.2 Undoing Changes 68

3.3 Copying and Moving Formulas 68

3.4 Inserting and Deleting Rows and Columns 70

3.5 Inserting and Deleting Individual Cells 73

3.6 Smart Tags 75

3.7 Adjusting Column Widths 77

3.8 Formatting Data Items 78

3.9 Editing Shortcuts 80

3.10 Hyperlinks 80

3.11 Displaying Cell Formulas 84

3.12 Closing Remarks 86

Chapter 4 Making Logical Decisions (IF-THEN-ELSE) 87

4.1 Logical (Boolean) Expressions 87

4.2 The IF Function 88

4.3 Nested IF Functions 89

Chapter 5 Graphing Data 97

5.1 Characteristics of a Good Graph 97

5.2 Creating a Graph in Excel 100

5.3 X-Y Graphs (Excel Scatter Charts, or XY Charts) 102

5.4 Adding Data to an Existing Data Set 107

5.5 Semi-Log Graphs 115

5.6 Log-Log Graphs 120

5.7 Line Graphs (Excel Line Charts) 126

5.8 Bar Graphs (Excel Column Charts) 130

5.9 Pie Charts 135

5.10 Closing Remarks 140

Chapter 6 Analyzing Data Statistically 141

6.1 Data Characteristics 141

6.2 Histograms 151

6.3 Cumulative Distributions 160

Chapter 7 Fitting Equations to Data 169

7.1 Linear Interpolation 170

7.2 The Method ofLeast Squares 176

7.3 Fitting a Straight Line to a Set of Data 178

7.4 Least Squares Curve Fitting in Excel 183

7.5 Fitting Other Functions to a Set of Data 192

7.6 Selecting the Best Function for a Given Data Set 207

Chapter 8 Sorting and Filtering Data 225

8.1 Creating a List in Excel 226

8.2 Sorting Data in Excel 227

8.3 Filtering Data in Excel 237

8.4 Tables 244

8.5 Pivot Tables 245

8.6 Pivot Charts 255

Chapter 9 Transferring Data 258

9.1 Importing Data from a Text File 258

9.2 Exporting Data to a Text File 264

9.3 Transferring HTML Data 270

9.4 Transferring Data to Microsoft Word 273

9.5 Transferring Data to Microsoft PowerPoint 286

Chapter 10 Converting Units 295

10.1 Simple Conversions 295

10.2 Simple Conversions in Excel 296

10.3 Converting Temperatures 301

10.4 Complex Conversions 303

10.5 Complex Conversions in Excel 304

Chapter 11 Solving Single Equations 309

11.1 Characteristics of Nonlinear Algebraic Equations 310

11.2 Solving Equations Graphically 312

11.3 Solving Equations Numerically 314

11.4 Solving Equations in Excel Using Goal Seek 321

11.5 Solving Equations in Excel Using Solver 330

Chapter 12 Solving Simultaneous Equations 340

12.1 Matrix Notation 341

12.2 Matrix Operations in Excel 351

12.3 Solving Simultaneous Equations in Excel Using Matrix Inversion 353

12.4 Solving Simultaneous Equations in Excel Using Solver 357

Chapter 13 Evaluating Integrals 373

13.1 The Trapezoidal Rule 374

13.2 Simpson's Rule 387

13.3 Integrating Measured Data 396

Chapter 14 Creating and Executing Macros and Functions 402

14.1 Recording a Macro 402

14.2 Executing a Macro 404

14.3 Cell Addressing within a Macro 408

14.4 Saving a Macro 412

14.5 Viewing a Macro in VBA 414

14.6 Editing a Macro in VBA 418

14.7 User-Defined Functions 424

Chapter 15 Comparing Economic Alternatives 434

15.1 Compound Interest 434

15.2 The Time Value of Money 447

15.3 Uniform, Multipayment Cash Flows 449

15.4 Irregular Cash Flows 457

15.5 Internal Rate of Return 464

Chapter 16 Finding Optimum Solutions 473

16.1 Optimization Problem Characteristics 474

16.2 Solving Optimization Problems in Excel 486

Appendix 504

Index 507

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Spreadsheet Tools for Engineers Using Excel 2007 3 out of 5 based on 0 ratings. 2 reviews.
Anonymous More than 1 year ago
Taylor Smock More than 1 year ago
This book has information that carries over to Excel 2010, since it has much the same interface. Unfortunately, it does not have some of the new features of Excel 2010 in it. Since Excel 2010 was released after this book. Honestly, you can probably use this book (non-interface sections) as a way to learn how to do the same thing with Libreoffice Calc. My only problem is that you can only have this on two devices. And the first generation Nook does not count (it doesn't let me download and use it on the nook). Also, if you reinstall the operating system on your computer and then restore your files from a backup, you WILL need to delete this book and redownload it. It does not appear to add to the "x out of 2 available computers authorized" count however, which is good.