#marketplace, .navbar, .container, .container-fluid, #media, #category, #ewards, #careers, .blueHeroSearchContainer, #photoHeroBanner, #etextbooks-page-2015, .slider-arrow, #books-page-2015, #my-account-wrapper-2015 {display:none;} .noscriptmsg p, .noscriptmsg h1 {color: #000;} body {background-color: #ccc !important; font-size: 14px; }

We're sorry, but eCampus.com doesn't work properly without JavaScript.

Either your device does not support JavaScript or you do not have JavaScript enabled.

How to enable JavaScript in your browser.

Need help? Call 1-855-252-4222

Rent now promotional banner

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Introduction to Excel 2002 book cover, ISBN 9780130081759

Introduction to Excel 2002

by Kuncicky, David

ISBN13: 9780130081759
ISBN10: 0130081752
Additional ISBN(s): 9780131464704
Format: Paperback
Copyright: 2003-01-01
Publisher: Pearson College Div
View Upgraded Edition

Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
1. Introduction to Excel 2002 > ISBN13: 9780130081759

List Price: $26.60

Summary

Part of Esource—Prentice Hall's Engineering Source, this book provides a flexible introduction to the use of Excel in engineering. Featuring over 25 modules and growing, the ESource series provides a comprehensive resource of essential engineering topics. Covers topics such as formatting data, formulas and functions, data analysis, database management, collaborating, and the World Wide Web. For any Engineer or Computer Scientist interested in a brief introduction to Excel.

Table of Contents

Microsoft Excel Basics

1

(34)

Introduction to Worksheets

1

(1)

How to Use This Book

2

(1)

Typographic Conventions Used in This Book

2

(1)

Selection with the Mouse

2

(1)

Multiple Selections

3

(1)

Multiple Keystrokes

3

(1)

Literal Expressions

3

(1)

Key Terms

3

(1)

Understanding the Excel 2002 Screen

3

(9)

Title Bar

4

(1)

Menu Bar

5

(1)

Toolbars

5

(1)

Customizing Toolbars

6

(1)

Formula Bar

7

(2)

Task Pane

9

(1)

Workbook Window

10

(1)

Sheet Tabs

10

(1)

Scrollbars

11

(1)

Status Bar

11

(1)

Getting Help

12

(3)

Choosing from the Table of Contents

12

(1)

Using the Answer Wizard

13

(1)

Using the Help Index

13

(1)

Using the Question Panel on the Standard Toolbar

14

(1)

Using the Office Assistant

14

(1)

Using the What's This Feature

15

(1)

Learning from the Tip of the Day

15

(1)

Accessing Help From the World Wide Web

15

(1)

Manipulating Windows

15

(2)

Minimize Control Button

16

(1)

Restore/Maximize

16

(1)

Close Control Button

16

(1)

Creating and Saving Worksheets and Workbooks

17

(4)

Creating a New Workbook

17

(1)

Opening an Existing Workbook

17

(1)

Creating New Worksheet

18

(1)

Introduction to Templates

18

(1)

Opening Workbooks with Macros

18

(1)

Saving Documents

18

(2)

The AutoRecover Feature

20

(1)

Naming Documents

21

(1)

Moving Around a Worksheet

21

(3)

Movement by Using the Keyboard

22

(1)

Movement by Using the Mouse

22

(1)

Movement by Using the Go to Dialog Box

22

(2)

Selecting a Region

24

(1)

Selection by Using Cell References

24

(1)

Selection by Using the Mouse

24

(1)

Selection by Using the Keyboard

25

(1)

Cutting, Moving, Copying, and Pasting

25

(3)

Cutting a Region

26

(1)

Moving a Region

26

(1)

Copying a Region

27

(1)

Inserting and Deleting Cells

28

(1)

Shortcut Keys

28

(1)

Finding and Correcting Mistakes

29

(2)

Undoing Mistakes

29

(1)

Checking Spelling

29

(1)

The AutoCorrect Feature

29

(2)

Printing

31

(4)

Setting the Print Area

31

(1)

Previewing a Worksheet

31

(1)

Printing a Worksheet

32

(3)

Entering and Formatting Data

35

(20)

Entering Numeric Data

35

(3)

Entering Text Data

38

(1)

Entering Data and Time Data

38

(1)

Using Fill Handles

39

(2)

Formatting Cells

41

(1)

Formatting Columns and Rows

42

(1)

Table AutoFormats

43

(1)

Conditional Formatting

43

(2)

Sorting

45

(3)

Formatting Entire Worksheets

48

(7)

Formulas and Functions

55

(24)

Introduction

55

(1)

Creating and Using Formulas

56

(1)

Formula Syntax

56

(3)

Arithmetic Operators

56

(1)

Predefined Functions

57

(1)

Cell References

57

(2)

Cell and Range Names

59

(2)

Absolute and Relative References

61

(3)

Error Messages

64

(1)

Debugging Errors by Using Cell Selection

64

(3)

Formulas

64

(1)

Precedents

65

(1)

Dependents

65

(1)

Column (or Row) Differences

66

(1)

Debugging Errors by Using Tracing

67

(1)

Using Excel's Built-in Functions

67

(4)

Examples of Statistical Functions

67

(2)

Example of Matrix Operations

69

(2)

Using Macros to Automate Computations

71

(8)

Recording a Macro

71

(2)

Executing a Macro

73

(1)

Editing a Macro

73

(6)

Working with Charts

79

(24)

Using the Chart Wizard to Create an XY Scatter Chart

79

(4)

Creating a Chart by Using Shortcut Keys

83

(2)

Previewing and Printing Charts

85

(2)

Adding and Editing Chart Data

87

(4)

Adding Data Points

87

(1)

Multiple Data Series

88

(3)

Formatting Charts

91

(4)

Creating Chart Objects

91

(1)

Formatting Individual Chart Objects

91

(3)

Annotating a Chart

94

(1)

Changing Chart Types

95

(1)

Charting Features Useful to Engineers

95

(8)

Scaling an Axis

95

(1)

Error Bars

96

(7)

Performing Data Analysis

103

(27)

Using the Analysis ToolPak

103

(1)

Creating a Histogram

104

(2)

Providing Descriptive Statistics

106

(2)

Computing a Correlation

108

(2)

Performing a Linear Regression

110

(2)

Trend Analysis

112

(7)

Trend Analysis with Data Series

112

(2)

Trend-Analysis Functions

114

(1)

Trend Analysis for Charts

115

(4)

Using the Goal Seeker

119

(1)

Using Solver for Optimization Problems

120

(10)

Introduction to Microsoft Excel Solver

121

(1)

Setting Up an Optimization Problem in Excel

121

(1)

Linear Optimization Example

121

(4)

Nonlinear Optimization Example

125

(5)

Database Management Within Excel

130

(12)

Introduction

130

(1)

Database Terminology

131

(1)

Creating Databases

131

(1)

Entering Data

132

(1)

Sorting a Database

133

(1)

Searching and Filtering

134

(8)

Filtering with the Data Entry Form

134

(1)

Using the AutoFilter Function

135

(1)

Using the Custom AutoFilter

135

(2)

Using Wild-Card Characters

137

(1)

Using the Advanced Filter Function

137

(1)

Logic Within Rows

138

(1)

Logic Between Rows

138

(4)

Collaborating with Other Engineers

142

(22)

The Collaborative Design Process

142

(1)

Microsoft Excel and Collaboration

143

(1)

Tracking Changes

143

(3)

Highlighting Changes

143

(1)

Creating an Identity

144

(1)

Incorporating or Rejecting Revisions

145

(1)

Adding Comments to a Document

146

(1)

Maintaining Shared Workbooks

147

(3)

Sharing a Workbook

147

(1)

Keeping a Change History

147

(2)

Timed Updates

149

(1)

Managing Conflicts

149

(1)

Personal Views

149

(1)

Merging Workbooks

149

(1)

Viewing the History of Changes

149

(1)

Restrictions for Shared Workbooks

150

(1)

Password Protection

150

(4)

Open Protection

150

(1)

Write Protection

151

(1)

Sheet Protection

151

(3)

Importing and Exporting Data from External File Formats

154

(10)

Import Using the File Open Option

154

(1)

Importing Text Data by Using the Text Import Wizard

154

(10)

Excel and the World Wide Web

164

(10)

Engineering and the Internet

164

(1)

Accessing the World Wide Web from Within Excel

165

(2)

Web Sites Related to Microsoft Excel

167

(1)

Retrieving Data by Using a Web Query

167

(3)

Accessing Excel Files on the Web

170

(1)

Creating Hyperlinks Within a Worksheet

170

(2)

Converting a Worksheet to a Web Page

172

(2)

Appendix A

174

(2)

Index

176

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program