Spreadsheet Tools for Engineers Using Excel ® 2007
ISBN: 9780073385860 | 0073385867
Edition: 1stFormat: Paperback
Publisher: McGraw-Hill Science/Engineering/Math
Pub. Date: 1/22/2009
Why Rent from Knetbooks?
Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!
Top 5 reasons to order all your textbooks from Knetbooks:
- We have the lowest prices on thousands of popular textbooks
- Free shipping both ways on ALL orders
- Most orders ship within 48 hours
- Need your book longer than expected? Extending your rental is simple
- Our customer support team is always here to help
Through previous versions, this practical text has found a permanent spot in many 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 Excel 2007, this version of Spreadsheet Tools for Engineers provides engineering students with a strong foundation in problem solving as well as specific instructions in the use of Excel 2007.
This practical text is a perfect fit for introdu... MORE
This practical text is a perfect fit for introdu... MORE
| Engineering Analysis and Spreadsheets | p. 1 |
| A Spreadsheet Overview | p. 1 |
| General Problem-Solving Techniques | p. 6 |
| Applicable Engineering Fundamentals | p. 7 |
| Mathematical Solution Procedures | p. 14 |
| Creating an Excel Worksheet | p. 17 |
| Entering and Leaving Excel | p. 18 |
| Getting Help | p. 21 |
| Moving around the Worksheet | p. 24 |
| ... MORE | p. 26 |
| Correcting Errors | p. 30 |
| Using Formulas | p. 31 |
| Using Functions | p. 45 |
| Saving and Retrieving a Worksheet | p. 52 |
| Printing a Worksheet | p. 55 |
| Editing an Excel Worksheet | p. 62 |
| Editing the Worksheet | p. 62 |
| Undoing Changes | p. 68 |
| Copying and Moving Formulas | p. 68 |
| Inserting and Deleting Rows and Columns | p. 70 |
| Inserting and Deleting Individual Cells | p. 73 |
| Smart Tags | p. 75 |
| Adjusting Column Widths | p. 77 |
| Formatting Data Items | p. 78 |
| Editing Shortcuts | p. 80 |
| Hyperlinks | p. 80 |
| Displaying Cell Formulas | p. 84 |
| Closing Remarks | p. 86 |
| Making Logical Decisions (IF-THEN-ELSE) | p. 87 |
| Logical (Boolean) Expressions | p. 87 |
| The IF Function | p. 88 |
| Nested IF Functions | p. 89 |
| Graphing Data | p. 97 |
| Characteristics of a Good Graph | p. 97 |
| Creating a Graph in Excel | p. 100 |
| X-Y Graphs (Excel Scatter Charts, or XY Charts) | p. 102 |
| Adding Data to an Existing Data Set | p. 107 |
| Semi-Log Graphs | p. 115 |
| Log-Log Graphs | p. 120 |
| Line Graphs (Excel Line Charts) | p. 126 |
| Bar Graphs (Excel Column Charts) | p. 130 |
| Pie Charts | p. 135 |
| Closing Remarks | p. 140 |
| Analyzing Data Statistically | p. 141 |
| Data Characteristics | p. 141 |
| Histograms | p. 151 |
| Cumulative Distributions | p. 160 |
| Fitting Equations to Data | p. 169 |
| Linear Interpolation | p. 170 |
| The Method of Least Squares | p. 176 |
| Fitting a Straight Line to a Set of Data | p. 178 |
| Least Squares Curve Fitting in Excel | p. 183 |
| Fitting Other Functions to a Set of Data | p. 192 |
| Selecting the Best Function for a Given Data Set | p. 207 |
| Sorting and Filtering Data | p. 225 |
| Creating a List in Excel | p. 226 |
| Sorting Data in Excel | p. 227 |
| Filtering Data in Excel | p. 237 |
| Tables | p. 244 |
| Pivot Tables | p. 245 |
| Pivot Charts | p. 255 |
| Transferring Data | p. 258 |
| Importing Data from a Text File | p. 258 |
| Exporting Data to a Text File | p. 264 |
| Transferring HTML Data | p. 270 |
| Transferring Data to Microsoft Word | p. 273 |
| Transferring Data to Microsoft PowerPoint | p. 286 |
| Converting Units | p. 295 |
| Simple Conversions | p. 295 |
| Simple Conversions in Excel | p. 296 |
| Converting Temperatures | p. 301 |
| Complex Conversions | p. 303 |
| Complex Conversions in Excel | p. 304 |
| Solving Single Equations | p. 309 |
| Characteristics of Nonlinear Algebraic Equations | p. 310 |
| Solving Equations Graphically | p. 312 |
| Solving Equations Numerically | p. 314 |
| Solving Equations in Excel Using Goal Seek | p. 321 |
| Solving Equations in Excel Using Solver | p. 330 |
| Solving Simultaneous Equations | p. 340 |
| Matrix Notation | p. 341 |
| Matrix Operations in Excel | p. 351 |
| Solving Simultaneous Equations in Excel Using Matrix Inversion | p. 353 |
| Solving Simultaneous Equations in Excel Using Solver | p. 357 |
| Evaluating Integrals | p. 373 |
| The Trapezoidal Rule | p. 374 |
| Simpson's Rule | p. 387 |
| Integrating Measured Data | p. 396 |
| Creating and Executing Macros and Functions | p. 402 |
| Recording a Macro | p. 402 |
| Executing a Macro | p. 404 |
| Cell Addressing within a Macro | p. 408 |
| Saving a Macro | p. 412 |
| Viewing a Macro in VBA | p. 414 |
| Editing a Macro in VBA | p. 418 |
| User-Defined Functions | p. 424 |
| Comparing Economic Alternatives | p. 434 |
| Compound Interest | p. 434 |
| The Time Value of Money | p. 447 |
| Uniform, Multipayment Cash Flows | p. 449 |
| Irregular Cash Flows | p. 457 |
| Internal Rate of Return | p. 464 |
| Finding Optimum Solutions | p. 473 |
| Optimization Problem Characteristics | p. 474 |
| Solving Optimization Problems in Excel | p. 486 |
| Appendix | p. 504 |
| Index | p. 507 |
| Table of Contents provided by Ingram. All Rights Reserved. |
Please wait while this item is added to your cart...
