Rent 9780131464704 | Introduction to Excel 2004 | Kuncicky, David C.; Larsen, Ronald W. @knetbooks.com

Summary Table of Contents

ESource Prentice Hall's Engineering Source provides a comprehensive, customizable introductory engineering and computing library. Featuring over 25 modules and growing, ESource allows professors to fully customize their textbooks through the ESource website. Professors are not only able to pick and choose complete modules, but also custom-build a freshman engineering text that matches their content needs and course organization exactly!

Microsoft Excel Basics

(41)

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 2003 Screen

(9)

Title Bar

(1)

Menu Bar

(1)

Toolbars

(1)

Customizing Toolbars

(1)

Formula Bar

(2)

Task Pane

(2)

Workbook Window

(1)

Sheet Tabs

(2)

Scrollbars

(1)

Status Bar

(1)

Getting Help

(6)

Choosing from the Table of Contents

(1)

Searching the Help System

(2)

Using the Office Assistant

(1)

Learning from the Tip of the Day

(1)

Accessing Help from the Worldwide Web

(1)

Manipulating Windows

(1)

Minimize Control Button

(1)

Restore/Maximize

(1)

Close Control Button

(1)

Creating and Saving Worksheets and Workbooks

(5)

Creating a New Workbook

(1)

Opening an Existing Workbook

(1)

Creating a New Worksheet

(1)

Introduction to Templates

(1)

Opening Workbooks with Macros

(2)

Saving Documents

(1)

The AutoRecover Feature

(1)

Naming Documents

(1)

Moving Around a Worksheet

(4)

Movement by Using the Keyboard

(1)

Movement by Using the Mouse

(1)

Movement by Using the Go To Dialog Box

(2)

Selecting a Region

(2)

Selection by Using Cell References

(1)

Selection by Using the Mouse

(1)

Selection by Using the Keyboard

(1)

Cutting, Moving, Copying, and Pasting

(2)

Cutting a Region

(1)

Moving a Region

(1)

Copying a Region

(1)

Inserting and Deleting Cells

(1)

Deleting Cells

(1)

Clearing Cells

(1)

Inserting Cells

(1)

Shortcut Keys

(1)

Finding and Correcting Mistakes

(2)

Undoing Mistakes

(1)

Checking Spelling

(1)

The AutoCorrect Feature

(1)

Printing

(6)

Setting the Print Area

(1)

Previewing a Worksheet

(2)

Printing a Worksheet

(4)

Entering and Formatting Data

(37)

Introduction to Entering and Formatting Data

(1)

Entering Data

(6)

Entering Numeric Data

(3)

Entering Text Data

(1)

Entering Date and Time Data

(2)

Using Fill Handles

(4)

Using the Fill Handle with the Left Mouse Button to Copy Cells

(1)

Using the Fill Handle with the Left Mouse Button-More Copy Options

(1)

Creating a Linear Series with a Non-Unity Increment

(1)

Using the Fill Handle with the Right Mouse Button for Additional Options

(2)

Formatting for Appearance

(9)

Changing the Appearance of Cells

(6)

Changing the Appearance of Columns and Rows

(2)

Changing the Appearance of Entire Worksheets

(1)

Formatting Tables

(7)

Table Autoformats

(1)

Sorting Tables

(7)

Conditional Formatting

(10)

Formulas and Functions

(37)

Introduction

(1)

Referencing Cells and Cell Ranges

(3)

Cell References

(1)

Referencing a Range of Cells

(1)

Naming a Cell or Range of Cells

(2)

Creating and Using Formulas

(2)

Formula Syntax

(1)

Arithmetic Operators and Operator Precedence

(1)

Using Excel's Built-In Functions

(12)

Examples of Statistical Functions

(1)

Examples of Trigonometric Functions

(2)

Example of Matrix Operations

(3)

Examples of Financial Functions

(2)

Absolute and Relative Cell References

(3)

Excel Error Messages

100

(1)

Debugging Excel Worksheets

100

(3)

Debugging by Using Cell Selection

100

(3)

Debugging by Using Tracing

103

(1)

Using Macros to Automate Computations

103

(13)

Recording a Macro

104

(1)

Executing a Macro

105

(1)

Editing a Macro

105

(11)

Working with Charts

116

(52)

Introduction

116

(1)

Using the Chart Wizard to Create a Chart

117

(9)

Creating an XY Scatter Chart

117

(5)

Creating a Line Chart

122

(4)

Creating a Chart by Using a Shortcut Key

126

(2)

Formatting Charts

128

(16)

Formatting Markers and Lines

129

(1)

Chart Title and Labels

130

(3)

Formatting the Plot Area

133

(1)

Formatting Axes

133

(4)

Formatting the Legend

137

(3)

Formatting Gridlines

140

(2)

Annotating a Chart

142

(1)

Changing Chart Types

143

(1)

Previewing and Printing Charts

144

(2)

Adding Data to Charts

146

(10)

Adding Data to an Existing Series

146

(4)

Adding a Data Series to an XY Scatter Chart

150

(6)

Charting Features Useful to Engineers

156

(12)

Adding a Trendline to a Chart

156

(2)

Adding Error Bars to a Chart

158

(1)

Using a Log Scale Axis

158

(1)

Using Secondary Axes

159

(9)

Performing Data Analysis

168

(42)

Introduction

168

(1)

Using the Analysis Toolpak

169

(1)

Creating a Histogram

169

(6)

Providing Descriptive Statistics

175

(4)

Computing a Correlation

179

(3)

Performing a Linear Regression

182

(3)

Trend Analysis

185

(10)

Trend Analysis with Data Series

186

(2)

Trend-Analysis Functions

188

(2)

Trend Analysis for Charts

190

(5)

Using the Goal Seeker

195

(2)

Using Solver for Optimization Problems

197

(13)

Introduction to Microsoft Excel Solver

197

(1)

Setting Up an Optimization Problem in Excel

198

(1)

Linear Optimization Example

199

(4)

Nonlinear Optimization Example

203

(7)

Database Management Within Excel

210

(14)

Introduction

210

(1)

Database Terminology

211

(1)

Creating Databases

211

(1)

Entering Data

212

(1)

Sorting a Database

213

(1)

Searching and Filtering

214

(10)

Filtering with the Data Entry Form

214

(1)

Using the AutoFilter Function

215

(1)

Using the Custom AutoFilter

215

(2)

Using Wild-Card Characters

217

(1)

Using the Advanced Filter Function

218

(1)

Logic within Rows

219

(1)

Logic between Rows

219

(5)

Collaborating with Other Engineers

224

(25)

The Collaborative Design Process

224

(1)

Microsoft Excel and Collaboration

225

(1)

Tracking Changes

225

(3)

Highlighting Changes

225

(1)

Creating an Identity

226

(1)

Incorporating or Rejecting Revisions

227

(1)

Adding Comments to a Document

228

(1)

Maintaining Shared Workbooks

229

(4)

Sharing a Workbook

229

(1)

Keeping a Change History

230

(1)

Timed Updates

230

(1)

Managing Conflicts

231

(1)

Personal Views

231

(1)

Merging Workbooks

231

(1)

Viewing the History of Changes

232

(1)

Restrictions for Shared Workbooks

232

(1)

Password Protection

233

(2)

Open Protection

233

(1)

Write Protection

234

(1)

Sheet Protection

234

(1)

Importing and Exporting Data from External File Formats

235

(14)

Importing by Using the File Open Option

236

(1)

Importing Text Data by Using the Text Import Wizard

237

(12)

Excel and the Worldwide Web

249

(12)

Engineering and the Internet

249

(1)

Accessing the Worldwide Web from within Excel

250

(1)

Websites Related to Microsoft Excel

251

(1)

Retrieving Data by Using a Web Query

252

(2)

Accessing Excel Files on the Web

254

(1)

Creating Hyperlinks within a Worksheet

255

(2)

Converting a Worksheet to a Web Page

257

(4)

Appendix A

261

(2)

Index

263

RENT TEXTBOOKS

Introduction to Excel 2004

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products