Excel 2002: Level 1

Course length: 1 day

Course Description
Overview: Students will create, edit, format and print basic worksheets and charts in Excel.

Prerequisites: To ensure your success, you must have a strong working knowledge of the Windows environment. For example, you should know how to launch an application, create and save files, and copy files from CDs and other media. The Software Training courses Windows 98: Introduction, Windows ME: Introduction, Windows 2000: Introduction  and Windows XP: Introduction teach these skills.

Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits: Students will learn how to use an electronic spreadsheet to create basic worksheets and charts.

Target student: The target student for this course is a user who has worked with personal computers and used Windows to manage information, run programs, and access the Web. It is also intended for those preparing to pursue certification as Microsoft Office User Specialists (MOUS) in Excel.

Performance-Based Objectives: Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

• You will create a basic worksheet by entering text and values.
• You will work with cells and cell data by using a variety of moving and copying techniques.
• You will perform calculations on data by using functions and formulas.
• You will change the appearance of worksheet data by using a variety of formatting techniques.
• You will use a variety of techniques to manipulate multiple worksheets in a workbook.
• You will create and modify a chart by using various charting techniques.
• You will apply numerous page display settings to prepare a worksheet for printing.

Course Content

Lesson 1: Getting Started

          Topic 1A: Identify What You Can Do with Excel

          Topic 1B: Enter Data in a Worksheet

          Topic 1C: Edit Data

          Topic 1D: Change Text Appearance

          Topic 1E: Save a Workbook

          Topic 1F: Obtain Help

Lesson 2: Editing Your Worksheet

          Topic 2A: Move Data to Other Cells

          Topic 2B: Copy Data to Other Cells

          Topic 2C: Fill Cells with a Series of Data

          Topic 2D: Insert and Delete Rows and Columns

          Topic 2E: Undo and Redo an Entry

          Topic 2F: Find and Replace Numbers

          Topic 2G: Enter Data in a Range

          Topic 2H: Verify Data in a Range

Lesson 3: Performing Calculations

          Topic 3A: Sum a Range of Data

          Topic 3B: Use a Built-in Function

          Topic 3C: Copy a Formula

          Topic 3D: Create an Absolute Reference

Lesson 4: Formatting

          Topic 4A: Specify Numeric Format

          Topic 4B: Create a Custom Numeric Format

          Topic 4C: Change Font Size and Type

          Topic 4D: Create and Apply Styles

          Topic 4E: Add Borders to Cells

          Topic 4F: Find and Replace Formats

          Topic 4G: Change Column Width and Row Height

          Topic 4H: Align Cell Contents

          Topic 4I: Merge and Split Cells

          Topic 4J: Apply an AutoFormat

Lesson 5: Working with Multiple Worksheets

          Topic 5A: Format Worksheet Tabs

          Topic 5B: Reposition Worksheets in a Workbook

          Topic 5C: Copy Worksheets

          Topic 5D: Change the Number of Worksheets

Lesson 6: Creating and Modifying Charts

          Topic 6A: Create a Chart

          Topic 6B: Modify Chart Items

          Topic 6C: Format a Chart

          Topic 6D: Change the Chart Type

Lesson 7: Setting Page Display and Printing Options

          Topic 7A: Freeze and Unfreeze Rows and Columns

          Topic 7B: Set Print Titles

          Topic 7C: Set Page Margins

          Topic 7D: Create a Header and Footer

          Topic 7E: Change Page Orientation

          Topic 7F: Insert and Remove a Page Break

          Topic 7G: Print a Range