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

Summary Table of Contents

For Freshman or Introductory courses in Engineering and Computer Science. ESourcePrentice Hall's Engineering Sourceprovides a complete, flexible introductory engineering and computing program. Featuring over 15 modules and growing, ESource allows professors to fully customize their textbooks through the ESource website. Professors are not only able to pick and choose modules, but also sections of modules, incorporate their own materials, and re-paginate and re-index the complete project. http://emissary.prenhall.com/esource or http://www.prenhall.com/esource

About ESource

iii

About the Authors

vii

Engineering and Electronic Worksheets

(6)

Introduction to Worksheets

... MORE

(1)

Engineering Methods

(2)

Problem Definition

(1)

Information Gathering

(1)

Selection of the Appropriate Theory or Methodology

(1)

Collection of Simplifying Assumptions

(1)

Solution and Refinement

(1)

Testing and Verification

(1)

Issues in Engineering and Data Analysis

(1)

Group Problem Solving

(1)

Document Transfer

(1)

Standardized Units

(1)

How to Use this Book

(3)

Typographic Conventions Used in This Book

(2)

Microsoft Excel Basics

(24)

Understanding the Excel 97 Screen

(5)

Title Bar

(1)

Menu Bar

(1)

Toolbars

(1)

Formula Bar

(1)

Workbook Window

(1)

Sheet Tabs

(1)

Scrollbars

(1)

Status Bar

(1)

Getting Help

(3)

Choosing from the Table of Contents

(1)

Searching the Help Index

(1)

Searching for Keywords in the Help Text

(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)

Accessing Special Help for Lotus 1-2-3 Users

(1)

Manipulating Windows

(2)

Minimize Control Button

(1)

Full Screen Control Button

(1)

Close Control Button

(1)

Creating and Saving Worksheets and Workbooks

(3)

Introduction to Templates

(1)

Creating and Opening Documents

(1)

Naming Documents

(1)

Opening Workbooks with Macros

(1)

Saving Documents

(1)

Editing a Worksheet

(8)

Moving around a Worksheet

(3)

Selecting a Region

(1)

Cutting, Moving, Copying, and Pasting

(1)

Inserting and Deleting Cells

(1)

Shortcut Keys

(1)

Undoing Mistakes

(1)

Spell Checking

(1)

The AutoCorrect Feature

(1)

Previewing and Printing a Worksheet

(3)

Previewing a Worksheet

(1)

Printing a Worksheet

(2)

Entering and Formatting Data

(18)

Entering Data

(4)

Numerical Data

(2)

Text Data

(1)

Date and Time Data

(1)

Fill Handles

(1)

Formatting Worksheets

(14)

Formatting Cells

(1)

Formatting Columns and Rows

(1)

Table AutoFormats

(1)

Conditional Formatting

(1)

Sorting

(2)

Formatting Entire Worksheets

(10)

Engineering Computation

(24)

Introduction

(1)

Creating and Using Formulas

(11)

Formula Syntax

(1)

Selecting Ranges

(1)

Cell and Range Names

(1)

Absolute and Relative References

(4)

Error Messages

(1)

Debugging Errors Using Cell Selection

(1)

Debugging Errors Using Tracing

(1)

Mathematical Functions

(1)

Matrix Operations

(2)

Using Macros to Automate Computations

(10)

Recording a Macro

(2)

Executing a Macro

(1)

Editing a Macro

(8)

Working with Charts

(24)

Creating Charts

(7)

Using the Chart Wizard to Create an XY Scatter Chart

(3)

Creating a Chart Using Shortcut Keys

(3)

Previewing and Printing Charts

(1)

Adding and Editing Chart Data

(4)

Adding Data Points

(2)

Multiple Data Series

(2)

Formatting Charts

(4)

Creating Chart Objects

(1)

Formatting Chart Objects

(2)

Changing Chart Types

(1)

Inserting Text

(1)

Charting Features Useful to Engineers

(9)

Scaling an Axis

(1)

Error Bars

(9)

Performing Data Analysis and Optimization

(28)

Using the Analysis ToolPak

(2)

Descriptive Statistics

(3)

Correlation

102

(1)

Linear Regression

102

(2)

Trend Analysis

104

(6)

Trend Analysis with Data Series

104

(1)

Trend Analysis Functions

105

(2)

Trend Analysis for Charts

107

(3)

Pivot Tables for Interactive Analysis

110

(2)

Using the Goal Seeker for What-If Analysis

112

(1)

Using Solver for Optimization Problems

113

(12)

Introduction to Microsoft Excel Solver

113

(1)

Setting Up an Optimization Problem in Excel

114

(1)

Linear Optimization Example

114

(3)

Non-Linear Optimization Example

117

(8)

Database Management within Excel

125

(18)

Introduction

125

(1)

Creating Databases

125

(3)

Database Terminology

125

(1)

Database Creation Tips

126

(1)

Entering Data

126

(2)

Sorting, Searching, and Filtering

128

(15)

Sorting a Database

128

(1)

Searching and Filtering

128

(3)

External Data Retrieval Using Microsoft Query

131

(12)

Collaborating with Other Engineers

143

(18)

The Collaborative Design Process

143

(1)

Microsoft Excel and Collaboration

143

(1)

Tracking Changes

144

(2)

Incorporating or Rejecting Revisions

145

(1)

Adding Comments to a Document

146

(1)

Maintaining Shared Workbooks

147

(3)

Keeping a Change History

147

(1)

Timed Updates

148

(1)

Managing Conflicts

148

(1)

Personal Views

149

(1)

Merging Workbooks

149

(1)

Viewing the History of Changes

149

(1)

Restrictions for Shared Workbooks

149

(1)

Password Protection

150

(2)

Open Protection

150

(1)

Write Protection

151

(1)

Sheet Protection

151

(1)

Workbook Protection

152

(1)

Importing and Exporting Data from External File Formats

152

(3)

Import Using the File Open Option

152

(1)

Importing Text Data Using the Text Import Wizard

153

(2)

Conducting a Team Meeting

155

(6)

Excel and the World Wide Web

161

(12)

Engineering and the Internet

161

(1)

Accessing the World Wide Web from within Excel

162

(2)

Web Sites Related to Microsoft Excel

164

(1)

Retrieving Data from a Web Page

164

(2)

Accessing FTP Sites from within Excel

166

(1)

Creating Hyperlinks within a Worksheet

167

(2)

Converting a Worksheet to a Web Page

169

(4)

Appendix A: Commonly Used Functions

173

(2)

Index

175

RENT TEXTBOOKS

Introduction to Excel

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products