Amazon no longer offers textbook rentals. We do!

Microsoft Excel 2002

by: SHELLY/CASHMAN/QUASNEY

Microsoft Excel 2002

by: SHELLY/CASHMAN/QUASNEY

ISBN 13:
9780789562784
ISBN 10:
0789562782
Edition: 1st
Format: Paperback
Copyright: 09/07/2001
Publisher: Course Technology
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

Part of the highly successful Shelly Cashman Series, Microsoft Excel 2002 Complete Concepts and Techniques provides step-by-step instructions accompanied by full-color screen shots, helping students learn basic through advanced Excel 2002 skills quickly and easily.

Creating A Worksheet and Embedded Chart

Objectives

(3)

What is Microsoft Excel?

(1)

Project One - Dynamite Music Fourth Quarter Sales

(1)

Starting and Customizing Excel

(3)

The Excel Worksheet

(2)

The Worksheet

(1)

Worksheet Window

(4)

Menu Bar

(1)

Standard Toolbar and Formatting Toolbar

(2)

Formula Bar

(1)

Status Bar

(1)

Speech Recognition and Speech Playback

(1)

Selecting a Cell

(1)

Entering Text

(5)

Entering the Worksheet Titles

(2)

Correcting a Mistake While Typing

(1)

AutoCorrect

(1)

Entering Column Titles

(1)

Entering Row Titles

(1)

Entering Numbers

(2)

Calculating a Sum

(1)

Using the Fill Handle to Copy a Cell to Adjacent Cells

(4)

Determining Row Totals

(2)

Formatting the Worksheet

(7)

Fonts, Font Color, Font Size, and Font Style

(1)

Bolding a Cell

(1)

Increasing the Font Size

(1)

Changing the Font Color of a Cell

(1)

Centering the Worksheet Title across Columns

(1)

Formatting the Worksheet Subtitle

(1)

Using AutoFormat to Format the Body of a Worksheet

(2)

Using the Name Box to Select a Cell

(2)

Adding a 3-D Column Chart to the Worksheet

(3)

Saving a Workbook

(4)

Printing a Worksheet

(1)

Quitting Excel

(1)

Starting Excel and Opening a Workbook

(1)

AutoCalculate

(2)

Correcting Errors

(3)

Correcting Errors While You Are Typing Data into a Cell

(1)

In-Cell Editing

(1)

Undoing the Last Entry

(1)

Clearing a Cell or Range of Cells

(1)

Clearing the Entire Worksheet

(1)

Excel Help System

(3)

Obtaining Help Using the Ask a Question Box on the Menu Bar

(2)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(1)

In the Lab

(5)

Cases and Places

Formulas, Functions, Formatting, and Web Queries

Objectives

(3)

Introduction

(1)

Project Two - Greenback Stock Club

(3)

Starting and Customizing Excel

(1)

Entering the Titles and Numbers into the Worksheet

(2)

Entering Formulas

(7)

Order of Operations

(1)

Entering Formulas Using Point Mode

(2)

Copying the Formulas Using the Fill Handle

(2)

Smart Tags

(1)

Determining the Totals Using the AutoSum Button

(1)

Determining the Total Percent Gain/Loss

(1)

Using the AVERAGE, MAX, and MIN Functions

(9)

Determining the Average of a Range of Numbers

(1)

Determining the Highest Number in a Range of Numbers

(2)

Determining the Lowest Number in a Range of Numbers

(3)

Copying the AVERAGE, MAX, and MIN Functions

(1)

Saving the Workbook

(1)

Verifying Formulas Using Range Finder

(1)

Formatting the Worksheet

(22)

Changing the Font and Centering the Worksheet Title

(3)

Changing the Worksheet Title Background and Font Colors and Applying an Outline Border

(1)

Applying Formats to the Column Titles

(1)

Centering the Stock Symbols and Formatting the Dates and Numbers in the Worksheet

(1)

Formatting Numbers Using the Formatting Toolbar

(3)

Underlining the Row above the Title Row and Bolding the Total Row Titles

(1)

Formatting Numbers Using the Format Cells Command on the Shortcut Menu

(3)

Formatting Numbers Using the Percent Style Button and Increase Decimal Button

(1)

Conditional Formatting

(3)

Changing the Widths of Columns and Heights of Rows

(1)

Changing the Widths of Columns

(3)

Changing the Heights of Rows

(2)

Checking Spelling

(2)

Saving a Workbook a Second Time Using the Same File Name

(1)

Previewing and Printing the Worksheet

(5)

Printing a Section of the Worksheet

(2)

Displaying and Printing the Formulas Version of the Worksheet

(2)

Changing the Print Scaling Option Back to 100%

(1)

Importing External Data from a Web Source Using a Web Query

(4)

Changing the Sheet Names

(1)

E-Mailing a Workbook from within Excel

(2)

Quitting Excel and Saving the Workbook

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(2)

In the Lab

(9)

Cases and Places

What-If Analysis, Charting, and Working With Large Worksheets

Objectives

(3)

Introduction

(2)

Project Three-Awesome Intranets' Six-Month Financial Projections

(2)

Starting and Customizing Excel

(1)

Changing the Font of the Entire Worksheet to Bold

(1)

Entering the Worksheet Titles

(1)

Rotating Text and Using the Fill Handle to Create a Series

(3)

Copying a Cell's Format Using the Format Painter Button

(2)

Increasing the Column Widths and Entering Row Titles

(1)

Copying a Range of Cells to a Nonadjacent Destination Area

(3)

Using Drag and Drop to Move or Copy Cells

(1)

Inserting and Deleting Cells in a Worksheet

(3)

Inserting Rows

(2)

Inserting Columns

(1)

Inserting Individual Cells or a Range of Cells

(1)

Deleting Columns and Rows

(1)

Deleting Individual Cells or a Range of Cells

(1)

Entering Numbers with a Format Symbol

(1)

Saving the Workbook

(1)

Freezing Worksheet Titles

(2)

Entering the Projected Revenue

(1)

Displaying the System Date

(3)

Absolute Versus Relative Addressing

(2)

Entering a Formula Containing Absolute Cell References

(1)

Making Decisions - The If Function

(5)

Entering the Remaining Projected Expense and Net Income Formulas for January

(1)

Copying the Projected January Expenses and Net Income Formulas to the Other Months

(1)

Determining the Projected Total Expenses by Category and Total Net Income

(1)

Unfreezing Worksheet Titles and Saving the Workbook

(1)

Formatting the Worksheet

(11)

Formatting the Numbers

(2)

Formatting the Worksheet Titles

(2)

Displaying the Drawing Toolbar

(1)

Moving and Docking a Toolbar

(1)

Adding a Drop Shadow to the Title Area

(1)

Formatting the Category Row Titles and Net Income Row

(2)

Formatting the Assumptions Table

(1)

Hiding the Drawing Toolbar and Saving the Workbook

(1)

Adding a 3-D Pie Chart to the Workbook

(11)

Drawing a 3-D Pie Chart on a Separate Chart Sheet

(4)

Formatting the Chart Title and Data Labels

(1)

Changing the Colors of the Slices

(2)

Exploding the 3-D Pie Chart

(1)

Rotating and Tilting the 3-D Pie Chart

(2)

Adding Leader Lines to the Data Labels

(1)

Renaming and Reordering the Sheets and Coloring Their Tabs

(2)

Checking Spelling, Saving, Previewing, and Printing the Workbook

(2)

Checking Spelling in Multiple Sheets

(1)

Previewing and Printing the Workbook

(2)

Changing the View of the Worksheet

(3)

Shrinking and Magnifying the View of a Worksheet or Chart

(1)

Splitting the Window into Panes

(2)

What-If Analysis

(4)

Goal Seeking

(2)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(1)

In the Lab

(10)

Cases and Places

WEB FEATURE Creating Static and Dynamic Web Pages Using Excel

Introduction

(3)

Using Web Page Preview and Saving an Excel Workbook as a Static Web Page

(6)

Web Page Preview

(2)

Saving a Workbook as a Static Web Page to a New Folder

(2)

Viewing the Static Web Page Using Your Browser

(2)

Saving an Excel Chart as a Dynamic Web Page

(5)

Viewing and Manipulating the Dynamic Web Page Using Your Browser

(1)

Modifying the Worksheet on a Dynamic Web Page

(2)

Web Feature Summary

(1)

What You Should Know

(1)

In the Lab

Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks

Objectives

(3)

Introduction

(2)

Project Four-Pay-Less Financial Services Loan Analysis

(3)

Starting and Customizing Excel

(1)

Changing the Font Style of the Entire Worksheet

(1)

Entering the Section Title, Row Titles, and System Date

(2)

Adding Borders to a Range

(3)

Formatting Cells Before Entering Values

(1)

Entering the Loan Data

(1)

Creating Cell Names Based On Row Titles

(6)

Determining the Loan Amount

(1)

Determining the Monthly Payment

(1)

Determining the Total Interest and Total Cost

(1)

Entering New Loan Data

(1)

Using a Data Table to Analyze Worksheet Data

(7)

Creating a Percent Series Using the Fill Handle

(1)

Entering the Formulas in the Data Table

(1)

Defining the Data Table

(2)

Formatting the Data Table

(1)

Adding a Pointer to the Data Table Using Conditional Formatting

(3)

Creating an Amortization Schedule

(11)

Changing Column Widths and Entering the Titles

(1)

Creating a Series of Integers Using the Fill Handle

(1)

Entering the Formulas in the Amortization Schedule

(4)

Entering the Total Formulas in the Amortization Schedule

(2)

Formatting New Loan Data

(1)

Entering New Loan Data

(2)

Adding a Hyperlink to the Worksheet

(5)

Assigning a Hyperlink to an Embedded Graphic

(3)

Displaying and Printing a Hyperlinked File

(1)

Printing Sections of the Worksheet

(5)

Setting Up to Print

(1)

Printing a Section of a Worksheet Using the Set Print Area Command

(2)

Naming Print Areas

(2)

Protecting the Worksheet

(3)

Formula Checking

(2)

Background Formula Checking

(1)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(1)

In the Lab

(6)

Cases and Places

Creating, Sorting, and Querying a Worksheet Database

Objectives

(3)

Introduction

(1)

Project Five - GPS Golf Cart Distributorship Database

(3)

Starting and Customizing Excel

(1)

Creating a Database

(6)

Setting Up a Database

(2)

Naming a Database

(1)

Entering Records into the Database Using a Data Form

(4)

Moving from Field to Field in a Data Form

(1)

Adding Computational Fields to the Database

(8)

Adding New Field Names and Determining the % of Quota

(2)

Using Excel's VLOOKUP Function to Determine Letter Grades

(3)

Redefining the Name Database

(3)

Guidelines to Follow When Creating a Database

(1)

Using a Data Form to View Records and Change Data

(1)

Sorting a Database

(5)

Sorting the Database in Ascending Sequence by Company Name

(1)

Sorting a Database in Descending Sequence by Company Name

(1)

Returning a Database to Its Original Order

(1)

Sorting a Database on Multiple Fields

(2)

Sorting a Database on More than Three Fields

(1)

Displaying Automatic Subtotals in a Database

(5)

Zooming Out on a Worksheet and Hiding and Showing Detail Data in a Subtotaled Database

(1)

Removing Subtotals from the Database

(1)

Finding Records Using a Data Form

(3)

Using Wildcard Characters in Comparison Criteria

(1)

Using Computed Criteria

(1)

Filtering a Database Using AutoFilter

(5)

Removing AutoFilter

(1)

Entering Custom Criteria with AutoFilter

(2)

Using a Criteria Range on the Worksheet

(3)

Creating a Criteria Range on the Worksheet

(1)

Filtering a Database Using the Advanced Filter Command

(2)

Extracting Records

(2)

Creating an Extract Range and Extracting Records

(2)

More about Comparison Criteria

(2)

A Blank Row in the Criteria Range

(1)

Using Multiple Comparison Criteria with the Same Field

(1)

Comparison Criteria in Different Rows and Under Different Fields

(1)

Using Database Functions

(1)

Printing the Worksheet and Saving the Workbook

(2)

Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Learn It Online

(1)

Apply Your Knowledge

(1)

In the Lab

(9)

Cases and Places

Creating Templates and Working with Multiple Worksheets and Workbooks

Objectives

(3)

Introduction

(2)

Project Six - Grand Enterprises Incorporated Statement of Financial Condition

(1)

Starting and Customizing Excel

(1)

Creating the Template

(4)

Changing the Font to Bold and Changing the Column Widths of the Template

(1)

Entering the Template Title and Row Titles

(1)

Entering Dummy Data in the Template

(1)

Determining Totals

(2)

Saving the Template

(1)

Formatting the Template

(10)

Formatting the Template Titles

(1)

Assigning a Comma Style Format to Nonadjacent Ranges

(1)

Creating and Assigning a Customized Format Code

(3)

Creating and Applying a Style

(2)

Applying a Style

(1)

Spell Checking, Saving, and Printing the Template

(1)

Alternative Uses of Templates

(1)

Creating a Workbook from a Template

(12)

Adding a Worksheet to a Workbook

(1)

Copying the Contents of a Worksheet to Other Worksheets in a Workbook

(2)

Modifying the Western Division Sheet

(1)

Modifying the Central Division Sheet

(1)

Modifying the Eastern Division Sheet

(1)

Referencing Cells in Other Sheets in a Workbook

(1)

Entering a Sheet Reference

(1)

Modifying the Consolidated Sheet

(4)

Drawing the 3-D Cylinder Chart

(4)

Formatting the 3-D Cylinder Chart

(1)

Adding a Chart Title Using the WordArt Tool

(7)

Adding a Text Box and Arrow to the Chart

(3)

Adding Comments to a Workbook

(2)

Adding a Header, Changing the Margins, and Printing the Workbook

(10)

Printing All the Worksheets in the Workbook

(1)

Printing Nonadjacent Worksheets in a Workbook

(2)

Page Breaks

(1)

Hiding Page Breaks

(2)

The Find and Replace Commands

(4)

The Find Command

(2)

The Replace Command

(1)

Closing the Workbook

(1)

Consolidating Data by Linking Workbooks

(6)

Searching for and Opening Workbooks

(1)

Creating a Workspace File

(2)

Consolidating the Data

(1)

Updating Links

(1)

Closing All Workbooks at One Time and Quitting Excel

(1)

Project Summary

(1)

What You Should Know

(1)

Learn in Online

(1)

Apply Your Knowledge

(1)

In the Lab

(6)

Cases and Places

INTEGRATION FEATURE Linking an Excel Worksheet to a Word Document and Web Discussions

Introduction

(2)

Opening a Word Document and an Excel Workbook

(1)

Linking an Excel Worksheet to a Word Document

(3)

Printing and Saving the Word Document with the Linked Worksheet

(1)

Editing the Linked Worksheet

(2)

Quitting Word and Excel

(1)

Saving the Word Document as a Web Page and Using a Discussion Server

(4)

Replying to a Comment on a Discussion Server

(2)

Integration Feature Summary

(1)

What You Should Know

(1)

In the Lab

APPENDIX A Microsoft Excel Help System

Using the Excel Help System

(1)

Ask a Question Box

(1)

The Office Assistant

(3)

Showing and Hiding the Office Assistant

(1)

Turning the Office Assistant On and Off

(1)

Using the Office Assistant

(1)

The Microsoft Excel Help Window

(3)

Using the Contents Sheet

(1)

Using the Answer Wizard Sheet

(1)

Using the Index Sheet

(1)

What's This? Command and Question Mark Button

(2)

What's This? Command

(1)

Question Mark Button

(1)

Office on the Web Command

(1)

Other Help Commands

(1)

Activate Product Command

(1)

Lotus 1-2-3 Help Command

(1)

Detect and Repair Command

(1)

About Microsoft Excel Command

(1)

Use Help

APPENDIX B Speech and Handwriting Recognition and Speech Playback

Introduction

(1)

The Language Bar

(4)

Buttons on the Language Bar

(1)

Customizing the Language Bar

(3)

Speech Recognition

(4)

Getting Started with Speech Recognition

(2)

Using Speech Recognition

(1)

Handwriting Recognition

(3)

Writing Pad

(2)

Write Anywhere

(1)

On-Screen Keyboard

(1)

Speech Playback

Customizing Speech Playback

APPENDIX C Publishing Office Web Pages to a Web Server

Using Web Folders to Publish Office Web Pages

(1)

Using FTP to Publish Office Web Pages

(1)

APPENDIX D Resetting the Excel Toolbars and Menus

(1)

APPENDIX E Microsoft Office User Specialist Certification Program

What is MOUS Certification?

(1)

Why Should You Get Certified?

(1)

The MOUS Exams

(1)

How Can You Prepare for the MOUS Exams?

(1)

How to Find an Authorized Testing Center

(1)

Shelly Cashman Series MOUS Web Page

(1)

Microsoft Excel 2002 User Specialist Certification Core and Expert Maps

Index

(1)

Quick Reference Summary

Amazon no longer offers textbook rentals. We do!

Microsoft Excel 2002

Microsoft Excel 2002

9780789562784

0789562782

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Microsoft Excel 2002

Microsoft Excel 2002

9780789562784

0789562782

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products