# Essentials: Excel 2002 Level 1 (Color Edition) / Edition 1

ISBN-10: 0130094781

ISBN-13: 9780130094780

Pub. Date: 12/18/2001

Publisher: Pearson

## Product Details

ISBN-13:
9780130094780
Publisher:
Pearson
Publication date:
12/18/2001
Series:
Essentials Ser.
Edition description:
Custom
Product dimensions:
8.30(w) x 10.80(h) x 0.50(d)

PROJECT 1. GETTING STARTED WITH EXCEL.

Lesson 1. Exploring the Excel Work Area.
Lesson 2. Entering Text and Numbers.
Lesson 3. Saving a Workbook.
Lesson 4. Getting Help.
Lesson 5. Entering a Formula.
Lesson 6. Preparing a Worksheet for Printing.
Lesson 7. Printing a Worksheet.
Lesson 8. Closing a File and Exiting Excel.

PROJECT 2. MODIFYING A WORKSHEET.

Lesson 1. Opening an Existing Worksheet.
Lesson 2. Selecting Worksheet Items.
Lesson 3. Using AutoFill.
Lesson 4. Inserting and Deleting Rows and Columns.
Lesson 5. Copying and Moving Cell Contents.
Lesson 6. Using AutoSum.
Lesson 7. Copying a Formula - Relative References.
Lesson 8. Spell-Checking a Worksheet.

PROJECT 3. IMPROVING WORKSHEET APPEARANCE.

Lesson 1. Formatting Numbers.
Lesson 2. Aligning Cell Contents.
Lesson 3. Changing Font and Font Size.
Lesson 4. Applying Bold, Italic and Underline.
Lesson 7. Using Format Painter.
Lesson 8. Removing Formatting.

PROJECT 4. ENTERING FORMULAS.

Lesson 1. Operators and Order of Precedence.
Lesson 2. Using Type-and-Point to Enter Formulas.
Lesson 3. Comparing Absolute/Relative References.
Lesson 4. Copying a Formula - Absolute Reference.
Lesson 5. Freezing and Splitting Worksheet Display.
Lesson 6. Hiding and Unhiding Rows and Columns.
Lesson 7. Displaying Formulas.
Lesson 8. Changing File Name, Type or Location.

PROJECT 5. WORKING WITH FUNCTIONS.

Lesson 1. Using AVERAGE, MAX and MIN.
Lesson 2. Calculating a Payment using PMT.
Lesson 3. Creating a Loan Payment Table.
Lesson 4. Evaluating Investments with FV.
Lesson 5.Using IF to Display Messages.
Lesson 6. Using IF to Calculate.
Lesson 7. Using NOW to Display the Current Date.
Lesson 8. Using Dates in Calculations.

PROJECT 6. SORTING, FILTERING AND EDITING LISTS.

Lesson 1. Using an Excel List as a Database.
Lesson 2. Sorting Records on One Field.
Lesson 3. Sorting Records on Two or More Fields.
Lesson 4. Using AutoFilter with One Condition.
Lesson 5. Using Custom AutoFilter: OR Criteria.
Lesson 6. Using Custom AutoFilter: AND Criteria.
Lesson 7. Using a Form to Add and Delete Records.
Lesson 8. Using a Form to Edit Records.

PROJECT 7. WORKING WITH CHARTS.

Lesson 1. Identifying Chart Types and Features.
Lesson 2. Creating an Embedded Pie Chart.
Lesson 3. Creating an Embedded Column Chart.
Lesson 4. Changing the Chart Type.
Lesson 5. Charting Non-Adjacent Data Series.
Lesson 6. Modifying Chart Formats.
Lesson 7. Adding, Reordering and Deleting Series.
Lesson 8. Creating a Combination Chart.

PROJECT 8. DEVELOPING A MULTIPLE-SHEET WORKBOOK.

Lesson 1. Copying Data from Another Application.
Lesson 2. Inserting, Moving, Renaming Worksheets.
Lesson 3. Grouping/Editing Multiple Worksheets.
Lesson 4. Subtotaling Data.
Lesson 6. Applying Conditional Formatting.
Lesson 7. Setting a Print Area.
Lesson 8. Saving a Worksheet/Chart as a Web Page.