Description

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.

Features

— Examples — Demonstrate how Excel can be used to solve a variety of engineering problems, making content accessible to students.

— Summaries and End-of-Chapter Problems included for all chapters

Part of Prentice Hall's ESource Program:

ESource enables you to choose individual chapters from published books in the Prentice Hall ESource Series. The content available in this online book-building system covers topics in engineering problem-solving and design, graphics, and computer applications. Using this program, you can create a unique text for your introduction to engineering course that exactly matches your content requirements and teaching approach.

www.prenhall.com/esource

New to this Edition

• The Engineering with Excel text has been updated to reflect the latest versions of Excel and Windows (Excel 2010 operating in Windows 7).
• All screen captures have been updated for Excel 2010.
• Menu operations have been updated to reflect Ribbon changes in Excel 2010 (but commands for previous versions are also listed for those using older versions).
• New methods for accessing chart formatting dialogs are described.
• The Paste menus in Excel 2010 show icons rather than text. The use of these menus is described in the text.
• The (iterative) Solver has been significantly upgraded with a new dialog. The use of the new Solver is covered in the text.
• There is a new Print dialog that combines features previously available on using Print and Print Preview. This is a significant enhancement that Excel users will appreciate.

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