203-220-2218
skip to the main content area of this page
Training: Course Outline

2008 Training Schedules

To register call:
1-203-220-2218

Excel 2003, Introduction

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Audience

This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, who already have knowledge of the Microsoft® Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2003 worksheets.

Prerequisites
  • Microsoft Windows 2000/XP, Introduction

Course Contents
  • Getting Started with Excel
    • An Overview of Excel
    • Navigate in Excel
    • Select Data
    • Enter Data
    • Save a Workbook
    • Obtain Help
  • Performing Calculations
    • Create Basic Formulas
    • Calculate with Functions
    • Copy Formulas and Functions
    • Create an Absolute Reference
  • Developing a Workbook
    • Format Worksheet Tabs
    • Reposition Worksheets in a Workbook
    • Insert and Delete Worksheets
    • Copy and Paste Worksheets
    • Copy a Workbook
  • Printing Workbook Contents
    • Set a Print Title
    • Create a Header and a Footer
    • Set Page Margins
    • Change Page Orientation
    • Insert and Remove Page Breaks
    • Print a Range
  • 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
    • Find, Replace, and Go To Cell Data
    • Spell Check a Worksheet
  • Formatting a Worksheet
    • Change Font Size and Type
    • Add Borders and Color to Cells
    • Change Column Width and Row Height
    • Merge Cells
    • Apply Number Formats
    • Create a Custom Number Format
    • Align Cell Contents
    • Find and Replace Formats
    • Apply an AutoFormat
    • Apply Styles
  • Printing Workbook Contents
    • Set a Print Title
    • Create a Header and a Footer
    • Set Page Margins
    • Change Page Orientation
    • Insert and Remove Page Breaks
    • Print a Range
  • Customizing Layout
    • Split a Worksheet
    • Arrange Worksheets
    • Freeze and Unfreeze Rows and Columns
    • Hide and Unhide Worksheets

Student Responsibilities
In order for a class to be successful, all students should share the same general level of knowledge and experience. If a participant does not demonstrate these, the instructor will take the necessary steps either to prepare the participant or place him/her in a more appropriate course. This policy is intended to maintain the high level of quality control that you have come to expect.
<< Back to Schedule