Microsoft Excel 2003 Module I

Excel 2003 Module I provides competency in creating and modifying workbooks; manipulating worksheet data= by applying mathematical formulas and functions; and creating comments, graphi= cs, diagrams and charts.

Guided, step-by-step labs provide opportunities to practice new skills. You can challenge yourself and reinfo= rce your skills after each lesson in the Lesson Summary and Lesson Review secti= ons, and the Activities and Optional Labs. Additional skill review is provided in Lesson Quizzes and a Course Assessment that are available from your instruc= tor. =

This course book includes a supplemental CD-ROM containing the lab files used in class. To practice the skills prese= nted in class or to try any labs that were not completed, refer to the Classroom Setup section for information about system requirements and using the lab files.

Topics

C= reating and Modifying Workbooks

Overview of Workbooks and Worksheets = =

Entering Data =

Editing and Deleting Data =

Filling Cells =

Navigating Worksheets =

Finding and Replacing Data =

Copying Worksheet Data =

Moving Worksheet Data =

M= anipulating Worksheet Data

Manipulating Worksheet Data =

Creating Formulas =

Editing Formulas =

Using Cell References =

Using Functions =

Using the Function Wizard =

Filtering Data =

Sorting Data =

U= sing Comments, Graphics, Diagrams and Charts

Using Comments, Graphics, Diagrams and Charts

Working with Comments =

Working with Graphics =

Working with Diagrams =

Working with Charts =

Target Audience

This course targets individuals interested in learning the features of Microsoft Excel 2003.

Prerequisites

This course assumes a basic knowledge of the Microsoft Windows operating environment