Microsoft® Office Excel 2003: Level 1

Prerequisites

To ensure your success, we recommend you first take the following PC University course or have equivalent knowledge: Microsoft Office Windows XP: Introduction. If you have taken an introductory course for an earlier version of the Windows operating system, this will also meet the prerequisite.

Course Content

Lesson 1: Getting Started with Excel

An Overview of Excel

Navigate in Excel

Select Data

Enter Data

Save a Workbook

Lesson 2: Modifying a Worksheet

Move and Copy Data Between Cells

Fill Cells with Series of Data

Edit Cell Data

Insert and Delete Cells, Columns, and Rows

Spell Check a Worksheet

Lesson 3: Performing Calculations

Create Basic Formulas

Calculate with Functions

Using Order of Operation

Copy Formulas and Functions

Absolute vs. Relative Cell References

Create an Absolute Reference

Lesson 4: Formatting a Worksheet

Change Font Size and Type

Add Borders and Color to Cells

Change Column Width and Row Height

Apply Number Formats

Lesson 6: Printing Workbook Contents

Set a Print Title (Repeat Column and Row Titles)

Create a Header and a Footer

Set Page Margins

Change Page Orientation

Insert and Remove Page Breaks

Print a Range

Lesson 7: Using Help

Using the Ask A Question Box

Using the Office Assistant Appendix

Using On Line Help Appendix

Using Off Line Help Appendix

Return to Table of Contents