Rent 9780130081759 | Introduction to Excel 2002 | Kuncicky, David @knetbooks.com

Summary Table of Contents

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.

For Freshman or Introduct... MORE

Microsoft Excel Basics

(34)

Introduction to Worksheets

(1)

How to Use This Book

... MORE

(1)

Typographic Conventions Used in This Book

(1)

Selection with the Mouse

(1)

Multiple Selections

(1)

Multiple Keystrokes

(1)

Literal Expressions

(1)

Key Terms

(1)

Understanding the Excel 2002 Screen

(9)

Title Bar

(1)

Menu Bar

(1)

Toolbars

(1)

Customizing Toolbars

(1)

Formula Bar

(2)

Task Pane

(1)

Workbook Window

(1)

Sheet Tabs

(1)

Scrollbars

(1)

Status Bar

(1)

Getting Help

(3)

Choosing from the Table of Contents

(1)

Using the Answer Wizard

(1)

Using the Help Index

(1)

Using the Question Panel on the Standard Toolbar

(1)

Using the Office Assistant

(1)

Using the What's This Feature

(1)

Learning from the Tip of the Day

(1)

Accessing Help From the World Wide Web

(1)

Manipulating Windows

(2)

Minimize Control Button

(1)

Restore/Maximize

(1)

Close Control Button

(1)

Creating and Saving Worksheets and Workbooks

(4)

Creating a New Workbook

(1)

Opening an Existing Workbook

(1)

Creating New Worksheet

(1)

Introduction to Templates

(1)

Opening Workbooks with Macros

(1)

Saving Documents

(2)

The AutoRecover Feature

(1)

Naming Documents

(1)

Moving Around a Worksheet

(3)

Movement by Using the Keyboard

(1)

Movement by Using the Mouse

(1)

Movement by Using the Go to Dialog Box

(2)

Selecting a Region

(1)

Selection by Using Cell References

(1)

Selection by Using the Mouse

(1)

Selection by Using the Keyboard

(1)

Cutting, Moving, Copying, and Pasting

(3)

Cutting a Region

(1)

Moving a Region

(1)

Copying a Region

(1)

Inserting and Deleting Cells

(1)

Shortcut Keys

(1)

Finding and Correcting Mistakes

(2)

Undoing Mistakes

(1)

Checking Spelling

(1)

The AutoCorrect Feature

(2)

Printing

(4)

Setting the Print Area

(1)

Previewing a Worksheet

(1)

Printing a Worksheet

(3)

Entering and Formatting Data

(20)

Entering Numeric Data

(3)

Entering Text Data

(1)

Entering Data and Time Data

(1)

Using Fill Handles

(2)

Formatting Cells

(1)

Formatting Columns and Rows

(1)

Table AutoFormats

(1)

Conditional Formatting

(2)

Sorting

(3)

Formatting Entire Worksheets

(7)

Formulas and Functions

(24)

Introduction

(1)

Creating and Using Formulas

(1)

Formula Syntax

(3)

Arithmetic Operators

(1)

Predefined Functions

(1)

Cell References

(2)

Cell and Range Names

(2)

Absolute and Relative References

(3)

Error Messages

(1)

Debugging Errors by Using Cell Selection

(3)

Formulas

(1)

Precedents

(1)

Dependents

(1)

Column (or Row) Differences

(1)

Debugging Errors by Using Tracing

(1)

Using Excel's Built-in Functions

(4)

Examples of Statistical Functions

(2)

Example of Matrix Operations

(2)

Using Macros to Automate Computations

(8)

Recording a Macro

(2)

Executing a Macro

(1)

Editing a Macro

(6)

Working with Charts

(24)

Using the Chart Wizard to Create an XY Scatter Chart

(4)

Creating a Chart by Using Shortcut Keys

(2)

Previewing and Printing Charts

(2)

Adding and Editing Chart Data

(4)

Adding Data Points

(1)

Multiple Data Series

(3)

Formatting Charts

(4)

Creating Chart Objects

(1)

Formatting Individual Chart Objects

(3)

Annotating a Chart

(1)

Changing Chart Types

(1)

Charting Features Useful to Engineers

(8)

Scaling an Axis

(1)

Error Bars

(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

RENT TEXTBOOKS

Introduction to Excel 2002

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products